use the info of the cell to open the right sheet

[GeekComputer]

I am creating new jobs everyday, these jobs have their own sheets, Sheet 1 has the names of all jobs in a column. I need to click any cell of that column and open the sheet matching the name of that cell. Thanks

[jaslake]

Hi GeekComputer

Create Hyperlinks for each Job on Sheet1

Right Click ----> Hyperlink ----> Place in this document -----> Select Sheet

[stnkynts]

Assuming column A

Please Login or Register  to view this content.

[martindwilson]

with job names in a1 down
say job 123
and you have a sheet job 123
then you can hyperlink to that sheet with this formula in b1
=HYPERLINK("#'"&A1&"'!a1",A1)

[GeekComputer]

Thanks for your help stnkynts, I tried your suggestion and when I click a cell it seems to start the macro but it always returns the MsBox message, I know the sheet matching the text is there but it fails to open. Any suggestions on what I am missing?

[stnkynts]

Are the values in the cells numbers? If so we may have to do Set ws = Sheets(Target.Text). Other that I would need a copy of your workbook as it worked when I tried it on a test workbook