Good day,

How would this be accomplished using VBA:

Search a column for data

If data is found, copy the data to another cell.
---------

Currently I am just copying a column range and pasting it using VBA. But this copies and pastes the specified range whether data is present or not. Any Ideas?

Your time is sincerely appreciated.