Ok. I can put this together for you. I have 2 options that I am thinking of.

1.
You put a list of URLS in column A of a spreadsheet and then hit a button that will automatically pull the name, color and code in columns B, C, and D.

2.
You click on a button that is in the spreadsheet. This button will bring up a dialog box that you can then copy and paste a URL into. Once you press enter the program will grab the data you need and put the URL in col A, Descripton in B, Color in C and Sku in D. Then the dialog box will appear again and ask for another URL where you can just put another in until you hit cancel.


Let me know which one of these sounds best and I will get to work on it.


Thanks