So I am working with 3 spreadsheets to upload supplier information to a website. The 100kbulkupload is the one I used to upload the stuff onto the website. The SKU I have listed is the Supplier ID whereas it should have been the Stock Code (listed in the other two files)
Hlaentire is absolutely everything on the supplier list, which is what I was using. I have since found out that a bunch of this stuff is unavailable now so what I WANT to upload is the data from hlacomplete.
I need to replace the Supplier ID on the 100kbulkupload list with the stock code and also remove anything from the 100kbulkupload file that does NOT appear in the hlacomplete file. Finally I need to get the corresponding descriptions from column AP of the hlacomplete file into column O of the 100kbulkupload file.
I have had to upload them to google drive because I can only upload one on here and the files are huge.