Summary Tab

[DOF2001]

hello to all,

I been task to create a sumary table from a very long spread sheet.

the sheet contain many tabs color code by date. there are multiple values in each tab which are in the same cells, in all tabs. so wha ti need is to add a summary tab that will add all values based on color tab or based on the 4 first characters in the tabs name.
The file will conctantly chnages (numbers of tabs) the only constants are the location of the values i need to add and the first 4 characters of each tab name.

any input is appreciated.

Thank you

Dof

 

[RonB1111]

This link explains how to sum across multiple sheets:
Sum the Same Cell in Multiple Microsoft Excel Worksheets

If you can keep like colored tabs together, the 2nd part of this link's description would be something like =SUM(FirstRed:LastRed!A2) and =SUM(FirstGreen:LastGreen!A2) and etc.

 

[DOF2001]

Ron,

Thank you for your prompt response, this will save me a lot of time and hassle if i can make it work.

Thanks again

Dof2001