Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I reference a spreadsheet in a cell
I want to have one spreadsheet update a specific cell in another spreadsheet.
How do I do this? Example: Spreadsheet 1 cell G5 contains a balance Spreadsheet 2 cell B5 wants that same balance NOTE: The spreadsheets are not in the same workbook. Lee Wrede |
#2
|
|||
|
|||
The easiest way is to get Excel to do it.
Open both workbooks. In s/s 2, cell B5, hit the = key. Navigate to s/s1, cell G5. Hit Enter. Excel will create the formula something to the effect ='[file name.xls]Sheetname'!G5 -- Regards, Fred Please reply to newsgroup, not e-mail "Lee_Wrede" wrote in message ... I want to have one spreadsheet update a specific cell in another spreadsheet. How do I do this? Example: Spreadsheet 1 cell G5 contains a balance Spreadsheet 2 cell B5 wants that same balance NOTE: The spreadsheets are not in the same workbook. Lee Wrede |
#3
|
|||
|
|||
Thanks for the info. It makes it sound so simple.
Lee Wrede "Fred Smith" wrote: The easiest way is to get Excel to do it. Open both workbooks. In s/s 2, cell B5, hit the = key. Navigate to s/s1, cell G5. Hit Enter. Excel will create the formula something to the effect ='[file name.xls]Sheetname'!G5 -- Regards, Fred Please reply to newsgroup, not e-mail "Lee_Wrede" wrote in message ... I want to have one spreadsheet update a specific cell in another spreadsheet. How do I do this? Example: Spreadsheet 1 cell G5 contains a balance Spreadsheet 2 cell B5 wants that same balance NOTE: The spreadsheets are not in the same workbook. Lee Wrede |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
name of another worksheet in cell for reference | Excel Worksheet Functions |