Cell Referencing between multiple worksheets

[Nelson B.]

I need some help on a problem I have. In excel 2007 I want to make cell A1
equal the value of cell B1, which is on a different worksheet. However, I
want cell A1 to change which cell it references based on what month it is.
For example, if it is January, I want cell A1 to reference cell B. However,
if it is February I want it to reference cell B2. I already have a cell, C1,
where I put in the number corresponding with what month it is that I
reference for other formulas. Any ideas?

Thanks!

 

[Sheeloo]

To reference a cell in the range B1-B12 of Sheet2, based on the value (1-12)
in C1 use
=INDIRECT("Sheet2!B"&C1)

so if C1 has 5 you will get the value in B5

 

[Nelson B.]

Thanks for your help!

To reference a cell in the range B1-B12 of Sheet2, based on the value (1-12)
in C1 use
=INDIRECT("Sheet2!B"&C1)

so if C1 has 5 you will get the value in B5

 

[kiboypalaboy]

hi sheloo,

how about if you if refer multiple sheet but the same cell that u want for..
like i want the cell F13 for sheet 1 up to sheet 1431..
and if input the formula for new worksheet in
A1=sheet 1 F13
A2=sheet 2 F13
.........
A1431=sheet 1431 F13

thanks in advance for help