Ok the situation, we have a sheet of ~30,000 products, each row is a product containing info including stock levels, catagories, price etc... one of the columns (column Q) contains a URL for a thumbnail image of the product. In a different file we have a list of ~40 products that are this weeks "specials" in this list is just the product code and in the macro it searches this list to mark the products as specials in the main database.
What I would like to do it create a macro that puts an image URL for all the specials as some products are missing URLs and I want to make sure that the specials all have images.
I think I would type the URL next to the product code in the specials sheet then somehow search the main sheet based on the product code in the specials sheet and when found paste the URL from the cell next to the code on the specials sheet into the URL field in the main database.
I hope this makes sense. In the main database the product code is in column B and the ImageURL column is Q.
If possible could it not paste into the ImageURL cell if it already has something in it... only if it is easy though
Thanks in advance!
Bookmarks