Hi,

You must be doing something wrong if you say the criteria range is appearing on the target sheet.

Put the Data on one sheet, the labels you require from the data sheet (can be a subset and in a different order if you prefer) on another sheet and use this single row of labels as your Output range, and then on a third sheet just your criteria labels and values.

To upload a workbook, look just below the 'Submit Reply' button in the Additional Options area and click the 'Manage attachment buttons.

I'm away now for about 18 hours so won't be able to respond further until then, but you may find someone else chips in.

Rgds