Adding data from different workbooks

B

Bev

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?
 
L

Luke M

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.
 
B

Bev

Good point! I'm adding multiple sheets in one workbook to multiple sheets in
another workbook.

Luke M said:
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 said:
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?
 
L

Luke M

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 said:
Good point! I'm adding multiple sheets in one workbook to multiple sheets in
another workbook.

Luke M said:
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 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top