Hi All,
I have here a file, and it has some validations.
After running the validation, all that was tagged as "PROCEED" in column AA should be copied just like below.
Attachment 378006
May i ask how to do this using advance filter using VBA?
I have lots of data and tried using formula such as index match but the file kept on hanging. Thank you.
Hi,
Based on what column do you want the data to be extracted..?
Is it the "PROCEED" Rows you want to extract..?
AND
Which columns do you want in the output..?
Are the ones listed below
Personel Number ACCOUNT GRP COMPANY CODE ACCOUNTING CLERK CREDIT REP GROUP KEY
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Hi Vikas,
Thank you for your response. Once the analysis in column AA is "proceed" below are the needed output of those who passed:
Column AC - Personel Number
Column AD -ACCOUNT GRP
Column AE-COMPANY CODE
Column AF -ACCOUNTING CLERK
Column AG - CREDIT REP GROUP
Column AH -KEY
Output in sheet2. Run "test"
Last edited by Blokeman; 02-18-2015 at 08:39 AM.
Please click the * Add Reputation if this helps
If solved remember to mark Thread as solved
"I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
Try this one:-
Please Login or Register to view this content.
Last edited by Vikas_Gautam; 02-18-2015 at 09:25 AM.
Hi Bloke Man,
the output should be in AC. Where can i change in the code?
Hi Vikas!
Your code is working. But the output should be on column AC to AH in sheet 1 also
All the rows will be filtered from A to last column so I have to put in another sheet.
Oh i see. but i need it on the column AC.and the headers should not be copied
I have made the changes in the above code..
Try and tell..
Re: Advance Filter - vba
Click the Run Button
Check the attached file:-
Hi Vikas!
Superb!! Got all the correct data needed!!
hi vikas,
i tried transferring the code you gave in the attached, how wver, i have an error with that code and says it cant delete merge cells.
The final look of the template would be like this in the attached. And now, when i clicked the run button, the data in column T up to column AA is deleted.
Here is the new code:-
Check the attached file:-Please Login or Register to view this content.
Last edited by Vikas_Gautam; 02-20-2015 at 03:26 AM.
Magandang hapon
Made a mistake on my first code;
Please Login or Register to view this content.
Hi Vikas,
It copies all the data even the invalid for next step.. Only those who are tagged as proceed should be copied.
Check the corrected attached file:-
Hi Vikas!
Wow!!
it worked really great! Juts a thought, i think its my fault. It should be column AC to AH until the key only.
I might have doubled up the account group and key in column AI and AJ. and
How can i remove since it was also being populated? nonetheless, superb!! made my day
Last edited by geliedee; 02-20-2015 at 03:52 AM.
Hi Blokeman,
thank you also! how can i put in the code to copy only the text and not the format itself?
Sorry, I couldn't understand..Originally Posted by geliedee
Hi Vikas!
Wow!!
it worked really great! Juts a thought, i think its my fault. It should be column AC to AH until the key only.
I might have doubled up the account group and key in column AI and AJ. and
How can i remove since it was also being populated? nonetheless, superb!! made my day
Sorry vikas, it all okay now. Thanks for your patience and for helping me out!
Try this without format.
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