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.