referencing from one worksheet to another

[sheryn_qinyu]

Hi,
how do u write a macro that links one cell in a spreadsheet to anothe
cell in a second spreadsheet?

Tk

 

[John Wilson]

sheryn,

Are you sure that you want a macro solution to this???

To reference another sheet in a formula, just use this context:
=Sheet3!A1
if it's actually in a different workbook, then
=[book2.xls]Sheet3!A1

John

 

[Guest]

If the value is always going to be contained in the same
cell, i.e the value is always in sheet 2 cell b4, and you
want that value in sheet 1 cell b14, then I would suggest
the following;
In sheet 1, cell B14, enter: =Sheet2!B4
Other wise you may need to use a lookup to retrieve your
data.