Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |