Please Help With Formula

W

wethery

i currently have a formula which reads '1'!J9, the 1 refers to a tab o
the bottom of the screen. When i highlight this box and drag th
formula down it changes to '1'!J10. i want the J9 to stay the same bu
the tab reference to increase by one. I can lock the J9 function b
using $J$9 but i cannot increase the tab reference by one PLEASE HELP
Also is there a way i can freeze a tab on the bottom of the screen s
my main tab does not dissapear when i scroll along the rest of th
tabs. I have 250 tabs on one sheet but i need to keep one tab in vie
all the time Thank yo
 
R

RagDyer

Try this:

=INDIRECT(ROW(A1)&"!J9")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
W

wethery

AWESOME , Thank you would have never have got that, does anyone know how
to lock the tab displays on the bottom of the screen, if i get this done
my job is far easier now
 
R

RagDyeR

Don't understand what you mean by "lock the tab displays".

Care to elaborate?

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

message
AWESOME , Thank you would have never have got that, does anyone know how
to lock the tab displays on the bottom of the screen, if i get this done
my job is far easier now
 
W

wethery

what i mean is i want to freeze a tab on the bottom of the screen lik
you would freeze panes. I want to keep one tab visible whilst i scrol
the rest of them scroll alon
 
D

Dave Peterson

Excel doesn't support this.

But you can rightclick on the VCR like controls above the status bar to see a
list of the worksheets. It might make navigating a bit easier.
 
Top