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

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.

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

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


On Tue, 6 Feb 2007 15:42:00 -0800, zetty
wrote:

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.

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

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

"Gord Dibben" wrote:

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


On Tue, 6 Feb 2007 15:42:00 -0800, zetty
wrote:

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.

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

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.