Filter for Dynamic Fields & Criteria and copy to other sheet

**Abdur_rahman** · 11-29-2016, 10:27 AM

Hello Again,

I am looking for help to apply Filter for Dynamic Fields & Criteria and copy to other sheet.

I am receiving data with changes in columns from F to column P. Sometimes there is only 1 column as BB (Column F) or sometimes I am getting 4 columns let say VIP+ (Column F), AA (Column G), BB (Column H) & C+ (Column I).

So it is very hard to apply filter through VBA macros. If the format is standard then it is working if it is non-standard filter cannot be applied to copy to other sheet.
Explanation:

If a user select VIP+ ON userform Combobox1 and VIP on userform combobox2 then the filter must be applied on columns 6 and 7. Column 6 (VIP+) value is dot and Column 7 (Blanks) values as blanks.

If a user select AAA ON userform Combobox1 and B on userform combobox2 then the filter must be applied on columns 8 and 13. Column 8 (AAA) value is dot and Column 13 (Blanks) values as blanks.

**LeoTaxi** · 12-01-2016, 07:39 AM

For Dynamic Fields

Please Login or Register  to view this content.

Kind regards
Leo

**Abdur_rahman** · 12-01-2016, 10:03 AM

Thanks for your response.

your script is working well if both combobox have value which is matching on the row 1. but it is popping up an error "Run-time error '13': Type mismatch" when combobox1 have value and combobox2 is empty.

Why this procedure is the policy is having only a single network then it should select <> for combobox1. it should filter only the single selected value.

**Abdur_rahman** · 12-01-2016, 10:40 AM

After some workout I came up with the below code. But the below code I displaying the entire list of networks but I need to display on those networks which is available on the sheets.

Please Login or Register  to view this content.

**LeoTaxi** · 12-01-2016, 07:58 PM

The only NETWORK i find is the sheet name of 1 of the sheets

Sheers
Leo

**Abdur_rahman** · 12-02-2016, 01:21 AM

Its OK.

With your little help I will manage to do that also.

Thanks for your help.

Filter for Dynamic Fields & Criteria and copy to other sheet

LinkBack

Thread Tools

Rate This Thread

Display

Filter for Dynamic Fields & Criteria and copy to other sheet

Re: Filter for Dynamic Fields & Criteria and copy to other sheet

Re: Filter for Dynamic Fields & Criteria and copy to other sheet

Re: Filter for Dynamic Fields & Criteria and copy to other sheet

Re: Filter for Dynamic Fields & Criteria and copy to other sheet

Re: Filter for Dynamic Fields & Criteria and copy to other sheet

Thread Information

Users Browsing this Thread

Similar Threads

Filter, Copy, Paste in a new sheet and give heading based on criteria

[SOLVED] Copy various fields from one workbook to various fields in another by criteria

Filter and copy non continguos columns (criteria by Date another sheet)

filter data based on criteria and copy to another sheet

[SOLVED] excel macro Filter all sheets with same criteria and copy results to new sheet

Filter for Two Criteria and Unique list copy another sheet

[SOLVED] Loop through Auto Filter Criteria and Copy Formula Results Into New Sheet

Bookmarks

Bookmarks

Posting Permissions