data filter

  1. T

    Filter loop through macro

    I have various workbooks that I need to check the data in by filtering on various columns to find those that need to be checked and then I filter through the resultant list using usually column 'C', checking line by line and marking those 'done'. What I'd like to achieve is a button that...
  2. B

    Data filter only some columns

    Hi guys - grateful for any assistance you can give. I have done this before via VBA but can't recall exactly how. I have a worksheet with various headings, as below. I want to have data filters available on some headings, but not others. For instance: Columns A, C, D & F, but not visible on...
  3. U

    Data removal and copy it to new location

    i have two excel sheets one have 1000 records in SHEET A one column and other have 100 records in SHEET B one column. i want to check these 100 records of SHEET B with 1000 records of SHEET A and out that if any record match it should be removed from 1000 records of SHEET A and copy it to third...
  4. D

    combo box, data filter

    Hi, I would like to create a data filter (kind of combo box I think). I want to have this data filter in cell D1 to show unique values (no duplicates) of what is in cell B2:B50000. Besides if I select a value in the filter, I would like to see all the rows associated with that value...
  5. M

    Line of code to select only the data on a worksheet to filter and have a formula against

    Hi all, I've been trying to wrack my brain around trying to sort this code out. At the minute, the macro runs fine but it's based on a set range between B2:B15000 which is a lot! However, I wanted to make sure that the macro would cover everything. I was wondering if there was a way to make it...
  6. J

    Excel Data Filter Drop Down list

    I have two Excel spreadsheets in this workbook and am using 2007 for development. Sheet1 contains the raw data and sheet2 contains summary information about the data on sheet1. I wish to restrict the user's access to sheet1 but I would like the user to be able to apply filters on the data in...
  7. B

    Data Retrival Userform in Excel

    Hi All, I urgently need assistance. I have created an excel workbook that contains 4 worksheets. Each worksheet contains candidate data with fields such as Candidate name, ref number, location, job title etc. I am very new to this all and with the help of Google have managed to create a data...
  8. D

    Need Help Converting Data

    After I download data for my real estate reports I need to convert multiple "Map Codes" to a area name such as South Hill. For instance the "South Hill" is made up of 25 map codes that read like "A622/135". I would like to be able to turn all of the map codes into "South Hill" so that my...

Watch MrExcel Video

This Week's Hot Topics

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
Top