Sorting/Filtering Data in excel onto a summary tab

[HolyLemon]

I have an excel 2007 spreadsheet at my work, its about 30 colums across and contains a couple of thousand clients, one client per row.

I'm pretty happy with it at the moment Ive done some (what I would consider) nifty stuff when it comes to summarising the data on there, stuff per month, that kind of thing.

What I need to do is create a new worksheet, on which is a little box where you can enter the members number and either hit enter or a button or something and below the number you have entered and all of the information that is on that line will show up, preferably in an order that I choose. a "data extract".

I am a VBA/macro novice, I know how to open VBA, that is it. I used it alot in school but cant remember it at all.

Any help would be so amazingly appreciated.

NB, Some of the clients have Scheme codes to say if they are in a different country whereas UK clients dont so it would need to take that into account aswell.

If you could help me I would be so grateful

Thanks again.

Harry

 

[HolyLemon]

I cant see the bump button lol, wow im doing well!

 

[HolyLemon]

Hi, just wanted to say thanks hiker95.

I finally fixed it. I dont know why I didnt think of it before.

I inserted two new columns to make your formulas work with two inputs. One of the columns merges the scheme code and membership number in proposed MGP3.

The other merges the search terms together.

I would not have been able to do this without all your help and I would like to thank Hiker95 and everyone else who contributed to this thread.

Thanks very much,

A link to my new (working) file can be found here --> http://www.box.net/shared/p3enk90t00