How do I copy text and values from the same workbook onto a different sheet??
 

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 "Grand Total" 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: http://www.excelforum.com/member.php...o&userid=32752
View this thread: http://www.excelforum.com/showthread...hreadid=525836

How do I copy text and values from the same workbook onto a different sheet??
 

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: http://www.excelforum.com/member.php...o&userid=32753
View this thread: http://www.excelforum.com/showthread...hreadid=525836

How do I copy text and values from the same workbook onto a different sheet??
 

kjcramp Wrote:
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.

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: http://www.excelforum.com/member.php...o&userid=32752
View this thread: http://www.excelforum.com/showthread...hreadid=525836