Hello,
So is have a backlog file with vendors that needs to be filtered one by one vendor, pastate each line with specific vendor data to new excel workbook and save it in folder.
The problem is, i do not know how to clarify filter criteria, as the vendors in excel changes every day.
Should i make it with if criteria including every vendor?
Thank you in advance.
Last edited by Nadina; 11-28-2017 at 05:52 AM.
Use Dictionary to extract unique vendor names and then loop through Dictionary elements to apply Autofilter to Filter, Copy to new workbook.
Attach sample workbook if you need code to do so.
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.
I have attached excel to my original post.
Last edited by Nadina; 11-28-2017 at 05:53 AM.
This should do it.
Please Login or Register to view this content.
Thank you for the code.
I Run into Error, for lineIt shows as "type mismatch". Could you please advise?Please Login or Register to view this content.
All works fine for me in your example file so did you try that or did you put the code in a different file ?
Yes, i found the problem. I am sorry that i keep asking question, but i have one more.
As i have little encounter with Dictionary, i am new to this and learn as i go.
How can i change that it takes not the vendor names from the second column, but their number from the first column?
I tried to change it myself but i messed it up in the end.
The files are now also named by vendor numbers. Let me know if you want them by name.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks