lgronowski
New Member
- Joined
- Jul 11, 2013
- Messages
- 3
I have a spreadsheet with multiple part numbers and in many cases, duplicate part numbers. There are 10,000 rows!
<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!
F | G | AO | |||||
1 | 000746-A-1 REV H |
<tbody> </tbody> |
<tbody> </tbody> | ||||
2 | 000746-A-1 REV H |
<tbody> </tbody> |
<tbody> </tbody> | ||||
3 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
4 |
<tbody> </tbody> |
<tbody> </tbody> |
<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!