Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Lee_Wrede
 
Posts: n/a
Default 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   Report Post  
Fred Smith
 
Posts: n/a
Default

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   Report Post  
Lee Wrede
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
how to create a variable column in cell reference Sampson Excel Worksheet Functions 3 February 21st 05 11:13 PM
Cell Reference Math Ralph Howarth Excel Worksheet Functions 0 January 26th 05 07:27 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 08:16 PM
name of another worksheet in cell for reference Tom A Johnson Excel Worksheet Functions 2 November 12th 04 12:28 AM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"