Source: 1 single xlsx file with one sheet(see below TESTDATA.xlsx).
Goal:
Part 1-I want to have your program be able to have a browse file so I can import the sheet into your program
Part 2-Scan a single column(TypeCode) and make a tab for each TypeCode(about 7-10). Then copy source data(TESTDATA.xlsx) from the main sheet into those new tabs.
Part 3-Create a tab at the end called Statistics.(See FiNALSampleOutput.xlsx) On this sheet, I need each of the Part Numbers.(you will need to remove duplicate part numbers(see FAB Tab-source 5 duplicate, remove down to 1)
Then sum the number of the part numbers and put count under Part numbers. (see attached FINALSampleOutput-Tab Statistics)