PDA

View Full Version : Picking only records based on po #.



aligahk06
04-18-2010, 11:32 PM
Dear All,

i have imported my data from Access form.In my excel sheet i am having 2000 records starting from A2.
In ColA2 Contains po#, B2 contains date,C2 contains amount,D2 contains Retention amount,E2 contains remaining amount
F2 contains Contract #.

I have a to pick only a few i.e 100 different po # and their corresponding value from the collection.
Since the po number format is 6510325314(10 digits) and it is random.
Data is huge and filtering each po # is difficult and time consuming.
So is there any way that i can get our desired records from the collection based on our 100 Different po #.

Any macro mor code or function.
Help is deeply welcom?
attachment is for ref.

Rgds,
Aligahk06

Aussiebear
04-19-2010, 02:45 AM
What is the criteria for random?

aligahk06
04-19-2010, 03:08 AM
There is no random criterion. It is only 10 digit Po number.

GTO
04-19-2010, 03:32 AM
...Since the po number format is 6510325314(10 digits) and it is random...

What is the criteria for random?

There is no random criterion. It is only 10 digit Po number.

:bat2:

Dear aligah06,

I am teasing of course, but I must say that the issue description is less than clear.

Do you have any code so far? Have you tried recording a macro to show at least what we would be doing with info/records from a given PO?

Mark

mdmackillop
04-19-2010, 05:18 AM
Add a couple of helper columns and filter the result. It may not be exactly 100, but that doesn't sound critical. If you need more, adjust the ratio accordingly and ignore any after your required sample number.