Insert Hyperlink to reference another Worksheet

[jhall488]

Hello all,

I have an excel invoice system and I currently return value from the invoice page and create a table with the main info such as invoice number, customer, total ect. During this process i copy the invoice sheet to a new blank sheet. I name the new sheet based on the invoie number. In my tabel i would like to have the hyper link that will pull the "new" invoice sheet that i just copied.


Here is my code that works fine with a table and everything else. Just no hyperlink. Any suggustion?

Please Login or Register  to view this content.

Thanks for any help

[LJMetzger]

Try replacing your code:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Please note that the above code only works if there are NO EMBEDDED SPACES in the Worksheet name. I'm not good enough to figure that one out.

Lewis

[jhall488]

Thanks Lewis. This is what I needed