copy values based on date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with building a formula based on cell values 3
How to copy row data from Sheet2 to Sheet1 based on Conditional Date 2
Excel conditional formatting with Weeknum 4
Open folder based on cell value 5
Excel 2 into 1 6
Keeping the date fixed 5
help: sorting rows by lesser value of two columns 1
Excel 2003 and Application.Quit 6

Back
Top