PC Review


Reply
Thread Tools Rate Thread

Adding from 2 spreadsheets

 
 
=?Utf-8?B?V2VsdGhleQ==?=
Guest
Posts: n/a
 
      13th Sep 2007
I currently have 2 spreadsheets. I need to have a value from Spreadsheet B
automatically add into the value on Spreadsheet A. Is there an easy way to
do this without someone have to put in the + into the formula bar?
 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      13th Sep 2007
Do you mean can it be done without a formula? - No
Or do you mean will the formula work automatically? - Yes
In B1 of FileA: =A1+[FileB.xls]Sheet1!A1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Welthey" <(E-Mail Removed)> wrote in message
news:2D5C0CF9-66DA-4A1C-A7E6-(E-Mail Removed)...
>I currently have 2 spreadsheets. I need to have a value from Spreadsheet B
> automatically add into the value on Spreadsheet A. Is there an easy way
> to
> do this without someone have to put in the + into the formula bar?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Shapes to Spreadsheets Buckeye Bill Microsoft Excel Misc 1 8th May 2008 08:17 PM
Spreadsheets--Adding Quantities =?Utf-8?B?V2hpdGVT?= Microsoft Excel Worksheet Functions 4 28th Nov 2006 06:15 PM
How do I create a macro for adding spreadsheets? =?Utf-8?B?S3Jpc3RpbiBmcm9tIE5ZUw==?= Microsoft Excel Programming 1 5th May 2006 05:37 PM
Adding rows in linked spreadsheets Parcey Microsoft Excel Misc 1 28th Dec 2005 06:28 AM
Adding Values Across Spreadsheets Donalbain@gmail.com Microsoft Excel Discussion 4 4th Jan 2005 04:49 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:11 AM.