OK, I always catch flack from my buddies because I always try and do
crazy things with Excel. Here is one of those ideas. I hope someone
can help me.
Goal: Be able to compile a text list of my CD collection.
My idea/solution: Enter the UPC codes from the CDs and use Excel to
retreive the name info.
I have found a website (
http://www.upcdatabase.com/item.pl?upc=) where
you can enter in a UPC code after the = and it will return a brief
description of your item. The returned data is very standard and is in
text format. My general theory is to have a cell to enter my UPC and
have some type of formula/tool that will lookup that UPC and return the
contents of the description field into another cell. I hope that I have
described this accurately. The idea is a bit wacky but I am sure there
is a way to do it.
Thank you all in advance!
Rich
--
rreynolds63
------------------------------------------------------------------------
rreynolds63's Profile:
http://www.excelforum.com/member.php...o&userid=26737
View this thread:
http://www.excelforum.com/showthread...hreadid=399925