Merging data from 2 workbooks

J

jdwww

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel How can I merge data into 1?

Some of the data Names are the same but I need to combine amounts in the other cells
 
J

John McGhie

Sorry, I do not understand: your question does not have enough detail.

See the excel help topic "Use names in formulas" for more.

You CAN use "Sheet-scoped data names" if you define them that way, but
"don't" because it can make your formulas very confusing. See
http://www.cpearson.com/excel/DefinedNames.aspx

Hope this helps


Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
How can I merge data into 1?

Some of the data Names are the same but I need to combine amounts in the other
cells

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 

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