Thread: summarize monthly worksheets by product

Hi, I am having a real tough time with this one. I have multiple worksheets each for a month. In each are identical products across the top and their sales/profitability underneath referencing row categories on the left. I need to create a new worksheet for each individual product to show sales/profit month over month trending.

Anyway thoughts on how to mae this easy? pivot table, index/match. I can't figure these out?



Here is an example

Worksheet Name: Jan2010
Product
A B C D
Sales 100 125 150 200
Expenses 95 95 95 95
Income 5 30 55 105

Worksheet Name: Feb2010
Product
A B C D
Sales 110 137.5 165 220
Expenses 104.5 104.5 104.5 104.5
Income 5.5 33 60.5 115.5

Worksheet Name: Mar2010
Product
A B C D
Sales 145 181.25 217.5 290
Expenses 137.75 137.75 137.75 137.75
Income 7.25 43.5 79.75 152.25

Worksheet Name: Apr2010
Product
A B C D
Sales 165 206.25 247.5 330
Expenses 156.75 156.75 156.75 156.75
Income 8.25 49.5 90.75 173.25


Now I need a separate worksheet for product A... sowing monthly trend in numbers.


Thanks in advance for any help.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!