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