Archive of Mr Excel Message Board


Back to Data in Excel archive index
Back to archive home

Confused and bewildered

Posted by Paul on September 13, 2001 2:03 AM
Hi,

I'm struggling a little bit.

I'm trying to create a new template worksheet that i can insert into any workbook.

I would like this worksheet to add the contents of cells in the workbook - although some of the totlas will be created by adding two or more cells spanning several workshhets. I thought i had this formula cracked (=SUM(SoR Data!$E$19) )but once i tried to simply copy the cell and its contents into an existing workbook it didn't work.

I know the names of the worksheets that i want to check and use to create my total and i know the cell that i want to use. Should i be able to use the formula above and excel will recognise the worksheets name?

Am i going about this the wrong way? Should i try to incorperate the formula into VB code? How do i do that?

As you can see i'm toying with several ideas.
Any help would be appreciated.

Thanks in advance.

Paul


Re: Confused and bewildered

Posted by lenze on September 13, 2001 6:44 AM
Have a look a Data >Consolidation. This works very well when you know the workbooks and cell locations of data you wish to consolidate.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.