Trying to automate reporting from multiple sheets.

[tzelja219]

Hello,

I am trying to automate some work reporting that relies on multiple sheets to compile data. Currently, I have several data tabs that filter through to two tabs that display current results, however I also store and include data of "this time last week". In addition to this, I have a separate tab that organizes the data by each time interval - unlike my tables that show cumulative amounts.

What I want to do is have a main page that all the data filters to, with some option to be able to select last weeks data without having to manually copy and paste it. Is there some way to filter the old data as I have it so I can select the time frame I want? The reporting I do is every other hour. I attached an image of what the stored data table looks like for each time interval.

I'm not sure if there is an option to do this is excel, or what it would be. Please help!

Thank you.

[oeldere]

Did you consider adding all data in 1 tab (sheet) and after that using Pivot Table to analyse your data?