Good Morning to All,



I am seeking assistance regarding transfer of data from sheet 1 (master list) to other sheets in the workbook.

Sheet 1: Master Inventory List

1. Column A through Column R, with headers.
2. Column F is focal point of sorting by category, ie; computer, laptop, printer, scanner, digital sender, unknown.

What I would like to do is pull data from the master list, using key words "Computer or any of the sorted data" from column F. Transfer that data along with column A through Column R from each ROW to a new sheet, labeled after the sorted Data from column F

Thank you,