Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using data in cell for sheet referencing in formulas
I have a multi sheet spreadhseet in which the Sheet reference (from which i
require data) is held as cell data. For example in Sheet 2 i have a reference in a cell A3 which contains the data "Sheet 1". in attempting to dynamically access this sheet in a formula i am trying to use A3 instead of the standard Sheet 1 that is automatically used. i.e. I am trying to replace formula is Sheet 2 from =SUM(Sheet1!H1:H9) to dynamically reference Sheet 1, something along the lines of =SUM(A3!H1:H9). However using the dynamic cell reference A3 - it does not work!! Any ideas on how to resolve this. I have tried absolute referencing, using single and double quotes, but unable to achieve the desired result. Any assistance most welcome!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative sheet referencing in excel formulas | Excel Worksheet Functions | |||
Excel 2003 - Referencing data in a table to use in formulas | Excel Worksheet Functions | |||
Referencing cells with formulas results in blank cell. | Excel Worksheet Functions | |||
Referencing every 5th cell in another sheet | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions |