vegas86
asked on
Help with excel 2010
Hello
Can someone please assist me in writing a macro for the attached?
Basically all I need is for the macro to search column Q ‘client’ find all matching numbers eg ‘57337’ filter on that and then in column P ‘order’ it needs to find the lowest and highest number and copy both of those rows and past into a new sheet.
Can this be done?
Any assistance is appreciated!
test.xlsx
Can someone please assist me in writing a macro for the attached?
Basically all I need is for the macro to search column Q ‘client’ find all matching numbers eg ‘57337’ filter on that and then in column P ‘order’ it needs to find the lowest and highest number and copy both of those rows and past into a new sheet.
Can this be done?
Any assistance is appreciated!
test.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help. Thanks for the grade.
Thomas
Thomas
ASKER
Thank you!