I have an issue that is pretty difficult for me to explain. I am looking to put together a monthly sales report that has two worksheets, a data worksheet and a report worksheet. The data worksheet contains all the data for each month, hence the name. The way I have it setup is that each item is a column and each month is a row. On my report sheet I have the previous 6 months in columns and our items in rows. The issue is that to transfer the data from the data worksheet to the reports worksheet would require a good junk of time (we have 150+ different items/categories). What I’m trying to figure out is a way that I can simply change the title row (the previous month) on the reports sheet and it matches all the data for that month on the data worksheet. So for example at the end of this month when I go to do my sales report I imput my data into my data worksheet, I then simply change the header row for the most recent month to “October 2009” and it matches all the data from the “October 2009” row on the data worksheet.
Any ideas?
Bookmarks