referencing from one worksheet to another

  • Thread starter Thread starter sheryn_qinyu
  • Start date Start date
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
 
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
 
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.
 
Back
Top