D
dumb
Can someone write a macro for me that would have cell A1 lookup the value in cell B1 in a table (C1 to G10) and move the found item into A1 (not coping it)
Thanks
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dumb
like do a copy and paste of the found item
F
Frank Kabel
D
dumb
Because I want the formatting to come with? HELP
F
Frank Kabel
Hi
and what should happen if the values in the lookup range change or the
formating changes from the 'linked' cell?
and what should happen if the values in the lookup range change or the
formating changes from the 'linked' cell?
F
Frank Kabel
Hi
not possible as there's no event that would indicate that there was a
change of format. So of course you could copy the value+format then the
macro runs (e.g. manually started). But there's no way to re-start this
macro automatically then the format changes
not possible as there's no event that would indicate that there was a
change of format. So of course you could copy the value+format then the
macro runs (e.g. manually started). But there's no way to re-start this
macro automatically then the format changes