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

 

[SteveO59L]

No need for VBA, vlookup() should be able to do this

 

[VoG]

I think that a series of VLOOKUP formulas would be a start - see http://www.contextures.com/xlFunctions02.html

 

[hiker95]

HolyLemon,

Welcome to the MrExcel forum.

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".

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Or, you can upload your workbook to www.box.net and provide us with a link to your workbook.

 

[HolyLemon]

Thanks,

Here is a link to the file.

If anyone can help me I would be really really grateful.

I want to pull the data from the "Proposed MGP3" worksheet.

The other thing I forgot to mention is that this worksheet is going to be constantly updated. and when I put all the other names in it there are going to be a few thousand.

thanks very much

Document ---> http://www.box.net/shared/p3enk90t00

 

[HolyLemon]

Someone just suggest a Vlookup, would that help?

 

[VoG]

THat's exactly what I suggested here http://www.mrexcel.com/forum/showpost.php?p=2309316&postcount=3

 

[HolyLemon]

I do apologise, didnt notice your response, my explorer has a habit of just throwing me to the bottom of a webpage as soon as it loads. Very annoying. I will have a look at that now. It wont be affected by constant changes or adding clients to the bottom will it, it will stay updated?

 

[VoG]

As long as you make your lookup range as large as your list is likely to get, you should be OK.

 

[HolyLemon]

Is there no way i can ask the Vlookup to check a column rather than a set range? Because theoreticly the list could go to the end of the sheet in a couple of years time. I'm off now so I wont respond till tomorrow, anyones thoughts are still welcome though.

P.S I populated it with dummy info, there really are 2k+ ppl on the real list. Thanks