I have xml data feed in excel sheet1 with column:
This xml has only category codes like AXS, JSC and so on. I need to create new column: "categoryName" with category names.HTML Code:
Other xml feed in sheet2 has separate table with category codes in one column and category name in other. like this:
Is it possible to get category name from sheet 2 and automaticly paste in sheet1 in new column with name: categoryName?HTML Code:
XML has 17k products and 600 category codes. Is it possible to do it automaticly, it should be done many times so manual it is too long. Thanks for your help.
may be i can do it with MS Access?
Bookmarks