advanced filer

  1. L

    Advanced Filter VBA

    Hello, I'm using an advanced filter vba to search for data from within a large data set onto another sheet. I've worked this before but this time it is not working. Range("Sheet_K_2D_FinancialInput").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheet15.Range("BV4:BZ5")...
  2. K

    VBA - Filter Date by Month & Filter Name and Support location

    Hi, I am new to VBA. I actually trying to learn on how vba work by trial and error. In my worksheet, it involve with vba auto filter (support base and name) and vba advanced filter (month). However, both auto filter and advanced filter cant run simultaneously on my data. What should i do in...
  3. D

    Transpose Unique Values in column to row

    Column A on Sheet1 has many different remarks. I need to make a unique list on Sheet2 with values from Column A on Sheet1 but post it in one row. This is the idea: Sheet1: Column A 1 1 2 2 2 3 3 3 Sheet2: Column A------------Column B------------Column C...
  4. M

    Advanced filter criterion loop for querying Excel database

    I have a userform and database for entering food purchases by receipt. The database is arranged with its first few left columns containing date information for each receipt, with the other columns representing the food items and their costs. There are over 140 such food item columns. I am...

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