I need to create a macro for my spreadsheet. I will try to attach a sample of it if required and if someone can tell me how to do it. This may aid my description of what I want to do.
Basically I need to run a check which does the following:
If J2 = “X” – then select F2 and paste special
If J3 = “X” – then select F3 and paste special
And so on
I basically want it to look for all complete items in Column J – and remove the formula for that row in Column F and paste the value over the top of it.
For any incomplete columns in J (Defined as “”) I need the formula to remain in column F for that row.
I will set this up as a macro which runs upon closure of workbook so any coding to do this would be much appreciated.
Thanks in advance