Hi all,
What I'm trying to do is change the contents of a cell if that particular column is not relevant (based on Type).. I don't want to put a formula in the actual cell as I need it for possible data entry.. Is there a procedure or macro that would do this more effectively?..
My column headers are (the information is stored in rows):
Column A: Set
Cloumn B: Type
Column C: Unit
Columns: D through to H are only relevant to certain Types and those that are not, I have used conditional formatting so if the result is N/A the cell is 'blocked out' (which I have to enter manually).. I would like Excel to 'lookup'? Type and if A, then block out *cell reference* and *cell reference* as not applicable and if it's Type B then block out this *cell reference* and *cell reference* etc.. The main problem being there are 5 different types..
Please help!.. I'm useless at coding!!.. Please see the below, hence my change in my request for someone to please write the code for me as I'm struggling!!..
Bookmarks