Sheet Tabs

G

Guest

Is there a way of using the Sheet Tabs to create a drop down list on an excel
sheet. If so is there a way when the Sheet Tab name is selected from the
drop down list that the workbook will copy over information from that sheet
into the summary sheet. The dropdown list will be on the summary sheet.
 
G

Guest

Say we want to pick a cell from the sheet selected by the dropdown. The cell
is, for example, B10.

In summary sheet cell A1 put a Data Validation pull-down that options:
Sheet1
Sheet2
Sheet3

in another cell enter:
=INDIRECT(A1 & "!" & "B10")

If the user selects Sheet1, the formula returns the contents of B10 in that
sheet.
If the user selects Sheet2, the formula returns the contents of B10 in that
sheet.
If the user selects Sheet3, the formula returns the contents of B10 in that
sheet.
 

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

how do i link the names of tabs in a workbook to a summary page? 1
Help to create a macro 2
Populate Data from Summary Sheet 5
Summary sheet from tab names 3
Calculating inserted rows or colums from another sheet 1
Excel Move or Copy Stopped Working? 0
Insert Worksheet Names into Cells 1
Summarize the monthly recrods by name 3

Top