I've created a sample of what I am trying to accomplish. The data is coming out of Access to Excel. I need the dates across the top of each of the 4 sets of data on my worksheet to reflect the daily dates based on the month selected in the dropdown.
Any ideas on how to do this?
Thanks for any help!
Having some trouble identifying what to search for on this one.
I have 2 dropdowns on my worksheet, 1 to select Division and 1 to select the Month.
When selections are made, data from another sheet is pulled into the rows using INDEX MATCH-this is working perfectly. I now need to have it also change the dates in the columns to reflect the Month selected. The Months are in column A and Dates are in column B on the data sheet.
5/2/11 5/3/11 5/4/11 5/5/11 5/6/11
Row 1
Row 2
Row 3
Row 4
If "April" is selected, I need the columns to pull the first and successive dates from column B that correspond to the correct month (April) in column A so that it would then look like:
4/4/11 4/5/11 4/6/11 4/7/11 4/8/11
Row 1
Row 2
Row 3
Row 4
If you could just give me a couple of keywords to search for that would be a great help! Thanks.
Toni
Bookmarks