Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
format move
like do a copy and paste of the found item
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
format move
Because I want the formatting to come with? HELP
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I move addresses in my contacts into an excel format? | Excel Worksheet Functions | |||
Format Shape, will not move accordingly, when deleting columns | Excel Discussion (Misc queries) | |||
How can I move spreadsheets to contain same format and spacing | Excel Discussion (Misc queries) | |||
Can I format columns to move across a spreadsheet? | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions |