I would like a code if anyone could help please to delete the contents of a
cell based on the data in another cell.
I would like it so that if the activecell offset by 4 = Mech, then
activecell offset by 10 is deleted.
I need it using activecell as it is all tied into a userform that opens on
various cells in column C, therefore I cannot reference a particular cell.
Any ideas
Thanks