I have cells using a vlookup , Can I delete the formula and leave the data only on the non blank cells.I my head it would be something like this - if(C1:C100>0,copy and paste value, do nothing ).Would need to do this in vba so I could attach it to a button or run on close , something like that.