Hi, 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

Software/Hardware used: