I have a workbook with 3 tabs each with a table of data - Daily Data, Weekly Data & Monthly Data and a tab with my raw source data.
I have dropdowns on each to select the month and department (above the word "Automotive", don't know why they didn't show up in my html maker)
Excel 2007
On the Daily tab, there will be 4 sections, Week1, Week2, etc. which I need to pull the data from my source table. I need for all of the sections to change the data when a new month and/or department is selected. If I can get some VBA to do this, the others (Weekly, Monthly rollups) should follow the same process I'm assuming. What is the best way to do this? VLOOKUP just seemed very time consuming so was hoping there was a VBA method (Offset?) that would be better. I will be working with about 4 months of source data at any given time.
Thanks for any help.
I have dropdowns on each to select the month and department (above the word "Automotive", don't know why they didn't show up in my html maker)
| Excel Workbook | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | AUTOMOTIVE | |||||||
| 5 | NOVEMBER | WEEK 1 | ||||||
| 6 | Date | 11/1/2010 | 11/2/2010 | 11/13/2011 | 11/4/2010 | 11/5/2010 | ||
| 7 | Total Demand | |||||||
| 8 | Total Shipped | |||||||
| 9 | Total Open | |||||||
Sheet2 | ||||||||
On the Daily tab, there will be 4 sections, Week1, Week2, etc. which I need to pull the data from my source table. I need for all of the sections to change the data when a new month and/or department is selected. If I can get some VBA to do this, the others (Weekly, Monthly rollups) should follow the same process I'm assuming. What is the best way to do this? VLOOKUP just seemed very time consuming so was hoping there was a VBA method (Offset?) that would be better. I will be working with about 4 months of source data at any given time.
Thanks for any help.
