I asked about this on another forum but got zero help. Maybe someone here can help. I tried to write a macro but its just not doing what i need it to do.
I have a spreadsheet of scrap part data that i need to combine. The key identifiers are a "job" column and then a "defect" column. I would like the macro to combine the similar job numbers and defects, summing the qty of duplicate defects/job numbers
Not sure if this explanation is sufficient to get my point across so i included a worksheet with what the final combined data should look like
"RawData" is the data needed to be combined.
"Sheet1" is the results when i run the macro i tried to write.
"needed results" is the final results i need the macro to do(i did that sheet by hand)
I really appreciate any help givin!!!
Will
Bookmarks