copy values based on date
 

in data.xls:
column A are dates sorted ascending not unique.
Column B are part numbers
in choice.xls
i want to bring over the values from data.xls in column B IF column A is
between dates:
D1 beginning date & E1 ending date

Im just not sure how to exlude the values i dont want

thanks in advance

copy values based on date
 

Do you need to do this in VBA or just get the job done?

You can use Data/AutoFilter with a custom filter to select just the dates that
are in range. Then you can copy the visible cells from column B (or A and B)
to wherever you like.

On Tue, 25 Jan 2005 20:31:01 -0800, choice
wrote:

in data.xls:
column A are dates sorted ascending not unique.
Column B are part numbers
in choice.xls
i want to bring over the values from data.xls in column B IF column A is
between dates:
D1 beginning date & E1 ending date

Im just not sure how to exlude the values i dont want

thanks in advance