Yes, but you need to be more specific for a macro, however you can link the
contents of one cell on a worksheet to another by formula

Say you wish to link Sheet1 Range A5 in another sheet then use

=Sheet1!A5

wherever you wish the contents of Sheet1 A5 to appear.




--

Regards,
Nigel




"Rachel" wrote in message
...
Hi,

I have this lookup table where there are 5 columns. The data for this
worksheet is embeded in a different worksheet in the same workbook. The
last
column is intended for remarks, is there a way to have a macro code to
insert
remarks column that will be uploaded in a seperate worksheet? THANKS!