I am not sure if this is possible, but I am trying to create a formula that will automatically create hyperlinks that can display my orders which are kept on separate webpages.
Currently, we do it one by one (inserting the hyperlinks by recently browsed pages - once we pull up an order) and it takes a long time. If there is away to have Excel do this hyperlink for me once I enter the order number in a cell, that would be much better.
For example, take notice of the similarity in the following hyperlink formulas for the two different orders:
Is there a way that if I were to enter for Order 1, "23156" into a cell (say) A120 that Excel could create this Hyperlink and insert the 23156 into the two necessary places as seen above?
Thanks for your time and help!