Hi everyone,

I have a very messy data sheet I'm trying to clean up. I've done everything except the following:

If any column in range A1:BB500 has at least one cell with a value in it, then all other blank cells in that column will have (fill) pasted into it. If there are no values in a column within that range, then nothing happens.

Any ideas?

Thanks!!