Cell Referencing between multiple worksheets
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! |
Cell Referencing between multiple worksheets
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! |
Cell Referencing between multiple worksheets
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! |
Cell Referencing between multiple worksheets
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 |
Cell Referencing between multiple worksheets
=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 |
All times are GMT +1. The time now is 05:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com