Hi, I'm lookng for a macro that inserts data into a cell based on certain criteria. For example, I have 8 categories in Cell C5 (Project Type). If the project type selected is <> "Other" then Cell C6 should show "Not Applicable". If C5 equals (=) "Other" then Cell C6 should show as blank which would allow users to input data. Can anyone help me?
Many thanks in advance
Bookmarks