View Single Post
 
Old 06-16-2015, 10:11 AM
anvqui anvqui is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2015
Posts: 5
anvqui is on a distinguished road
Default Excel, transfer data from Master Sheet to sub sheets, using key word from column

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,
Reply With Quote