Thread: How do I get a macro in excel to look at different data each time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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.

Reply With QuoteReply With Quote