One option is to select the data first, before you execute the macro. In the
macro, deal with Selection, rather than a hard-coded range.

--
Regards,
Fred


"zetty" wrote in message
...
I have two excel workbooks that sort data by date. I need to send the data
from one to the other each day for reporting. I need to create a macro to
look at a different column of data each time it is run.