Require search function to populate information to listbox.

Hello all, I would really like help with an on-going issue I have.

I have been trying to create a spread sheet of three sheets serving different functions. I feel I really have bitten off more than I can chew with it though.

I require each sheet to serve the following functions:

Sheet one - Main user sheet- search function with display of results. - All users
Sheet two - Department information Database for sheet one to search from. - Administrators
Sheet three - General data sheet for dropdown options on sheet two. - Management and information control.

I have looked at a few ways of doing this, the most obvious way is a VBA using a text box for input, a search button for triggering the search and a list box for displaying the results.

In relation to sheets two and three, I think I've got that covered, unless I'm missing a trick.

I would really appreciate some (or a lot) of help with the VBA for getting this to work. I have tried various approaches with no success and I'm close to giving up on it.

Thank you.

Hi !

In fact that almost not needs any VBA procedure - easier for a very beginner ! - just using some Excel basics
like here an advanced filter, to see in Excel help and at beginner level !

As a reminder database is not the Excel cup of tea,
I hope you do not have huge data in order to avoid to start with a non appropriate tool …

Hello again, sorry for the late reply, I was unable to access the spread sheet in question due to being in work.
I have added notes into the sheet itself after removing and replacing all of the sensitive information. It is looking very basic now.
I would upload the sheet to this forum if I was able to, something seems to be stopping my computer from doing it. I will try a different approach.

Originally Posted by Mumps1

Can you attach a copy of your file (de-sensitized if necessary) and explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples form your data?

Here it is. I had to go the long way around.