COGICPENNY
New Member
- Joined
- Feb 16, 2009
- Messages
- 44
The purpose is to identify EVERY possible missed commodity code a supplier should have been mapped to that falls under CATEGORY or SUBCATEGORY level. Ideally the script will only add the ones that are missing, but if it is easier to dump ALL COMMODITIES that are under the Subcategory that will be fine as well because I will pick up DUPLICATES in the original CONCATENATE field.
I need a macro that will do the following:
I need a macro that will do the following:
- There are two TABS that have the information needed: "MSL (NO DUPS) 05182018" and "FINAL TAXONOMY (CLEAN)"
- In "MSL" filter on Column E (Level), to select "CATEGORY" and "SUBCATEGORY". Look at the Subcategory field in Column S (2017 Subcategory)
- Duplicate the row for every commodity code using the "TAXONOMY" tab, Subcategory (Column I) and Commodity Code (Column J), so that for every supplier row identified in Step 2, will have a commodity code from the TAXONOMY tab.
- ONLY DUPLICATE THE ROW for columns E-AK in the "MSL" tab because I need to manually add the Update Type (Column B) to say ("New") and date field (Column C) to say ("05/24/2018"), unless the macro can do that too, otherwise leave it blank.
- The updated master file is on my Google Drive: https://drive.google.com/open?id=1MAq4MBX00XOjrJfxeViadYHrScIPTf0I
Thank you sooooo much!
Penny