saved sheet to create hyperlink

[nighttrainrex]

Hi all I have a workbook for Purchase orders.

how it works at the moment is when I fill in the Purchase prder sheet then save it, I have a macro that

Copies Sheet "Purchase Order" creates a new sheet to paste it to then also copies some details to A Sheet called "Register.

I would like to be able to (if possible)

1/ automaticly create a hyperlink between the P/o Nomber stored on the register as it is storing the new sheet &

2/ automaticly change the sheet tab to reflectthe P/order number in Cell G8

I have very little knowlage of VBA & am learning how to record macros so please be gentle.

here is the macro I recorded

[JBeaucaire]

If you posted a sample worksheet, I could test this, too, but I've marked in red the two lines of code that should do what you asked. I also shortened up the code to speed it up and remove all the unnecessary "selecting".

Please Login or Register  to view this content.

[nighttrainrex]

Hi Jb thanks for that it works fine with the exception of the hyperlink, the link appears to be there but but if I click on it a message box saying "cannot open te speified file pops up

rex

[JBeaucaire]

Time to post a test sheet then so I can see the diff.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

[nighttrainrex]

Ok here it is (I hope)

[JBeaucaire]

Edit that one section and make the hyperlink code like so:

Please Login or Register  to view this content.

You can change the A1 to the cell you actually want to jump to when the hyperlink is clicked.

[nighttrainrex]

Thamks JB that works a treat.

I will go now & click on the scales

cheers rex