Based on the Code # I need to be able to total Each of the other data across multiple sheets (50+). Each Sheet contains a group of 6 entries of the data as shown.
I'm assuming you have 50+ sheets is because each sheet has a unique name attached to it. Why not just create one sheet, one table and add an extra column to hold what is the sheet name? Summing data in tables is orders of magnitude easier than having to deal with 50+ worksheets.
I have 1 Workbook with roughly 25+ sheets. Each sheet is a basic time sheet with 6 entries containing the data as listed. I am wanting to make a Totals Sheet that will Total data per the appropriate accounting Code# 1 thru 10. The formula would look at all sheets current and future, compile totals in the same format as listed per each accounting Code#.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
