format move
 

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

format move
 

like do a copy and paste of the found item

format move
 

Hi
why not use VLOOKUP for this?
See: http://www.mvps.org/dmcritchie/excel/vlookup.htm

--
Regards
Frank Kabel
Frankfurt, Germany


dumb wrote:
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

format move
 

Because I want the formatting to come with? HELP

format move
 

Hi
and what should happen if the values in the lookup range change or the
formating changes from the 'linked' cell?

--
Regards
Frank Kabel
Frankfurt, Germany


dumb wrote:
Because I want the formatting to come with? HELP

format move
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


dumb wrote:
Beacuse I am trying to copy and paste it would change.