I'm trying to set up some web queries. I have about 1000+ entries that I'm trying to get info for. they are all codes in the form of "XXXXX" where the X's are letters and numbers. I have a list of them and can manipulate them as needed. Each entry has a corresponding webpage in the form of www.website.com/entry="XXXXX" where XXXXX is the entry I'm looking up. Each webpage has the same format with the same tables.
Is there a way I can use "import external data" so that the cell value is inserted in to the link? Or do I have to set up a web query for each one individually?
Thanks,
jed
Bookmarks