referencing from one worksheet to another

S

sheryn_qinyu

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

Tk
 
J

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
 
G

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.
 
Top