Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic reference to another sheet?
Hi,
My problem is this Column A (let's say A2) has a number updated via web query (3-digits, say 901). I have also named all the sheets in the workbook after the possible numbers that A can show (odd numbers from 901-931). In B2 I have a formula that does a calculation based on data from another sheet, and that sheets name corresponds to the number of A2. Any chance of building in a cell-value in the reference? =OM('901'!D18-'901'!J181;'901'!Y28;OM('901'!D18-'901'!J18<-1;'901'!Y7;"Please Help")) This is how I have it set up now with the '901's being static. I would like this reference to check A2 for a value (say 909) and put this value in where the '901's is now and that would refer to a sheet with the same name. Sorry about the mess, but if someone can understand this any help would be greatly appreciated. Regards Mitch |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Formula to reference name of sheet tab | Excel Discussion (Misc queries) | |||
Change scales from reference cells value for a chart in a separate sheet | Charts and Charting in Excel | |||
Change sheet reference in new workbook | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |