Hi,

I have a requirement. I have 3 excel files (eg., One.xls, Two.xls and Three.xls) and one master file (Master.xls). Column C in the 3 files have dates in them. I want to run a macro in the master file which asks the user for a date and collates all data corresponding to that particular date from the 3 files and appends them to the master file.
For eg.
One.xls :
AAA 123 10/12/2012
AAA 456 11/12/2012
AAA 234 12/12/2012

Two.xls :
BBB 345 10/12/2012
BBB 567 11/12/2012
BBB 543 12/12/2012

Three.xls :
CCC 789 10/12/2012
CCC 987 11/12/2012
CCC 321 12/12/2012

On running the macro in Master.xls the user is asked to enter a the start date and end date via a Message box (or via 2 text boxes in the sheet) and suppose he enters 10/12/2012 and 11/12/2012, then in Master.xls the appended data should be :

AAA 123 10/12/2012
AAA 456 11/12/2012
BBB 345 10/12/2012
BBB 567 11/12/2012
CCC 789 10/12/2012
CCC 987 11/12/2012

The data in the Master file should be appended each time the macro is run.
Can anyone help me with a macro for this task ?

Ben