Hi,

I have a spreadsheet that has four tabs (Dave, Pete, Andy
& Blank) within Dave, Pete, Andy is lots of information.
Coloumn A shows a name, Column B a date and Column c show
other information.

I would like a MACRO that when clicked on it will ask me
for a Name, Start Date and End Date. When these are
entered it will search the three worksheets (Dave, Pete &
Andy) it will look for the name in column A then check
column b for dates inbetween those input. If it finds one
where the name matches and the date is inbetween those
input I want it to copy that row onto the blank sheet
etc...

Can someone help.....