| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data from different workbooks
I am trying to add data from one workbook to data in another workbook. All
the data are in the same cells on different sheets in the two workbooks. What is the syntax I need to accomplish this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding data from different workbooks
Perhaps something like
='[Book1]Sheet1'!A1+'[Book2]Sheet2'!$A1 I wasn't sure from your post whther your adding multiples sheets in one workbook and want the result in a 2nd workbook, or transferring data from one workbook, or adding from 1 sheet from 2 different workbooks. Hopefully you'll be able to modify the formula as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bev" wrote: I am trying to add data from one workbook to data in another workbook. All the data are in the same cells on different sheets in the two workbooks. What is the syntax I need to accomplish this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding data from different workbooks
Good point! I'm adding multiple sheets in one workbook to multiple sheets in
another workbook. "Luke M" wrote: Perhaps something like ='[Book1]Sheet1'!A1+'[Book2]Sheet2'!$A1 I wasn't sure from your post whther your adding multiples sheets in one workbook and want the result in a 2nd workbook, or transferring data from one workbook, or adding from 1 sheet from 2 different workbooks. Hopefully you'll be able to modify the formula as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bev" wrote: I am trying to add data from one workbook to data in another workbook. All the data are in the same cells on different sheets in the two workbooks. What is the syntax I need to accomplish this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding data from different workbooks
If the cells are in the same spot in each workbook (add cell a1 from all
sheets) you could do =SUM('[Book1]Sheet1:Sheet3'!A5)+SUM('[Book3]Sheet1:Sheet3'!$A$6) Note that it helps to have both workbooks open when you input formula. Otherwise you'll have to enter the complete file extension into the formula. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bev" wrote: Good point! I'm adding multiple sheets in one workbook to multiple sheets in another workbook. "Luke M" wrote: Perhaps something like ='[Book1]Sheet1'!A1+'[Book2]Sheet2'!$A1 I wasn't sure from your post whther your adding multiples sheets in one workbook and want the result in a 2nd workbook, or transferring data from one workbook, or adding from 1 sheet from 2 different workbooks. Hopefully you'll be able to modify the formula as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Bev" wrote: I am trying to add data from one workbook to data in another workbook. All the data are in the same cells on different sheets in the two workbooks. What is the syntax I need to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when adding row in linked workbooks, data in receiver loses a row | Excel Worksheet Functions | |||
| Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
| Adding a Row to Multiple Workbooks | Excel Discussion (Misc queries) | |||
| Adding multiple workbooks together | Excel Discussion (Misc queries) | |||
| Adding a row in all workbooks within a spreadsheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
