| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pull data from multiple sheets based on input
I have several worksheets that all have the same format, I would like to have
an additional worksheet that has a drop down cell listing all worksheets and then have the data pulled from the worksheet named in the drop down cell. Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pull data from multiple sheets based on input
You can use the INDIRECT function for this. Let's say your drop-down list is
in cell A1 of your new sheet. Use this formula in B1 to retrieve the value in cell C1 of the worksheet identified in cell A1. =INDIRECT(A1&"!C1") Obviously, change the cell references to meet your needs. HTH, Elkar "Patti" wrote: I have several worksheets that all have the same format, I would like to have an additional worksheet that has a drop down cell listing all worksheets and then have the data pulled from the worksheet named in the drop down cell. Is this possible? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pull data from multiple sheets based on input
If your dropdown list is in cell A2, and you want to pull the value from
cell B3 on the selected sheet, use the following formula: =INDIRECT("'" & A2 & "'!B3") Patti wrote: I have several worksheets that all have the same format, I would like to have an additional worksheet that has a drop down cell listing all worksheets and then have the data pulled from the worksheet named in the drop down cell. Is this possible? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pull data from multiple sheets based on input
Ah, yes, use Debra's formula instead. Mine wouldn't work if the sheet name
contains spaces. "Debra Dalgleish" wrote: If your dropdown list is in cell A2, and you want to pull the value from cell B3 on the selected sheet, use the following formula: =INDIRECT("'" & A2 & "'!B3") Patti wrote: I have several worksheets that all have the same format, I would like to have an additional worksheet that has a drop down cell listing all worksheets and then have the data pulled from the worksheet named in the drop down cell. Is this possible? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel pull data based upon one specific word between two date | Excel Worksheet Functions | |||
| Pull in a colum of financial data based on the month | Excel Worksheet Functions | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| Retreive data based on multiple column input | Excel Worksheet Functions | |||
| Pull multiple data | Excel Worksheet Functions | |||
Linear Mode
