I have a workbook called “May 2011 Stats”, inside May 2011 Stats I have worksheet for each day of the month, 1,2,3,4,5,6,7,8,9,10,11,...,31. I should also mentioned that there is a workbook for every month for the past three years. More will be created for each month going forward. And each workbook has a different number worksheets to reflect the number of days in that month.
I have another workbook called “weekly reports”, I need to find away to bring the data from every worksheet in every workbook, and save that data to a cell that is located under a heading reflecting that date the data comes from. This data will then needed to saved, and will be referenced back to from time to time.
After I bring in all of data from each day of each month, I will then have to create a weekly total, this data is the reflected on a line graph.
How can I do this, please included as much information as possible.
If you have any other questions or need something made clearer, please just ask.
Thank you..
I have another workbook called “weekly reports”, I need to find away to bring the data from every worksheet in every workbook, and save that data to a cell that is located under a heading reflecting that date the data comes from. This data will then needed to saved, and will be referenced back to from time to time.
After I bring in all of data from each day of each month, I will then have to create a weekly total, this data is the reflected on a line graph.
How can I do this, please included as much information as possible.
If you have any other questions or need something made clearer, please just ask.
Thank you..
