Hi,

Pl help me with this code:

My Second row has headings.
first column (A) has sheet names (1,2,3..not in order)
Second column(B) has descriptions.


I need script which hyperlinks Column B:
  1. Link location : sheet name as in column A, CellA1
  2. Friendly name: Description in column B


Further in this Worksheet, I need an "Update" button, which updates the hyperlink when I add/change data.

I also need a "New Entry" Button which Pops up dialogue box to enter:
  1. Option: Copy from template / create blank sheet (at end of workbook)
  2. If blank sheet: Input Sheet Name (& update with hyperlinks in current worksheet)
  3. If Copy from template: Input template Sheet Name, (and update with hyperlinks in current worksheet)

I hope i'm not asking for too much..! please do help.