Invoice system with Hyperlink

• • Reply

  13 years ago

  by vspiersa

  vincent piersa

  , United States

  Joined 13 years ago

  Hello -

  I have created an invoice system that creates a new inovice number for each price quote. The unique quote is determined with a central tracking excel workbook that adds one to the last number used and then put that number on the price quote to give it an identity. What I would like to do is add a hyperlink to the price quote file from the tracking sheet (Tied in by the unique quote number I have generated) so that I can access all my price quotes from one centralized location. Does anyone have any suggestions for creating this hyperlink? I am not sure where or at what time to create this link.

  Any help on hyperlinks in excel using macros would be very appreciated.

   

  Thanks

  Report abuse