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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy and paste non blank cells
- Thread starter jtodd
- Start date
Similar threads
- Question
