worksheet names in drop down list for reference
I created a drop down list of the worksheet names on a summary page. I want
to be able to select a worksheet from the drop down list and have cells on the summary page fill with the information found from worksheet selected from the drop down list. In other words, instead of setting a cell to "=Sheet3!B4", I want the cell to use the worksheet from the drop down list and then a specific column and row. Any ideas how to do this? |
worksheet names in drop down list for reference
Try something like this example:
With Sheet1!A2 containing the dropdown list of sheet names That cell is named "RefSheetname" AND The data to be used is in A1:I30 in each sheet Try this: From the Excel main menu: <insert<name<define Names in Workbook: SheetDataRange Refers to: =INDIRECT(RefSheetname&"!A1:I30") Next.....On sheet1 Select a sheet name from the drop down list Then...this formula returns the value of cell C5 on the referenced sheet F10: =INDEX(SheetDataRange,5,3) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Mr. C" wrote: I created a drop down list of the worksheet names on a summary page. I want to be able to select a worksheet from the drop down list and have cells on the summary page fill with the information found from worksheet selected from the drop down list. In other words, instead of setting a cell to "=Sheet3!B4", I want the cell to use the worksheet from the drop down list and then a specific column and row. Any ideas how to do this? |
worksheet names in drop down list for reference
Yes that will work. Thank you very much Ron.
"Ron Coderre" wrote: Try something like this example: With Sheet1!A2 containing the dropdown list of sheet names That cell is named "RefSheetname" AND The data to be used is in A1:I30 in each sheet Try this: From the Excel main menu: <insert<name<define Names in Workbook: SheetDataRange Refers to: =INDIRECT(RefSheetname&"!A1:I30") Next.....On sheet1 Select a sheet name from the drop down list Then...this formula returns the value of cell C5 on the referenced sheet F10: =INDEX(SheetDataRange,5,3) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Mr. C" wrote: I created a drop down list of the worksheet names on a summary page. I want to be able to select a worksheet from the drop down list and have cells on the summary page fill with the information found from worksheet selected from the drop down list. In other words, instead of setting a cell to "=Sheet3!B4", I want the cell to use the worksheet from the drop down list and then a specific column and row. Any ideas how to do this? |
All times are GMT +1. The time now is 07:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com