| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel how do I link text values in one sheet to another sheet? | Excel Discussion (Misc queries) | |||
| Copy Macro values to new sheet | New Users to Excel | |||
| To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
Linear Mode
