Copy Data to a New Sheet if criteria match (multiple) using a Command Button
Hi
I am new to this forum and hope someone could help me with a project i am working on.
My issue is:
I want to copy a list of data (roughly 1000 rows and 20 columns) to a new sheet if column say, "M" match the criteria (note the criteria are texts)
Many thanks in advance for your help.
Welcome to the forum bambobeee!
You try the below code:
Replace column "D" with your column and "ABC" with your match criteria
Please Login or Register to view this content.
Hope this helps.
Kiran
Thanks Kiran
I will try that now
Re the code above - how can i change the code to copy to an existing sheet, say "Sheet6"?
Also, is it possible to only copy selected columns only to the new sheet, say columns A, B, C, D, M and G?
Last edited by bambobeee; 12-29-2012 at 01:19 PM.
This is what I used in a separate sheet, it works for matching one value criteria.
How can I change the code so the criteria is to match texts in Column "D" (which has four possibilities)??
Please Login or Register to view this content.
See if this works for you.
Please Login or Register to view this content.
many thanks! I have integrated your code and it works fine.
Glad to know it had worked. Happy to support any thime!
Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks