Not sure which Excel Formula is needed.

[Mike_Hall_SP_PA]

In my workbook, I have 7 tabs. Tab 1 is a Summary of the next 5 tabs, Tab 7 is just dates.
All my data is stored in a separate workbook.
I have all the data being auto populated on tabs 2-6 without issue.
These tabs are a "Sunday to Saturday" look based on the date chosen in a certain cell.

On the Summary tab, is a summarize of all the other tabs but in a Week1 Week2 Week3 Week4 Week5 Look.

What I need to be able to do on the Summary tab is allow the user to choose the month, then it auto populates the Summed Week totals.
I do have an example of my sheet if needed

TIA for any help

 

[123rickfear]

Hi,

this definitely sounds possible, and it should be achievable through data validation and formula.

are you able to send me through some sample data?

Thanks

Rick

 

[Mike_Hall_SP_PA]

How do I attach the forms? I have both examples of the data and the summary sheet.

 

[123rickfear]

you will either need to save them to an online storage site, and provide the link, or you can send them to me directly. I'll send you my email address.

 

[AliGW]

You might want to re-read paragraph 2 of forum rule #4.