software

Hi guys:

I have a commissions workbook with about 20-30 sheets. In A1 of every
sheet is a Name and in column G is a bunch of Numerical Values. I want
to create a quot;Grand Totalquot; sheet where I have the Name and the Values
corresponding from each of the sheets onto my final one. Any help
would be appreciated.--
kepcopower
------------------------------------------------------------------------
kepcopower's Profile: www.excelforum.com/member.php...oamp;userid=32752
View this thread: www.excelforum.com/showthread...hreadid=525836
Sounds like you need to create a link between the individual worksheets
and the grand total sheet. From the GT sheet, enter the = sign, then
tab to the a1 name from the first individual sheet (I'm assuming you
want to list each name on the GT). Repeat for each name, creating a
column of links for the names. Repeat for a GT total, using the
individual totals from each page.--
kjcramp
------------------------------------------------------------------------
kjcramp's Profile: www.excelforum.com/member.php...oamp;userid=32753
View this thread: www.excelforum.com/showthread...hreadid=525836
kjcramp Wrote:
gt; Sounds like you need to create a link between the individual worksheets
gt; and the grand total sheet. From the GT sheet, enter the = sign, then
gt; tab to the a1 name from the first individual sheet (I'm assuming you
gt; want to list each name on the GT). Repeat for each name, creating a
gt; column of links for the names. Repeat for a GT total, using the
gt; individual totals from each page.

Is there a formula way rather than going back and forth through 20-30
sheets. I have 3 workbooks I have to do this on, so I have close to
100 worksheets to deal with.--
kepcopower
------------------------------------------------------------------------
kepcopower's Profile: www.excelforum.com/member.php...oamp;userid=32752
View this thread: www.excelforum.com/showthread...hreadid=525836