macro for editing a field

  • Thread starter Thread starter Rachel
  • Start date Start date
R

Rachel

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