Create worksheet tabs from a range of cells but do NOT create duplicates

[lgronowski]

I have a spreadsheet with multiple part numbers and in many cases, duplicate part numbers. There are 10,000 rows!

[TABLE="width: 700"]
<tbody>[TR]
[TD][/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]AO[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]000746-A-1 REV H[/TD]
[TD][TABLE="width: 157"]
<tbody>[TR]
[TD]000746-A-1 REV H OP-10[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD]SHEAR 1st PC FOR INSPECTION

Use 14 Gage (.075") 304SS, Shear strip to 3.25"Wide

Move to Inspection for OK to Run

1st Article Inspect

Drawing A-746[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]000746-A-1 REV H[/TD]
[TD][TABLE="width: 157"]
<tbody>[TR]
[TD]000746-A-1 REV H OP-20[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD]Punch Press - 1st PC

Use customers Die# xxxxxx Stamp (1 Hit) Check .248" +0/-.005" Key location, Burrs not to exceed .005"

Parts MUST BE FLAT with in .003/-.006"

Move to Inspection for OK to Run



1st Article Inspect

Per Drawing A-746

Inspect per H1247

.248" +0/-.005" Actual __________

1.004-1.005" Actual ____________

.875" +.010/-.0" Actual _________

Burrs not to exceed .005" OK _________

FLAT with in .003/-.006" Actual ____________

Inspected "OK" for Production

Name Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 220"]
<tbody>[TR]
[TD]000746-A-1 REV H[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 157"]
<tbody>[TR]
[TD]000746-A-1 REV H OP-30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD]STRAIGHTEN IF REQUIRED

Flat With-In .003/.006"[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 220"]
<tbody>[TR]
[TD]000746-A-1 REV H[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 157"]
<tbody>[TR]
[TD]000746-A-1 REV H OP-40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD]FINAL INSPECTION

Inspect, "OK" to Ship/Stock

Name Date Qty OK[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I need to create a new worksheet tab for each unique part number; no duplicates. I need the worksheet name to be the same as the cell value in column F. Then in each individual worksheet tab that is created I need cell A1 to the name of the newly created worksheet tab. Then I need to pull all the unique Operation IDs in column G that correspond to the part number in column F and put those into the individual worksheets along with the comments in column AO. So for the above spreadsheet snippet I need the code to create a new worksheet tab titled 000746-A-1 REV H. In cell A1 of that worksheet would be 000746-A-1 REV H. In cell A3 would be 000746-A-1 REV H OP-10. In cell A4 would be:

SHEAR 1st PC FOR INSPECTION

Use 14 Gage (.075") 304SS, Shear strip to 3.25"Wide

Move to Inspection for OK to Run

1st Article Inspect

Drawing A-746

Cell A5 would be 000746-A-1 REV H OP-20. Cell A6 would be:

Punch Press - 1st PC


Use customers Die# xxxxxx Stamp (1 Hit) Check .248" +0/-.005" Key location, Burrs not to exceed .005"


Parts MUST BE FLAT with in .003/-.006"


Move to Inspection for OK to Run




1st Article Inspect


Per Drawing A-746


Inspect per H1247


.248" +0/-.005" Actual __________


1.004-1.005" Actual ____________


.875" +.010/-.0" Actual _________


Burrs not to exceed .005" OK _________


FLAT with in .003/-.006" Actual ____________


Inspected "OK" for Production


Name Date

And so on...I'm really in need of some help. I just know there has to be a way!