View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default 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?