PLEASE HELP WITH 8-15!!!!!
ISEN 230 Homework 4 VBA code due Thursday Oct 11 before 12:45pm on e-Campus Upload to e-Campus an macro-enabled Excel file that includes your code Be ready to run it in any excel file, based on the functionality of your code on Oct 11 Place a control button in the worksheet that calls a VBA macro that processes the following sales data (your final code should work with data sheets that have more or fewer regions and more or fewer months of data). Write your code so that it runs on the active worksheet. Month Region 1 Region 2 Region 3 Region 4 1519 1504 1137 1227 1170 1696 1113 1501 1378 1601 1381 1188 1158 1598 1636 1317 1327 1331 1103 1371 1414 1351 1218 1694 1652 1301 1264 1073 1512 1752 1664 1657 1359 1801 1509 1329 1337 1052 1708 1596 1535 1856 383 617 873 636 1432 1467 1092 1096 1355 978 958 1038 1397 938 904 1210 1158 1332 1432 1399 1178 1495 1058 1272 1023 May-13 451 945 567 Oct-13 Nov-13 477 510 552 828 807 341 992 524 897 628 You can copy following data in a excel file such that value "Month" is in cell A3 and in cell A1 is your name. Using cell A3 as an anchor cell, code the following tasks in VB (Do NOT use Foir Next Loops) 1. 2. 3. Find out the number of regions with data Find out the number of months with data Format the header (Region 1, ..., Region 4) so that they are horizontally centered, have green background, bold, italic and black text. Add the word "Total" two columns after the last region in the data (see example) and on the same row of the header row. Center the text horizontally and make the background yellow, bold, italic and blue color 4. 5. Using R1C1 notationR place a formulas under the header "Total" with the sum of the sales in the regions for each of the months in the data Format the numbers for the total using the NumberFormat- "0" property for a range 6. ISEN 230 Homework 4 VBA code due Thursday Oct 11 before 12:45pm on e-Campus Upload to e-Campus an macro-enabled Excel file that includes your code Be ready to run it in any excel file, based on the functionality of your code on Oct 11 Place a control button in the worksheet that calls a VBA macro that processes the following sales data (your final code should work with data sheets that have more or fewer regions and more or fewer months of data). Write your code so that it runs on the active worksheet. Month Region 1 Region 2 Region 3 Region 4 1519 1504 1137 1227 1170 1696 1113 1501 1378 1601 1381 1188 1158 1598 1636 1317 1327 1331 1103 1371 1414 1351 1218 1694 1652 1301 1264 1073 1512 1752 1664 1657 1359 1801 1509 1329 1337 1052 1708 1596 1535 1856 383 617 873 636 1432 1467 1092 1096 1355 978 958 1038 1397 938 904 1210 1158 1332 1432 1399 1178 1495 1058 1272 1023 May-13 451 945 567 Oct-13 Nov-13 477 510 552 828 807 341 992 524 897 628 You can copy following data in a excel file such that value "Month" is in cell A3 and in cell A1 is your name. Using cell A3 as an anchor cell, code the following tasks in VB (Do NOT use Foir Next Loops) 1. 2. 3. Find out the number of regions with data Find out the number of months with data Format the header (Region 1, ..., Region 4) so that they are horizontally centered, have green background, bold, italic and black text. Add the word "Total" two columns after the last region in the data (see example) and on the same row of the header row. Center the text horizontally and make the background yellow, bold, italic and blue color 4. 5. Using R1C1 notationR place a formulas under the header "Total" with the sum of the sales in the regions for each of the months in the data Format the numbers for the total using the NumberFormat- "0" property for a range 6
