Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing a cell value with the value from an adjacent cell.
I would like to search Column A for a value ($noname), when that value is
found, copy the data adjacent to it in Column B into Column A. Example: A B Bob blank Joe blank Ed blank $noname Fred After executing the code, the column data would be: A B Bob blank Joe blank Ed blank Fred Fred The number of entries in Column A could vary from instance to instance (each week). This would need to be added to pre-existing code that is executed as a macro. Thank you in advance for any assistance. Fleone |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force entry into cell, based on validation selection in adjacent cell | Excel Worksheet Functions | |||
How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
change current cell colour based on the value of adjacent cell on other worksheet | Excel Programming | |||
Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions |