Summary of multiple sheets
I have about 5 worksheets in 1 workbook-- the first sheet is a summary sheet
that summarizes all 5 sheets on a separate line. for Example Sheet 1-- I
summarize by the total count of orders; the orders over 10 days old and those
over 5 days old. I then do the same for the rest of the sheets. Right now
it is all done manually-- by counting. Is there a way to automate this
process to get the counts. I have to do this report atleast once a day
sometimes more.
|