filtering

I am trying to create a filtering scenrio. Ex. The value of Sheet1 in cell A2 is username "Admin", if that happens all Username with admin in Sheet2 will be filtered from the table of raw data.

Hi, when I set up a standard data filter on a sheet, the filter drop arrows automatically appear in row 1 of each relevant column. Is there a way to have them appear, or begin their filtering process, from, let's say, row 4 .... because i have rows 1 through 3 containing headings and...

Hi I have a column which has lets say 5 depts: hr, it, sales, marketing, and admin. If I want to see only hr dept. I apply filter and then select HR. What this called? Filtering all other departments except HR, OR filtering HR and leave other departments. Thank you very much.

Hey! Looking for some help with creating an input box to filter an Excel spreadsheet that has about 1900 rows of data. I want to have a push button control that will produce an input box where the end user will enter data to filter the list. Data will be located in column A starting in row...

Thank you in advance! I have two issues with Autofilter 1. Autofilter is going to the first row instead of row 8 2. Is not filtering out blanks and/ or cells with formula that results in a "-" o dash Code: Sub hideemptyrows2() Worksheets("Indirect Cost Forecast").Activate Sheets("Indirect...

Hi Guys, After an extensive web search I could not find a solution to my problem, which actually makes this my first question on this forum. Any help will be greatly appreciated. Excel has two ways of reporting/labelling/filtering my Pivot Table rows: 1st way (desired): After applying a...

HI, I have a sheet with data in Column "H" for sales figures representing customer sales. I have a cell "D3" that I need to sum total the sales figures based on all sales from "H" but only in conjunction with filtering. So when I filter specific customers the traditional way (from any other...

Hey Folks, Wondering why my pivot table, which draws from a cube (OLAP) source, isn't filtering on the true top 100 customers we have! The pivot columns are months (August 2017 through July 2018) and the rows are individual customers. My value filter is set to customers, filtering by "top 100...

Hi there, I had a macro that ran a report on a protected workbook. However there is now requirement to keep the workbook shared at all times so what used to be the first part of the code which would enter the password to unlock the protection no longer works while the WB is shared. I have...

Hi, I have many columns in excel that I need have the rows within each sorted. Values in column B have been duplicated in column E at but they aren't in the same row. I need to match the rows from column B and E such that each row in B has the corresponding cell from column E below it. I would...

Hi, i would like to create a formula for filtering corresponding month, last month and same month last year. My dataset is unfortunately not with a specific date, this is what how it looks like and how i would like the filter to react <tbody> Year Month Filter 2018 5 1 2018 4 1 2017...

I am filtering a column based on a date. The date is currently hard writen into the VBA code. So to change this date I have to go into the module each time and change the date in the code. Is there away to change this date though a user form or something before this code runs? The code I am...

Hello all, My code starts with a range that the code filters and there supposed to be left 3 values after filtering. Each value has its own sub-procedure. The range is column "B". I would like the first sub, the one that filters, to check if what is left after filtering is actually there. If...

Hi guys, Here's the type of data i'm talking about : <tbody> Client Invoice A F17XXX A F18XXX B F18XXX C F17XXX C F18XXX C F18XXX E F17XXX </tbody> So i know how to use advanced filtering to have an output range that looks like this : <tbody> A B C D </tbody> But...

Hello, İn atteched file there are datas which are in every 5 columns.I will use block instead of 5 columns Each two blocks columns are a group. I need to find same date of these two blocks columns and sort by filtering those which are repetition will be at the beginning with their datas.(with...

Hi All, I would like to have a table where the rows have alternating colors, but without the use of table formatting (because it slows the excel too much down). AND after filtering the rows should still have alternating colors for the visible rows. The last part is what I'm struggling with...

Is it possible to return the values of each column visible in a filtered pivot table? I have a PT set up that holds a column of data called 'Type' which is a text string. After filtering the PT down using the PT filters I have a drop down that gives me all the options that are in the data but...

Hello, In the attached file there are lists that recurring every 5 columns. Every first columns has > symbols. Firstly I neet to filtre all page by > symbol. Secondly every second columns has abbreviation name. I need to check there are abbreviation name in every second columns. After...

Hello All, Currently I have 2 columns of data, each contain about 100000 records. First column contain Folder names (Image, Birthday, Job,...) and the second contain the name of files and sub-folder that in that folder, each row is a different files/folder. Something like this: <tbody> Folder...

Hey everyone.... I'm looking to create a macro that will update a PivotTable filter to the most current/recent date -- this date will be end of month (so a 01-31 for example, these dates are formatted like -- 2018-01-31T00:00:00). The idea is that the code will reference a cell within my...