If user enters X in say, Cell F4, I then need Cells A6:A10 and A12:A20 to auto populate with N/A. I know how to create the macro to auto fill manually but how can I make it update automatically the cells to N/A if X is marked in other cell? Thank you!
Bookmarks