Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining cell Ref into formulae
Hi There Sheet 1 has formulae in cell a1 that says "=sheet2!b2" Thus value in cell b2 in sheet2 is displayed in a1 in sheet1 Problem I need to change sheet2 to sheet 3 sheet 4 etc etc, so I wanted to make the text "sheet2" within the formulae above relative, ie instead of saying "sheet2!b2" I wanted to refer Excel to a cell Say Z1 and then combine it with b2. (sortof like ="z1!&b2" - but this doesnt work) In Z1 I would then type Sheet2 or whatever I wanted, it would make duplicating it much easier. any ideas welcomed (hope its not all too confusing... Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining cell Ref into formulae
=INDIRECT(Z1&"!B2")
-- HTH RP (remove nothere from the email address if mailing direct) "Darin Kramer" wrote in message ... Hi There Sheet 1 has formulae in cell a1 that says "=sheet2!b2" Thus value in cell b2 in sheet2 is displayed in a1 in sheet1 Problem I need to change sheet2 to sheet 3 sheet 4 etc etc, so I wanted to make the text "sheet2" within the formulae above relative, ie instead of saying "sheet2!b2" I wanted to refer Excel to a cell Say Z1 and then combine it with b2. (sortof like ="z1!&b2" - but this doesnt work) In Z1 I would then type Sheet2 or whatever I wanted, it would make duplicating it much easier. any ideas welcomed (hope its not all too confusing... Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
Combining (nesting) 2 formulae | Excel Worksheet Functions | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |