• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy a row based on IF condition

V

Vikram554

New Member
Hello Everyone,

I am doing a project which generates close to 12,000 values(Texts) in a table. Each has unique values. I have another sheet that asks the user their preference. Now I need to match the preferences and the values in the generated table. If they match then that particular row must be copied to another sheet.

Let me give an example to make it clear.

Sheet 1: Where there is 12000 rows and few column
Aircraft Passengers Crew Engines Manufactured
A380 150 12 2 France
A380 125 8 2 France
A380 500 21 4 France
B747 200 5 4 US
B747 125 6 2 US
B747 200 8 2 US

there will be so many possible combinations like this.

Sheet 2: The user says: He wants
In aircraft A380 and B747
In Passengers 500 and 125
In Crew 21 and 6
In Engines 4 and 2

I can get this as an input. (// they can give more than 2 aircrafts too )

Sheet 3: So based on the input this sheet should filter those and give it as an output.
Aircraft Passengers Crew Engines Manufactured
A380 500 21 4 France
B747 125 6 2 US

Hope I clearly stated my problem. Anyways to do it with or without VBA? ANy leads will be greatly appreciated. Thanks in Advance.
 
I very do not understand why you spoke « Auto Filter »
as my advice is upon advance filters working
whatever directly from a worksheet
or within a VBA code automation
as you can see samples in threads of VBA Macros forum …

And as you must read in tutorial criteria range is a matrix !
​
 
I am sorry.. I was in a rush! I meant to type Advanced Filters but ended up typing Auto Filters. And yes I did go through the threads to see if anything related is applicable to my case. Unfortunately no, mine is way more complex scenario I believe. Anyways thanks for your help. I appreciate it.
 
You must log in or register to reply here.
Back
Top