Hi,
Sample data file is attached. What I need is as follow:
FIRST PART: (New Data)
1. Lookup Pre Production Data's Product ID in Post Production Data
2. Check all Parts IDs data, if any of the Part Code has changed
3. If YES, insert "Upgraded" in Status column and if not changed than insert "Existing" ..... Continue...
3. If YES than in New Data under that part ID change existing value to "Upgraded" otherwise "Existing"
4. If Product ID is not found change part code to "Discontinue"
SECOND PART: (bring Pre Prduction Data)
Bring specific Part IDs data (as shown in sample file) from Pre Prdouction Data matching the Product ID from First Part.
If its new product than all fields will have ----
THIRD PART: (Bring Post Production Data)
Bring shown Part IDs data from Post Prdouction Data matching the Product ID from First Part.
If its Discontinue than all fields will have ---.
FOURT PART: (The result data will have only NEW PRODUCTS)
1. Lookup Product ID of post Prod data in Pre Prod Data
2. If Exists, Ignore
3. If doesn't Exist do Step 2-4 of FIRST PART and All steps of Second & Third Parts.
NOTE:
Pre Production Data (Product ID) has 2 set of situations: Existing & Discontinued
Post Production Data (Product ID) has 2 set of situations: Existing & New Product
So basically first macro will check Pre Production Data and Compare it with Post data for Existing & Discontinued
After that it will have to run Product IDs from Post Prod data and check which ones are not present in Pre Prod data and that IDs will be brought as New Product.
I'm stuck and tried some coding but didn't work. I would really appreciate any help I can get.
Thanks
Bookmarks