Consolidation or not?
I have a workbook with 25 sheets, each one relates to an item with specific contacts, information and date based sales etc.
Each Monday, when I get the new sales figures for each item, I input them individually into each sheet.
What I have been trying to achieve (without success) is a "Results Sheet" with the latest weekly totals from all of the other sheets. That way, whenever I need the latest figures, I can just look at the one sheet and see all of them at a glance.
As I am typing this post another idea has occurred to me.
Is it possible to type the information into the one "Results Sheet" and have that populate the individual sheets on the next available row down in the column, ie "Date" and "Sales". The "Percent" and "Left" cells would be calculated by a formula in the individual sheets. That way I only need to open the one sheet from the start.
Attached is a small example of my sheets (with spurious figures)
Many thanks for any help/advice on this.
Rob
|