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!

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." wrote:

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!

Thanks for your help!

"Sheeloo" wrote:

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." wrote:

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!

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

=INDIRECT("'sheet "&ROW()&"'!F13")
--
David Biddulph

kiboypalaboy wrote:
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