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.
Bookmarks