How do I find like data in multiple worksheets?
 

I have multiple worksheets within 1 workbook. Each worksheet has the exact
layout. I enter multiple vendor invoices on a weekly basis on each worksheet
and would like to get a total of each vendor for the year. These totals
would come various entries from some or all worksheets.

How do I find like data in multiple worksheets?
 

You'll prb have to setup some SUMIF functions on each worksheet, but you
could then use a 3D reference to sum them all together onto your summary
sheet.

Example of 3D sum:
=SUM('Sheet1:Sheet2'!A1)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"3boys1wife" wrote:

I have multiple worksheets within 1 workbook. Each worksheet has the exact
layout. I enter multiple vendor invoices on a weekly basis on each worksheet
and would like to get a total of each vendor for the year. These totals
would come various entries from some or all worksheets.