Combine total items
Good day all,
I have a problem and I need an Excel expert`s help.
In an excel sheet, I have several sheets. In every page I have several items.
Many items are repeated in many sheets. Here is an example:
PM Kit for WEPA system includes these parts
- PPP x (quantity) 2
- OOO x 3
- VVV x 1
PM Kit for ZENI system includes the following parts:
- PPP x 4
- OOO x 1
- VVV x 1
What I would like to do is to find a way to know the total of PPP (2+4) other than opening every sheet and counting them manually.
I have 63 pages and some items are present in more than half of the pages.
This causes me a loss of time.
Please help me.
Thank you.
Since you have 63 sheets in
Since you have 63 sheets in your workbook; so a macro should solve it. Please upload a sample file.