Looking for VBA to sort workers
http://i819.photobucket.com/albums/z...ps473c86c9.jpg
Workbook has 2 sheets.
Sheet 1 has all the data.
Workers in col A and the amount of rows changes.
Categories are listed in B1:X1.
Sheet 2 has a validation dropdown in cell A1.
It references a named range from sheet 1 (B1:X1)
Workers have info under different categories.
From sheet 2 I would like to choose a name from the dropdown in A1.
The macro would search categories on Sheet 1 that match dropdown.
Then copy the worker's entire row... only if they have info under that category.
Row would be copied to sheet 2 starting in cell A3.