Windows 7 - Merging data from 2 workbooks
Asked By jdww
21-Mar-10 11:06 AM
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
Word
(1)
Webcrossing.JaKIaxP2ac0
(1)
Leopard
(1)
Writer
(1)
Pty
(1)
Mailto
(1)
John McGhie replied to jdww
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
http://www.cpearson.com/excel/DefinedNames.aspx
Hope this helps
On 22/03/10 2:06 AM, in article 59bb5a72.-1@webcrossing.JaKIaxP2ac0,
--
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
EXCEL WORKBOOK Windows 7 Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel MAC Office Excel Discussions Word (1) Webcrossing.JaKIaxP2ac0 (1) Leopard (1) Writer (1) Pty (1) Mailto (1) Which functions can you use? What happens when restart the computer? Cheers On 2 / 03 / 10 3:28 PM, in article 59bb3b39.-1@webcrossing.JaKIaxP2ac0, This email is my business email - - Please do not email me about forum matters 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
Excell Windows 7 Version: Older version Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Is it possible to match identical data between two or more columns? MAC Office Excel Discussions Excel (1) Word (1) Webcrossing.JaKIaxP2ac0 (1) Leopard (1) Writer (1) Pty (1) Mailto (1) Yes. Maybe. No. Depends :-) Your question is too answer at all Cheers On 5 / 03 / 10 2:54 PM, in article 59bb3f39.-1@webcrossing.JaKIaxP2ac0, This email is my business email - - Please do not email me about forum matters 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
Comments in Excel Windows 7 Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there a way to anchor a comment to a specific point in a spreadsheet? MAC Office Excel Discussions Excel (1) Word (1) Webcrossing.JaKIaxP2ac0 (1) Leopard (1) Writer (1) Pty (1) Mailto (1) Does the Excel Help topic "Add or remove a comment" cover it? On 10 / 04 / 10 2:36 AM, in article 59bb6be9.-1@webcrossing.JaKIaxP2ac0, - - 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
Spellingscheck Windows 7 Operating System: Mac OS X 10.5 (Leopard) Office Word cannot find my spellingscheck in Dutch. . .do I have to install everything all over? MAC Office PowerPoint Discussions PowerPoint (1) Office (1) Word (1) Webcrossing.JaKIaxP2ac0 (1) Spellingscheck (1) Leopard (1) Re-installing is rarely the first (or second or third) option to consider & often Jones [MVP] Office:Mac On 3 / 26 / 10 10:35 AM, in article 59bb6024.-1@webcrossing.JaKIaxP2ac0, keywords: Spellingscheck description: Operating System: Mac OS X 10.5 (Leopard) Office Word cannot find
Install new font type Windows 7 Operating System: Mac OS X 10.5 (Leopard) How can I install a new font type in Powerpoint? MAC Office PowerPoint Discussions Microsoft Word (1) Office (1) Word (1) Webcrossing.JaKIaxP2ac0 (1) Powerpoint (1) Leopard (1) Corsiva (1) Arial (1) You do not install fonts in applications. Use the OS Jones [MVP] Office:Mac On 3 / 26 / 10 10:33 AM, in article 59bb6023.-1@webcrossing.JaKIaxP2ac0, I installed new fonts (Hebrew) using Font Book, and they validated OK. But they do