Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible Indirect query
I have a Validation list that contains a list of worksheets in my
workbook. On a front sheet (in E4) I want to use this list to pick a sheet and then have the remaining cells auto populate with the data values that are on the sheet, identified by the value in E4. All sheets have the same layout, so I know, for example, that I want to pick and display the values from Sheet Alpha, Column F rows 3-18 and, if I change the selection in E4 to sheet Beta, it should refresh to show its F3-F18 values. Where I am stuck is what formula to put in F3-F18 to base their content on the value in E4 Thanks for any pointers Fred |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible Indirect query
=INDIRECT($E$4&"!F" & ROW())
Entered in front sheet F3. Drag/copy down. Gord Dibben Microsoft Excel MVP On Thu, 4 Aug 2011 11:31:21 -0700 (PDT), Fred wrote: I have a Validation list that contains a list of worksheets in my workbook. On a front sheet (in E4) I want to use this list to pick a sheet and then have the remaining cells auto populate with the data values that are on the sheet, identified by the value in E4. All sheets have the same layout, so I know, for example, that I want to pick and display the values from Sheet Alpha, Column F rows 3-18 and, if I change the selection in E4 to sheet Beta, it should refresh to show its F3-F18 values. Where I am stuck is what formula to put in F3-F18 to base their content on the value in E4 Thanks for any pointers Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) |