Thread: How do I copy text and values from the same workbook onto a different sheet??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kjcramp
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote