Can you please help? I have a monthly report.
Worksheets for each month, each row is a type of fruit (column A), and the number sold (column B).
A new worksheet is added each month with the information.
I also have a Summary worksheet - running total of all months: Type of Fruit (column A), Number sold (column B), and Total of all fruits - number sold.
I would like a formula for the Summary worksheet - to match that fruit (column A) to any of the other worksheets - matching the fruit (column A), and bring back the number sold (column B). (note some apples are Fuji and some are Honey crisp - those would be totaled together)
Thank you
ex:
Tab = Jan 14
Fuji apples 3
Bananas 2
grapes 9
TOTAL 14
Tab = Feb 14
apricots 7
honeydew 22
honey crisp apples 17
TOTAL 46
Tab = Mar 14
Strawberries 58
TOTAL 58
Tab = Summary
apples 127
bananas 111
honeydew 220
apricots 557
etc
TOTAL 5440
Bookmarks