This is another request for VB code help.. Following my other thread, I think I need someone to write this for me (as I've come to the conclusion that although I'm proud, I'm also rubbish at coding!! 
)..
This is what I need my excel sheet to do:
Column A: Set
Cloumn B: Type
Column C: Unit
Columns: D through to K 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 use the change event by Type and if Type A, then put in *cell reference* and *cell reference* a value of "N/A" as not relevant and if it's Types B to G then put in *cell reference* and *cell reference* a value of "N/A" as not relevant. . I have tried to sort this out myself and have received some very good advice, but I just can't seem to expand it with my knowledge to get this spreadsheet to do what I want..
).. This is what I need my excel sheet to do:
Column A: Set
Cloumn B: Type
Column C: Unit
Columns: D through to K 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 use the change event by Type and if Type A, then put in *cell reference* and *cell reference* a value of "N/A" as not relevant and if it's Types B to G then put in *cell reference* and *cell reference* a value of "N/A" as not relevant. . I have tried to sort this out myself and have received some very good advice, but I just can't seem to expand it with my knowledge to get this spreadsheet to do what I want..
