pull data from multiple sheets based on input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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")
 
Ah, yes, use Debra's formula instead. Mine wouldn't work if the sheet name
contains spaces.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the same cell based on tab name 1
Drop down lists on multiple worksheets 2
Excel Highlighting duplicates 0
Pulling From Multiple Sheet 0
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Pulling data from Sheets in A workbook 2
Receive data in column with pull down 2
Create two Data validation lists that are linked(Both change toget 2

Back
Top