Merging data from 2 workbooks

  • Follow


Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

How can I merge data into 1? <br><br>Some of the data Names are the same but I need to combine amounts in the other cells
0
Reply jdwww 3/21/2010 3:06:48 PM

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


On 22/03/10 2:06 AM, in article 59bb5a72.-1@webcrossing.JaKIaxP2ac0,
"jdwww@officeformac.com" <jdwww@officeformac.com> wrote:

> 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:john@mcghie.name


0
Reply John 3/22/2010 1:26:41 AM


1 Replies
331 Views

(page loaded in 0.03 seconds)

Similiar Articles:
















7/24/2012 4:01:50 PM


Reply: