| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cell value that changes previously entered value
Dear All,
I receive a spreadsheet where B1:B4 has either of F1, P1, F9, P9. Column A is for me to enter either 'YES' or 'NO'. If I enter 'NO' in any of A1:A4 I need a corresponding B1:B4 cell be changed to show 'F1 rejected', P1 rejected' and so on. Any help with VBA code (as I understand is needed) would be greatly appreciated. Entering 'YES' should not change B1:B4 existing value. Thanks, Art |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect cells based on Date and previously entered data | Excel Programming | |||
| Excel ignoring previously entered formulas | Excel Worksheet Functions | |||
| Retrieving previously entered userform data from saved spreadsheet | Excel Programming | |||
| Selecting Previously Active Cell | Excel Programming | |||
| Selection the previously selected cell | Excel Programming | |||
Threaded Mode
