MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Confused and bewildered

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


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.


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.