Hey guys:

Newbie here.

I don't have VBA.

As a part of my business, I regularly ship stuff that is a part of an order. An Order has a order number and a name. To access the status of it, one simply goes to a website, type in the name and order number, and they can see the status of it (Pending, Received, Accepted (pending payment,) Received (rejected,) or Received (Paid.))

In my spreadsheet, I have a column that has the order number, and I also have a column that has the tracking number.

Is there a way that I can do one of two things?

1. Set up some type of program with my spreadsheet where it automatically updates itself from the Order information so I can know the status of it (and perhaps could I do the same thing with the tracking numbers, if I cannot use the Order number/name combination?)
2. Hyperlink the order number and/or the tracking number so I can click on it to see the status? Each order number is different, but the last name would always be the same. So, the hyperlink would have a different order number that I would type in the cell, but all of the other information (website, link, and last name) would be the same.

Thanks for the help!

Jeremy James