Labour intensive setting up all those checkboxes
Use a small macro and 'x' in cell.
The macro reads the number of rows - no on sheet formula to expand or maintain.
Either run the macro 'TRANSFER' from the macro-reader or press the green button to place the filtered data on sheet 2.
torachan.
Bookmarks