No.s on a page

[abcjohn]

Hi all
hav'nt posted for a while , but my question is
if i have a wook book withsome pages in it would it be possible when selecting a specific row on page 1(say row 199) that that row (199) is selected in all the other pages in that workbook. I know i can get the whole wookbook to alter the same cell on each page, but i would like flick from page 1 to 2-3-4 ect and read the same line if poss.
thanks john

 

[Andrew Poulsom]

You can Group the worksheets.

http://office.microsoft.com/en-us/excel-help/select-one-or-multiple-worksheets-HP005202492.aspx

But be carefula because whatever you do will affect all the worksheets.

 

[abcjohn]

You can Group the worksheets.

http://office.microsoft.com/en-us/excel-help/select-one-or-multiple-worksheets-HP005202492.aspx

But be carefula because whatever you do will affect all the worksheets.

hi andrew
yes i can do this but i would like to have the row selected on sheet 1 to appear in the window as i move from sheet to sheet . this would save me scrolling up or down to find the selected row
thanks john

 

[Andrew Poulsom]

If the worksheets are grouped and you select a row, that row will be selected on all the grouped sheets.

 

[abcjohn]

andrew
yes that is true but i cant see the selected row in the window as i move from sheet to sheet
john

 

[Andrew Poulsom]

Sorry, I don't know how to achieve what you want if the selected row is outside the worksheets's visible range.

 

[abcjohn]

andrew
if i select row 99 on sheet 1 i would like row 99 in view when i select sheets 2,3,4or5

 

[Andrew Poulsom]

I know what you want, but I don't know how to scroll the selected row into view (if necessary) without VBA.

 

[abcjohn]

i know what you want, but i don't know how to scroll the selected row into view (if necessary) without vba.

ok thanks andrew