| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding from 2 spreadsheets
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding from 2 spreadsheets
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" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Data from Multiple Spreadsheets | Excel Worksheet Functions | |||
| Macro for Adding Lines to Linked Spreadsheets | Excel Worksheet Functions | |||
| Spreadsheets--Adding Quantities | Excel Worksheet Functions | |||
| Can Excel Spreadsheets be saved as Microsoft Works spreadsheets? | Excel Discussion (Misc queries) | |||
| Adding rows in linked spreadsheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
