Hyperlink

[coxycoxycoxy]

HI All

Ok I really need some help on this one.

I have a multi sheet workbook that I am using as a stock system.

I have my first sheet as a control sheet (CONTROL.SHEET OR SHEET 4). and then a template.

Each stock item as a line entry in the Control sheet and 1 template sheet, i have a macro in the template that changes the sheet name to the product code when it is entered in to Cell E3 of the template. the product code is linked via paste link to its line entry in the control sheet.

The macro insert the line entry into row 5 of the control sheet before i manually cut and insert that row into the list of items on the control sheet.

Right what I need to solve is the hyperlink, at the moment i manually insert the hyperlink, what i would like to do is insert some code into the macro so that it creates a hyperlink in cell D5 of the control sheet to the newest inserted template sheet. Any one got any idea.

Thanks in Advance

Mark

 

[SkipVought]

Mark,

Your descrption is VERY difficult to follow and understand.

But here are a few comments I gather from what I can understand.

1. When I see Cut 'n' Paste I cringe. Fraught with all sorts of pitfalls. Best practices use other techniques in most cases.

2. Hyperlinks in a Stock System? Lookups, YES! Hyperlinks are rather static. Again, it seems that there might be better ways to achieve your objectives.

But beyond that, I can't understand your system and what you are trying to accomplish.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}