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!

	F	G	AO
1	000746-A-1 REV H	000746-A-1 REV H OP-10 <tbody> </tbody>	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 <tbody> </tbody>
2	000746-A-1 REV H	000746-A-1 REV H OP-20 <tbody> </tbody>	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 <tbody> </tbody>
3	000746-A-1 REV H <tbody> </tbody>	000746-A-1 REV H OP-30 <tbody> </tbody>	STRAIGHTEN IF REQUIRED Flat With-In .003/.006" <tbody> </tbody>
4	000746-A-1 REV H <tbody> </tbody>	000746-A-1 REV H OP-40 <tbody> </tbody>	FINAL INSPECTION Inspect, "OK" to Ship/Stock Name Date Qty OK <tbody> </tbody>

<tbody>
</tbody>

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!