How do I link cells in two different spreadsheets?
Try this exercise:
Go to a cell A1 in Sheet2
Type an equal sign (=)
Click on the Sheet1 tab (at the bottom of the screen)
Select cell A1 on Sheet1
Press the [Enter] key
Cell A1 on Sheet2 should now display:
=Sheet1!A1
There are othe options to consider, but start with that and post back with
any other questions.
Does that help?
***********
Regards,
Ron
"Randy" wrote:
I am trying to link data from a cell in one spreadsheet to a different
spreadsheet.
I want the data of a certain cell in spreadsheet 1 to show up in a certain
cell in spreadsheet 2. How is this done?
|