create new worksheet and hyperlink it to a variable cell

[andreea_mn]

Hi

I am new to this forum so i hope i am communicating the right thing in order to get help.

So i have an excel file containing a complex plan. This file has an overview sheet and project plans.
In the overview sheet :column A contains a hyperlinks to other worksheets (1 project plan=1 worksheet) column B and C contain status and deadlines (information is taken from the worksheets).

Then i have a small macro that automatically adds an empty plan template and prompts the user to name it.

my challenge is to continue the code with the following
1. make the user select a cell/row in the overview sheet (title of the project has more characters than worksheet) and
2. hyperlink automatically the new project plan (which is a variable) to it and
3. pick up the necessary information for column B and C in the overview sheet from the new project plan (cells 5D and 5E)

Any help would be appreciated. Thank you so much!

 

[andreea_mn]

!!! I also posted the same question on two other forums. (I did not know that it was cross posting)
Here are the links:
http://www.excelforum.com/excel-wor...rlink-for-variable-worksheet.html#post2504910
http://www.ozgrid.com/forum/showthre...86&pagenumber=