macro for editing a field

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!
 
N

Nigel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database macro 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel 2013 Merge Data 2
VBA insert column with two workbooks open 1
Need Macro... 8
VBA - retrieve data on last create named range from previous inserted named range 0
macro to control tabs (different worksheets) 8
Macro to create report 1

Top