Search Wooksheet

[Glenn Robertson]

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.....

 

[Ed]

Glenn:

Try recording a macro in which you use the AutoFilter to set the criteria
for a certain result. Then modify the macro to use three Input Boxes to put
the name and dates into three strings. Substitute these strings for your
AutoFilter criteria, and you'll see your results. Then copy what you see
and Paste Special>Visible Cells onto the blank sheet. If you have "lots of
information", an AutoFilter will show you a constrained results set faster
than iterating through every row.

Ed