KariJones21
New Member
- Joined
- Feb 3, 2014
- Messages
- 3
I need help....
I have a excel workbook that has different month tabs and quarter tabs. I have a selection criteria sheet, where you can pick one of the 12 months and 1 of 16 Business Units. I did this through Data validation. The on the Month tabs, there are calculations built in based on your selection criteria.
I need to do a consolidation of this data, so I need to consolidate 3 of the BU's together. I wanted to go into a new workbook and make 3 tabs, and then write a macro to copy and paste the data out of the full workbook. To do this you need to select the 3 different BU's from Selection Criteria one at a time and copy and paste the data for the current BU into the consolidated workbook, then select the next BU and do the same. I want to write a macro but the macro is not recognizing the change in the BU selected on the Pull down menu (the data validation).
Any ideas??
I have a excel workbook that has different month tabs and quarter tabs. I have a selection criteria sheet, where you can pick one of the 12 months and 1 of 16 Business Units. I did this through Data validation. The on the Month tabs, there are calculations built in based on your selection criteria.
I need to do a consolidation of this data, so I need to consolidate 3 of the BU's together. I wanted to go into a new workbook and make 3 tabs, and then write a macro to copy and paste the data out of the full workbook. To do this you need to select the 3 different BU's from Selection Criteria one at a time and copy and paste the data for the current BU into the consolidated workbook, then select the next BU and do the same. I want to write a macro but the macro is not recognizing the change in the BU selected on the Pull down menu (the data validation).
Any ideas??
