Excel
Author
Discussion

Vipers

Original Poster:

33,525 posts

259 months

Thursday 1st November 2018
quotequote all
Been a long time and I have forgot how to do this.

I have a spreadsheet with data on sheet 1 and Sheet 2.

To chop from 1 to 2 I have entered in one cell "Go to sheet 2", but can't remember how to format that cell to do it?

MOBB

4,595 posts

158 months

Thursday 1st November 2018
quotequote all
Hyperlink?

Vipers

Original Poster:

33,525 posts

259 months

Thursday 1st November 2018
quotequote all
MOBB said:
Hyperlink?
But how do I put this in the cell to change to the other Sheet?

Doofus

34,668 posts

204 months

Thursday 1st November 2018
quotequote all
Why can't you just click on the 'Sheet 2' tab at the bottom?

Vipers

Original Poster:

33,525 posts

259 months

Thursday 1st November 2018
quotequote all
Doofus said:
Why can't you just click on the 'Sheet 2' tab at the bottom?
Yes you can and Ctrl "Page up" or down, but I know you can click on the cell saying "Go to" and it goes to the other sheet.

Done it yonks ago but can't remember how I did it.

peter tdci

2,047 posts

181 months

Vipers

Original Poster:

33,525 posts

259 months

Thursday 1st November 2018
quotequote all
peter tdci said:
Sussed it from link, tks, and cheers guys, excellent result, beer

sgrimshaw

7,587 posts

281 months

Friday 2nd November 2018
quotequote all
In the olden days I would have suggested recording a simple macro and assigning it to a button drawn in the sheet .. but I'll be damned if I canf ind how you draw a button and assign a macro to it in the Office 2016.

ETA - found it .. need to display the "developer" toolbar.

My suggestion...

1. Record macro which just records you clicking on the tab you want and (optionally) moving to the first cell you are interested in

2. Add a Macro Button and assign the macro you just recorded.



Edited by sgrimshaw on Friday 2nd November 07:44

Vipers

Original Poster:

33,525 posts

259 months

Friday 2nd November 2018
quotequote all
sgrimshaw said:
In the olden days I would have suggested recording a simple macro and assigning it to a button drawn in the sheet .. but I'll be damned if I canf ind how you draw a button and assign a macro to it in the Office 2016.

ETA - found it .. need to display the "developer" toolbar.

My suggestion...

1. Record macro which just records you clicking on the tab you want and (optionally) moving to the first cell you are interested in

2. Add a Macro Button and assign the macro you just recorded.



Edited by sgrimshaw on Friday 2nd November 07:44
All sorted thanks, was moving between "SHEETS", so didnt need to use a macro, thank god, never used them and would t know where to start.

Cheers everyone, told the OH someone on PH would know beer