Copy data from input box date range

[miyage]

Hi. I hope someone can easily resolve my problem. I would like to create an input box/user form to accept a START DATE(dd/mm/yyyy) then another one to accept an END DATE(dd/mm/yyy). Using these dates as parameters, I would like to search my Table worksheet based on the dates inputed and copy certain data/columns into Sheet1. Start column in Table worksheet is sorted.

Eg User inputs 02/05/2008(start) and 28/05/2008 via input box or user form.

Table Worksheet:

Start Name Cost
01/05/2008 Mr.Smith $100
03/05/2008 Mr. James $50
.
.
.
31/12/2008 Mr. Beam $120

From the dates inputed, copy rows from Table worksheet to Sheet1 (starting in row 10 in Sheet 1) thats within the date range inputted.

Any help will be appreciated. Thanks.

 

[Bilbo_Baggins_Esq]

This of course would require some VBA coding, but the exact content of which would be dependent on the layout/content/location of the fields you wish to copy to sheet1.

If you search the forums, you'll find some EXCELLENT examples of various form code, how to build one, and how to make the code find your desired lookup row and then copy your desired fields to sheet1.