I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193

take the $ from 5, mianing ... ='LA5'!$B5 and copy down. you'll the change to
='LA5'!$B6, ='LA5'!$B7, ='LA5'!$B8 and so on ..


"JOJO193" wrote:

I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193

sorry for the typos ..

"Mayte" wrote:

take the $ from 5, mianing ... ='LA5'!$B5 and copy down. you'll the change to
='LA5'!$B6, ='LA5'!$B7, ='LA5'!$B8 and so on ..


"JOJO193" wrote:

I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193

Mayte, I want the cell to stay constant but I want the sheet to increase.
Like this ='LA5'!$B$6, ='LA6'!$B$6, and so on. Can this be done?

"Mayte" wrote:

take the $ from 5, mianing ... ='LA5'!$B5 and copy down. you'll the change to
='LA5'!$B6, ='LA5'!$B7, ='LA5'!$B8 and so on ..


"JOJO193" wrote:

I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193

Try:

=INDIRECT("LA" & ROWS($1:1)+4 & "!$B$5")

and copy down. The sheet reference will increase, but the cell reference
will be the same.
--
Gary''s Student - gsnu200779


"JOJO193" wrote:

I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193

=INDIRECT("'LA"&ROW(A5)&"'!$B$5")
--
David Biddulph

"JOJO193" wrote in message
...
I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193

Don't know if it would help or not but it might make sense to put the
worksheet name into Column A (which could be a company name), then
in column B place a formula to extract the value in Cell B2 of a company sheet,
this formula includes a hyperlink to take you to cell A1 of the company sheet,
to return to original summary sheet use Alt+ArrowLt (which you can
set up on a five button mouse).

B2: =IF(TRIM(A2)="","",IF(ISERROR(INDIRECT("'" & A2 & "'!$A$1")),"missing sheet", HYPERLINK("#" & "'" & A2 & "'!$A$1",INDIRECT("'" &
A2 & "'!$B$2")) ))


--
HTH, additional help my pages indirect.htm and sheets.htm
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"David Biddulph" <groups [at] biddulph.org.uk wrote in message ...
=INDIRECT("'LA"&ROW(A5)&"'!$B$5")
--
David Biddulph

"JOJO193" wrote in message ...
I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193

Seems to me you got the answers you asked for, did you try them.
I offered you a solution that did not match your arctual request,
but might be useful if you are working on a summary sheet.

By the way your sheetnames look like cell addresses.
If you put the LA5 into a cell you could use the fill handle
and it would increment the numeric portion. Not what you
asked because you are not showing the sheetname.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"JOJO193" wrote in message ...
Mayte, I want the cell to stay constant but I want the sheet to increase.
Like this ='LA5'!$B$6, ='LA6'!$B$6, and so on. Can this be done?

"Mayte" wrote:

take the $ from 5, mianing ... ='LA5'!$B5 and copy down. you'll the change to
='LA5'!$B6, ='LA5'!$B7, ='LA5'!$B8 and so on ..


"JOJO193" wrote:

I am referencing a sheet and would like to autofill the sheet reference.

For example I have the cell ='LA5'!$B$5 . I want to auto fill to LA6, LA7,
LA8 and so on.

How do you do this?

Thanks JOJO193