Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for editing a field
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro for editing a field
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Editing | New Users to Excel | |||
Macro editing | Excel Discussion (Misc queries) | |||
Editing a macro | Excel Discussion (Misc queries) | |||
Editing a Macro | Excel Discussion (Misc queries) | |||
Editing Macro | Excel Discussion (Misc queries) |