move to another cell on click
 

hi

i have a spreadsheet that has the tabs Front Page, Graphs, S1 Graphs, S2
Graphs.

On the front page i have headings (with this weeks totals in a cell
underneath) that represent the graphs. I would like to click this heading and
then be directed straight to the coressponding graph.
I tried Hyperlink but that didnt work
Is this easliy possible or do i need to make a macro ?

move to another cell on click
 

Hyperlinks should work. Just make sure that link to a place in this
document.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ashfire" wrote in message
...
hi

i have a spreadsheet that has the tabs Front Page, Graphs, S1 Graphs, S2
Graphs.

On the front page i have headings (with this weeks totals in a cell
underneath) that represent the graphs. I would like to click this heading
and
then be directed straight to the coressponding graph.
I tried Hyperlink but that didnt work
Is this easliy possible or do i need to make a macro ?

move to another cell on click
 

Hi,

You can not hyperlink to a chartsheet without resorting to vba code.
See Jon Peltier's page on the subject.
http://peltiertech.com/Excel/Hyperlinks.html

Cheers
Andy

ashfire wrote:
hi

i have a spreadsheet that has the tabs Front Page, Graphs, S1 Graphs, S2
Graphs.

On the front page i have headings (with this weeks totals in a cell
underneath) that represent the graphs. I would like to click this heading and
then be directed straight to the coressponding graph.
I tried Hyperlink but that didnt work
Is this easliy possible or do i need to make a macro ?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info