I need a small excel macro or application. I have 2 excel files. First file contain list of products, sku codes (Column "Q") and categories names (Column "R"). Second file contains list of categories and there ids associated. There are two tasks involved.
1. I want macro to read the categories names from first file find it on second file check its id and replace the category names in first file with its id.
2. After first task is completed now it needs to work on first file only. The first file will now have list of ids in different rows. I want the macro/script to put ids in its master row for each product in front of its sku separated with comma and delete the rows which don't have sku code's.
To understand better check the attached sample files and also file with sample results what exactly i need.
First Task in Row no 8 in first file is completed while second task is remaining. This is just to show you as sample what i need in second task. Let me explain. In second task you can see rows no 9,10,11 contains the ids as first task is already completed. So i want the macro to take ids from row 9,10,11 and put them in there master row no 8 separated with comma just like i did in other sample rows.
Let me know if u have any questions.