Sheet in cell Reference

[lshavit]

Thanks

The formula =INDIRECT("'"&A1&"'!G4") ,
works well, but when I drag or copy to another place,
Only "A1 " is changed but not " G4 "

There is a solution ?

 

[Jason Morin]

=INDIRECT("'"&A1&"'!"&G4)

HTH
Jason
Atlanta, GA

 

[Aladin Akyurek]

Thanks

The formula =INDIRECT("'"&A1&"'!G4") ,
works well, but when I drag or copy to another place,
Only "A1 " is changed but not " G4 "

There is a solution ?

=INDIRECT("'"&A1&"'!"&CELL("Address",G4)

 

[Guest]

The solution is to stop using A1 mode and use the far more useful R1C1 mode.

=INDIRECT(R1C1&"!R[-1]C",FALSE)

I assume that you have a series of identical sheets, except for the first
page which you're using as a summary or report page, where you select the
sheet to display by typing its name into Sheet1. If so, it is better to name
the cells on the other pages and avoid cell references anyway. Try this:

=INDIRECT(R1C1&"!DailyProfit")

Hope that helps.

James.