How do I get a macro in excel to look at different data each time

Z

zetty

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.
 
G

Gord Dibben

zetty

You have to let Excel know what column to do the deed upon.

What would distinguish which column is the one to look at each time it is run?


Gord Dibben MS Excel MVP
 
Z

zetty

All columns are headed by date. Can I write an "if" "then" macro that will
ask me what date to transfer?
 
F

Fred Smith

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.
 
Top