Search box for named ranges?

Hello everyone,

So i wanted to know if there was a way to create a search box for named ranges(Not tables)
Essentially in the example doc, you can see a dashboard tab and 2 case tabs.

I want to be able to put the name of the CASE file in the search box and for the data range to be uploaded on the dashboard.

I dont know if this is possible.


Or if anyone would know another elegant solution to be able to navigate trough all these case files.

Your layouts are not conducive in lending themselves to elegant retrieval.
Tabular format is to be encouraged at all times and the total elimination of merged cell is paramount.
torachan.

Any chance you could advise on how to do that?
I can remove the merged cells, but the issue is that these different tables contain different explanations of the case files.

If you would have any idea on how to do it, it would help me out greatly.

I create a tabular version of it.
Please let me know if you think this would work.

I was thinking of using a index + aggregate function. but dont know how to select all the rows that match that case file.

I would suggest data entry by using a front end userform.
The example attached is one created recently for transport firm to log driver infringements.
select 'permanent' then 'driver' (only one record on file) (Andrew Stewert Abbot) then select relevant listing in listbox all details then shown.
This is only to demonstrate the principal of containing all relevant data in tabular (row) format for retrieval.
torachan.