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?