Copy filtered data & paste formatted in a new workbook

[BorisMKD]

Hi guys,

I would like to copy only the filtered data with 'YES' into a new workbook,
but the catch is that some data from the fileds in the first workbook have to show together in one field in the second workbook.

All fields in 'AREA' have to be shown as one code in 'AREA' in the second table
All fields in 'Equipment' have to be shown as one code in 'Equipment' in the second table
All fields in 'Subgroup' have to be shown as one code in 'Subgroup' in the second table

If its possible, then how can I put the filltering in the same macro too?

Thanks, Boris

[davesexcel]

Perhaps in the workbook Standardlist2 you could show the desired results