If all the weekly and YTD totals are in the same place on each sheet, you can
use a 3D formula on the Grand Total sheet to sum them all
=SUM(Sheet1:Sheet10!A1)
"Lillie" wrote:
Good afternoon. Currently, I have created a 10 worksheet excel document.
Each worksheet belongs to a sales rep in our company. The worksheet totals
the sales that they have had first for the week total and then there
year-to-date total. My problem is that I now need to use all 10 pages to
total into a new worksheet (with grand totals) and I am having problems doing
so.
I welcome all assistance with this problem. I have been reading by Excel
study guide, however, I am still at a lost.
Thank you.
|