Excel VBA - help with selecting

[atlantis_sweet]

I have to make a query statement for a search criteria.
I am going to get a start date and end date from the user using date picker.
I wanted to select all the rows and copy them into a new sheet based on a date range from a column which has date.

I am not able to come up with a query statement. Is there an easy way to do it? I am new in VBA, so any help in this regard will be really appreciated.

Thanks in advance.

[DKenny]

You really don't need a query to do this. Write a procedure that performs the following steps.
1/ Get the Start and End Dates
2/ Sort the source data by the Date column
3/ Find the first instance of the Start Date and record the row number
4/ Find the last instance of the End Date and record the row number
5/ Copy all the data between these rows
6/ Create a new worksheet
7/ Paste the data to the new sheet

[atlantis_sweet]

Thanks for the reply. can you help with the procedure? I am new to VBA as I said before, so I am finding it difficult to get the code for the procedure.

Thanks once again for your reply.

[DKenny]

Of course I can help with the procedure, everyone here can. But you need to try it first, then post specific questions here when you get stuck. Trial and error is one of the best learning techniques there is, reading the VBA help files is one of the other best ways.

Start by reading the help file on the SORT method of the RANGE object in Excel. This will help with step 2.
Then read the help on the FIND method of the RANGE object. this will help with steps 3 and 4.
Then the COPY method.
Then the NEW method of the worksheets collection.
Then the PASTE method.

I'm not trying to be difficult here, but if you don't try it yourself first you probably wont understand the code I give you and will not learn anything by the experience.

[atlantis_sweet]

Thanks for the help. I will try to get the code done and will buzz you.
Once again thanks.