Automatic Bookmark

[dond]

I have a project with 56 worksheets, most based on the weeks of the year.
I have a formula advising what week of the year I am working on and returning the relevant Numeral I.E: 1, 2, 3, etc to 52

The worksheets are sequential named week 1, week 2, etc
I am trying to create a single bookmark that looks at the numeral of the week of the year and then directs you to the relevant worksheet when activated.

Any one got any thoughts. I thought this would be simple but cant find the answer yet.

[Pete]

You could use a hyperlink formula. Assume the formula which gives you
the week number is in cell A1, then in an adjacent cell you could add
this formula:

=HYPERLINK("#'Week "&A1&"'!A1","jump")

This will display the word "jump" and if clicked it will take you to
cell A1 in the appropriate "Week no" sheet. As you have spaces in the
sheet names you will need to have the apostrophes in the above formula
- there is one after the # and another one before the !.

You might like to have another one in every sheet which always takes
you back to the main sheet - once this is set up you can just copy it
to the other sheets.

Hope this helps.

Pete