paste from 1 sheet into another based on a reference cell

[howardgrigg]

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!

[shyrath]

Have you tried using a lookup function?
That is what i would use.

With vlookup you can get the data you need , even if itīs in another Spreadsheet.

Please Login or Register  to view this content.

In the above example, in the "specials" sheet you would have the product code in Column A with the first product code in A2.

Test1.xls would be your "main" list of products.

Furthermore, a good listing of vlookup I found trough google on :

http://www.techonthenet.com/excel/formulas/vlookup.php