I am in the process of trying to learn VBA. I am trying to write a macro
that will go through a list of data in excel and:
1. Sort Data
2. Find duplicates
3.If duplicates are found, move certain information to open column of the
master row
4. Delete Duplicate row
Problem
Item Mfg ID Mfg Itm ID Mfg ID-1 Mfg Itm ID-1 DFLT-1 Mfg ID-2
0804706 BETCOCHEM AF79
0804706 JOHNSONSON 4605
0810295 CARLISLE 3663300
0810295 CARLISLE (O)4155900
Hopefull End result
Item Mfg ID Mfg Itm ID Mfg ID-1 Mfg Itm ID-1
0804706 BETCOCHEM AF79 JOHNSONSON 4605
0810295 CARLISLE 3663300 CARLISLE (O)4155900
There will be multiple items that need to be moved to multiple columns.
Bottom line is that I am trying to create unique item numbers that could have
multiple part numbers.
Any help would be much appreciated.
thanks,
bob
Bookmarks