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

[kepcopower]

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.

[kjcramp]

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.

[kepcopower]

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.

[vlady]

If the layout on all of those sheets are same you could try.
enter all names of the sheet then name it as say tabnames

Please Login or Register  to view this content.