create a button to link

  • Thread starter Thread starter Jeannette
  • Start date Start date
J

Jeannette

I would like to have two worksheet in the same workbook. When I click in the
cell name "Manufacture" that creates a link to the 2 sheet where all Point of
contacts. phone numbers, address, emails,
 
Select the "Manufacture" cell, and then do Insert / Hyperlink, or Ctrl-K. On
the Insert Hyperlink dialog box, choose Place in This Document on the left,
and you'll see all worksheets and named ranges in the middle. Choose what
you want, then click OK.
 
Back
Top