A
Andrew Finlayson
OK, here's the setup.
I have a workbook containing around 80 worksheets. Each worksheet is
formatted identically, containing sales data. Column 1 of each worksheet is
a Date column, with the months that stocktakes were performed.
I also have a summary sheet, in which I would like to display the same data
as on the individual worksheets, totalled by month.
e.g. Worksheet named "Bondi 1007" might read
DATE SALES RETURNS ORDERS
Mar 03 $100000 $7000 $6000
Jul 03 $167389 $5677 $4088
Worksheet "Gymea 2290" might read
DATE SALES RETURNS ORDERS
Mar 03 $15000 $500 $400
Oct 03 $7500 $450 $350
Summary Sheet would therefore read
DATE SALES RETURNS ORDERS
Mar 03 $115000 $7500 $6400
Jul 03 $167389 $5677 $4088
Oct 03 $7500 $450 $350
"Simple" you say!. Well hold on a second, because in the worksheets the
same months do NOT all appear in the same row. So, for example, the Bondi
sheet might have Mar 03 in Column 1, Row 5 whilst for the Gymea store Mar
03 might be in Column 1, Row 3.
So, how do I sum all the individual store sheet entries, and also count the
number of the entries summed, so as to appear correctly on the summary page?
Thanks in advance,
Andrew Finlayson
Brisbane, Australia
I have a workbook containing around 80 worksheets. Each worksheet is
formatted identically, containing sales data. Column 1 of each worksheet is
a Date column, with the months that stocktakes were performed.
I also have a summary sheet, in which I would like to display the same data
as on the individual worksheets, totalled by month.
e.g. Worksheet named "Bondi 1007" might read
DATE SALES RETURNS ORDERS
Mar 03 $100000 $7000 $6000
Jul 03 $167389 $5677 $4088
Worksheet "Gymea 2290" might read
DATE SALES RETURNS ORDERS
Mar 03 $15000 $500 $400
Oct 03 $7500 $450 $350
Summary Sheet would therefore read
DATE SALES RETURNS ORDERS
Mar 03 $115000 $7500 $6400
Jul 03 $167389 $5677 $4088
Oct 03 $7500 $450 $350
"Simple" you say!. Well hold on a second, because in the worksheets the
same months do NOT all appear in the same row. So, for example, the Bondi
sheet might have Mar 03 in Column 1, Row 5 whilst for the Gymea store Mar
03 might be in Column 1, Row 3.
So, how do I sum all the individual store sheet entries, and also count the
number of the entries summed, so as to appear correctly on the summary page?
Thanks in advance,
Andrew Finlayson
Brisbane, Australia