Pete Mccann
Member
Hello, I have some numeric data contained in two worksheets in a workbook. I would like a macro that consolidates (sums) the data from these two sheets into a summary sheet. I know the very basic elements of VBA but I don't have the skills to create a macro to sum the data. Hopefully the attached spreadsheet example will explain.
List Sheet |
Will contain the Command button to consolidate the information from Data 1 and Data 2 sheet |
Data 1 Sheet |
Contains up to 13 sets of data (Location 1 to Location 13) with 6 sets of information per location (maybe more) but the data will be in the sheet |
4 sets of data shown in the example |
Data 2 Sheet |
Contains up to 13 sets of data (Location 1 to Location 13) with 3 sets of information per location (maybe more) but the data will be in the sheet |
4 sets of data shown in the example |
Summary Sheet |
This contains the consolidated (summed) data. |
For example, Cell C3 in the summary sheet contains the summed data from (Stage 1, Type A from Location 1 + Stage 1, Type A from Location 2 etc). |
I would like to set up a macro command that sums the "Type X" data from each Stage column for each Location and places the result in the Summary sheet. |