Worksheet search including tab names

SaffronAnne

New Member
Joined
Oct 8, 2019
Messages
3
Hi, I currently have an Excel spreadsheet that has multiple tabs and I am trying to find a way to make the first page be a search page that includes the tabs as searchable. So, for example, lets say each tab is named different states and then there is data in those worksheets from those states (say, population of each city). How can I make the first page a searchable worksheet where I can find "Colorado" in a drop down menu and then find "Alamosa" from another drop down and then see information about Alamosa? Is that even possible? If it isn't, does anyone know another program that might be more conducive to filtering this type of information?
Let me know if you have additional questions!
Thank you in advance!
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
7,978
Office Version
2007
Platform
Windows
You could provide ample examples of how your information is on each sheet and what you expect from the result.

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
 

SaffronAnne

New Member
Joined
Oct 8, 2019
Messages
3
It's okay, I have already moved on to a different workaround. It will take me longer on the back end, but overall, the result for end users will be the same (and easier for them to understand).
Thank you for your help!
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
7,978
Office Version
2007
Platform
Windows
Youre welcome, let me know if you have any doubt.
 

Forum statistics

Threads
1,078,521
Messages
5,340,942
Members
399,399
Latest member
SravanaSandhya

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top