Filter column A with the predefined filer criteria put in column C paste to the range having filter criteria header

nbuddhi

New Member
Joined
Jun 23, 2020
Messages
29
Office Version
  1. 365
Platform
  1. Windows
Dear Team,

I have some 20000 entries in column A and need to filter those data with multiple criteria and extracted to columns in same sheet. I will put fitter wording in column C and will name the paste headers as filter criteria. Kindly help me on this. I just attached a image to simplify my need. Thanks in advance.

Thanks & Best Rgds,
nbuddhi
 

Attachments

  • Data.jpg
    Data.jpg
    173.6 KB · Views: 9

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Dear Team,

Correct screenshot attached. Kindly help to search for criteria with looping and save the details in any column range. Auto filter or sear option and save the data is ok.

Thanks & Best Rgds,
nbuddhi
 

Attachments

  • Macro.jpg
    Macro.jpg
    153.2 KB · Views: 4
Upvote 0

Forum statistics

Threads
1,214,375
Messages
6,119,166
Members
448,870
Latest member
max_pedreira

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top