format move

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi
and what should happen if the values in the lookup range change or the
formating changes from the 'linked' cell?
 
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
 
You must log in or register to reply here.

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

Time Calculations Help 4
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Conditional Formatting macro: simple, but doesn't work 6
auto fill cells with text if value of one cell meets specificcondition 3
Cells with varying number of lines 1
Run two macros for two different sheets 11
length of line depending on the value of the cell 13
Display entire number in cell 3

Back
Top