Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks. However I am getting an invalid cell error. I am typing in the
numbers/letters from the cells I want to add using the name of the books and sheets as you indicate below. If the cells I'm trying to add and place in another workbook are part of a column that contains an addition function, would that matter? Help! "Bernard Liengme" wrote: =[Book3]Sheet1!$D$1+[Book4]Sheet1!$E$1 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Shoobiloo" wrote in message ... I have 3 workbooks. I want to add numbers from workbook 1 and workbook 2 into a total in workbook 3. Is there a way to do this? If so, how? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can I Use VBA to Create New Workbook Without Links? | Excel Discussion (Misc queries) | |||
Create New Workbook from Worksheets in One Workbook | Excel Discussion (Misc queries) | |||
Taking specific rows from on workbook to create another workbook | Excel Worksheet Functions | |||
My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
How do I create a workbook that links info in cell to a calendar? | Excel Worksheet Functions |