Filtering Data and copying only filtered results

I want to filter the data in one Workbook based on "Department Number" which produces about 10 lines which match the filter but these are on non-sequential lines within the data. I then want to copy only these 10 lines so that I can paste them into another Workbook.
Can anyone help me please?

This would assume your criteria is in Column A.

Please Login or Register  to view this content.

Many thanks for your suggestion. I am trying to do this within a macro so I think the VB solution I have been given will be better. Thanks again

Hi John

Thanks for your help. It all works perfectly. I am a novice to VB so trying to teach myself in bits. The code you have given me is part of my answer and I will now work on the rest....... I might be back for some more help later tho

Cheers

Hi John, I said I might need more help.....
If I want to filter the "Department Number" based on a vale in a specific cell on a different sheet in the workbook, how can I do this?

Hope you can help

Paul

Not sure I understand but if I do try this:

Please Login or Register  to view this content.

This line places the copied row to the next available row.

Workbooks("Retail Timesheet MasterTemplate.xlsx").Sheets("Parameters").Range("A" & Rows.Count).End(3)(2)

I'm very busy at the moment running my monthly reports and won't be able to comply with your other requirement. If no one else helps then later I'll take a look at it.

I understand and am very appreciative.

Thanks again

Paul

Thanks for your help. I managed to sort it all out in the end. It might not be pretty but it works.

Cheers

You're welcome. Glad you got it too work.