Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Indirect reference to another sheet that can be dragged
Can someone please help me. I have a a few sheets in a file (named by month
october, september, august...". What I am looking to do is have a cell take a number from another sheet for an indirect reference, so once I create a copy of a new sheet I could just replace the month and everything would be updated. I saw one member posted an example saying =INDIRECT("" & $A$1 &"!K11"). But I was not able to drag this down the column. I am looking for Sept! K11 would equal Oct! K11 , and Sept! K12 would equal Oct! K12 and so on. =INDIRECT("" & $A$1 &"!)K11") keeps giving me the same cell. Also, is it possible to use an indirect reference like this built into an if/then statement, such as if the previously mentioned is greater than 30, then get the number from B10.... if not, then take the number from C10.... Thanks |
#2
|
|||
|
|||
Indirect reference to another sheet that can be dragged
Brian wrote...
.... . . . I saw one member posted an example saying =INDIRECT("" & $A$1 &"!K11"). But I was not able to drag this down the column. I am looking for Sept! K11 would equal Oct! K11 , and Sept! K12 would equal Oct! K12 and so on. . . . No matter what the cell, if you want cell ZZ## in the active worksheet to equal the value in cell ZZ## in the worksheet nemed in cell A1 in the active worksheet, try =INDIRECT("'"&$A$1&"'!RC",0) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
indirect cell reference using copies of worksheets in same workboo | Excel Worksheet Functions | |||
How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |