I've been trying to get my head round this, tried doing find and replaces, IF and non of them really doing what I want to achieve.
We've got a spreadsheet(Sample attached) if column anything in Column A = H then on that row in column J put in for example xxx
If Column A = D then in Column E put in zzz
I recorded a macro which was just me typing them in but the problem is that there may be 1000 lines and the macro I recorded was dependant on how many lines I actually did.
If you can help that would be great.