Hi there,
I'm trying to create a report sheet in Excel 2003 so that it extracts data from a large list into a table specific by year (which can be changed by the user), and with different sections separated by month. Here's the sheet attached:
yearly summary test1.xls
The list is the first tab and the second tab is the report 'Yearly Summary'. In the second worksheet the year is contained in B1, with each month in that year being a "mini table". My goal is to eventually get it so that it extracts the data, then create a macro that hides blank rows automatically...but I'm struggling even with the first part!
Taken from another sheet I've tried to get it so that the Z number from the first worksheet is extracted in "Yearly Summary" cell C5 to 8 if it is occuring in January, and then my intention was to create it so that it extracted it just when it was in January AND the year inputted into cell B1. However, for whatever reason I can't even get it to extract the data just based on the month yet. Can anyone help?
Thank you!
Bookmarks