Help needed with coding to auto sort a table with blank cells.

[SLIDE1]

Hi and thanks for taking a look at my issue!

I am trying to automatically sort a table with blank cells.

Employee #(173 or 1445) inserted into A1 Sheet1 pulls up a list/table of tools.

Select tool by entering "X" into column C beside tool.

I am trying to make Sheet2 list/table reveal only the tools selected without having to sort out the blank cells manually.

The form clears all new data when closed/opened or clear contents of column C to clear Sheet2 table/list.

Any help would be greatly appreciated!

This is what I have now on Sheet2. No Sort.JPG This is what I am trying to accomplish without manually sorting out blank rows Sorted.JPG