copy data

[abdjed]

Hi
I've data in sheet"Data", and like to:
1- copy all data if the birth date (in Column D) less or equal to certain date to sheet (birth_date)
2- copy all data if the Graduate_date (in Column E) less or equal to certain date to sheet (Graduate_date)

Regards

[dangelor]

Possibly...

Please Login or Register  to view this content.

[abdjed]

Thank you,
Working great, but how I can use cells to enter each of dates (cell for each one)?

[dangelor]

Try...

Please Login or Register  to view this content.

Change the ranges to whatever works for you. Suggest you add Data Validation to those cells to accept only dates.

[abdjed]

It works, I'm doing some changes as needed. appreciate your help

[dangelor]

Glad I could help!

[abdjed]

Hi,

Try...Option Explicit
<= or />=

Sorry for bothering you again.

1- I need to use this as a variable in the cell with the date. (So, no need to change the code each time)
For example
<= 01/01/1980 or >= 01/01/1980
2- I want to renumber copied rows in (birth_date) sheet.

[dangelor]

Possibly...

Please Login or Register  to view this content.

[abdjed]

yes, it works.
But after adding a big data, I found that it's not working if there's a blank column(s) in between.

[dangelor]

Suggest you remove the blank columns. If that isn't possible, change this line of code to include all the needed data.

Please Login or Register  to view this content.

[abdjed]

Sorry for being late,
Unfortunately, it doesn't work, and the last code is copying everything include unwanted rows. I'm still trying and hope to get a solutions.

Regards

[dangelor]

Unfortunately, it doesn't work, and the last code is copying everything include unwanted rows.

Please post the code you're using.

[abdjed]

It's the one you sent it in post #10

[dangelor]

That post suggested a change to a particular line of code. Did you change it? If so, what was the change?