Pulling Data

[Justin8511]

I've got a question that I absolutely cannot figure out.

I am making a fairly large spreadsheet for a business where data is calculated daily. The main page where the data is entered is a Weekly Page (M-S). There are a total of 9 Tabs, Weekly {Where all data is entered}, Mon, Tues, Wed, Thurs, Fri, Sat, Sun {Where Data is automatically dropped}, and Monthly. Here lays the problem... Ideally, I would like the data to automatically drop into the Monthly Page. However, the dates on the Weekly Page change every week. I need the data to drop into the correct dates on the Monthly Sheet, even after the initial Week Page is reset.

Any suggestions.....?

Thanks,
Confused

 

[BrianB]

I think that your basic method is flawed. You will find everything a lot better to handle by putting all your data into a single table. You will therefore require an additional column for "Day".

You will then be able to get Excel to do most of the hard work when analysing the data by using things like pivot tables. You can still show a daily summary if required.