Hi all,
I need to paste unique values (based on multiple criteria) from my data set to another sheet and want to use VBA in order to avoid using array formulas and slowing my file down significantly. I'm not that familiar with using advanced filtering, but that might be the best option, as it is an Excel built-in function? Open to other efficient solutions...
Please Login or Register to view this content.
Last edited by esbencito; 12-07-2018 at 04:24 AM. Reason: added first VBA attempt
try
Please Login or Register to view this content.
Regards,
MohanS
"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi
You can simply say thanks by clicking "*Add Reputation" icon
Another way.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
mohan.r1980,
This seems to ignore the 2 criteria I have...
Last edited by jeffreybrown; 12-07-2018 at 08:12 AM. Reason: Removed full quote!
bakerman2,
Thanks. Great solution! A little slow in my actual data set though. Is there a more efficient way to do this, such as Advanced Filtering?
Last edited by jeffreybrown; 12-07-2018 at 08:13 AM. Reason: Removed full quote!
Try this for starters.
Thanks bakerman2!! This is a good start! Do you also happen to know how to filter only the unique items in "KEY PROGRAM"? It currently returns the item "STRETCH CHINO" twice. The "<>" sign in the criteria range is only used to get rid of the blanks I assume?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks