Create separate workbooks based upon automatic filtering

Hi guys, hope you can help.

Please find attached a workbook containing fictional figures but containing formulae to extract information from the individual sheets (Employee 1 to Employee 5) to the Salary summary and Pay Remittance sheets.

What I'm looking for is to create a separate workbook for each employee containing all the information on the Pay Remittance sheet when the value in cell L1 matches the dates in A10:A23 and also for the macro to run through all of the options in the drop down box in cell B3.

Please note, this was created in Excel 2007, but need it to work in Excel 2010.

Thanks, as always in advance.

Hi guys.

Anyone able to provide a solution to this one?
Is a possible stumbling block technically asking it to perform two filters simultaneously for each employee?

I would be really grateful of any assistance with this.

Hi Jaslake,

The ideal file naming will be the 11111.pdf, 22222.pdf, 333.pdf etc i.e. contents of pay remittance sheet G3 (which will change when the filter in cell b3 is applied). They will be saved to a folder called remittances on the desktop.

Kind Regards,

Hi Jaslake,

Apologies, I thought I replied earlier...

My original message thanked you for taking the time to look into this for me.

My feedback was that after assigning the range Salary Summary! A7:A11 as Employees, it failed at the following step:

.Range("A10:F" & SrcLR).AutoFilter Field:=1, Operator:= _
xlFilterValues, Criteria2:=Array(1, TgtWs.Cells(1, "L").Value)Kind Regards and thanks again for your help.

Hi Jaslake, Thanks for your reply.

I'm on leave until Friday, will respond fully then.

Hi Jaslake,

Please find attached my offending file. It still falls down at the same place.

Many Thanks.