I have 3 workbooks(Service Techs 1-3) I keep records in. I have a 4th
workbook (RECAP)that I want to retrieve from. The three workbooks each
have worksheets that are labeled January - December.

In the Recap Workbook I have a worksheet where I keep the information
for the data that I want to retrieve(Data!C3:C5). From this information
I want to open the corresponding workbook(s) and insert into a sheet
with all pertaining records:

Example:

If c3=Tony and C4=January retrieve all rows with data in workbook
(TONY) from worksheet (January)

If c3=Ron and C4=January retrieve all rows with data in workbook (Ron)
from worksheet (January)


If C3=All and C4= February get information from all 3 workbooks as
above.

Hope this makes sense - I am using a drop down combo box for C3:C5
these cells will change depending on the report I want generated

PLEASE HELP!

Thanks in advance


--
parteegolfer
------------------------------------------------------------------------
parteegolfer's Profile: http://www.excelforum.com/member.php...o&userid=31951
View this thread: http://www.excelforum.com/showthread...hreadid=526278