I am working on extracting some information from an existing spreadsheet and copying the information to another sheet based on search. In column named Welder I want to extract that rows information for each individual welder initial and create a different workbook for each one. What would be the simplest way to achieve this? I am thinking Macro but don't know where to start. This is worksheet 1 from which the information will pull from.
<tbody>
</tbody>
Spool # | Activity | NDE | Size | Type | Sched. | WPS | Welder | Inspector | Weld/Insp. Date | P/F | VT | PT/MT |
4 | Weld | RT | 14" | BUTTWELD | STD | 140 | JO | Bhanson | 11/20/18 | Pass | 100% | 5% |
4 | Weld | VT | 14" | BUTTWELD | STD | 140 | JO | Bhanson | 11/20/18 | Pass | 100% | 5% |
4 | Weld | RT | 12" | BUTTWELD | STD | 140 | JO | Bhanson | 11/20/18 | Pass | 100% | 5% |
4 | Weld | VT | 12" | BUTTWELD | STD | 140 | JO | Bhanson | 11/20/18 | Pass | 100% | 5% |
8 | Weld | Brinnell | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | RT | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | VT | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | Brinnell | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | RT | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | VT | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | Brinnell | 4" | BUTTWELD | STD | 116V | A5 | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | RT | 4" | BUTTWELD | STD | 116V | A5 | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | VT | 4" | BUTTWELD | STD | 116V | A5 | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | Brinnell | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | RT | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
8 | Weld | VT | 4" | BUTTWELD | STD | 116V | WL | Bhanson | 12/04/18 | Pass | 100% | 5% |
<tbody>
</tbody>