filter advance

Hello, This is my first post. I am managing a group of 20 salesmen. I want to send each salesmen a report every week but I don't want to do it manually. Is there an easier way to do this? I am thinking VBA and advanced filter. How do i post my spreadsheet? Thanks,

I've using the `FILTER` option (Auto Filter) in Excel 2013. When filtering what I need is to place a 'minimum' number of rows that must be returned. For example, if I place a filter on a column and then choose a filter option and the number of rows returned is less than 10 then the rows should...

I have 3 separate PT on a worksheet. Each PT's datasource is linked to a separate tab. I would like to control the filter "employee filter" by typing/selecting the employee's name on cell A3 (whicheve cell). I've looked around in the forums and found a few threads with almost the same request...

Hey, I am Im trying to set up an auto filter to only leave 18+ and blank cells but I cant get it to work this is what I am using ActiveSheet.Range(Cells(1, 1), Cells(lastRow4, 40)).AutoFilter Field:=3, Criteria1:=Array("=>18" , "="), Operator:=xlF

Hi Guys, I tried to search these forums and Google for an answer but I could not find anything. What I am trying to do is filter a worksheet by a value from the cell in another. So I have two worksheets one is called "Reports" and one is called "Setup Data". The Reports worksheet will be the...

Essentially I need to filter or highlight all cells in column A that contain any of the state names in Column B. How is this done?

I'm fairly new to the world of macros but i have managed to set up some simple macros that filter some data by using the "Adavanced Filter" function. This data is filtered to show whether a set of chemical standards are going to expire "within 2 weeks", "within 1 month" etc etc. These have all...

I can find plenty of solutions to this problem for data that isn't stored in a table but nothing for table filters. I'm creating a table for a Sales Forecast which stretches across over 200 columns. The reason for this width is due to all the various comparisons that can be done by customer...

Hello, I am trying to filter a large table based on a specific text. For example my table has 100 rows and 15 columns all with different data. I would like to filter for only rows that contain a specific text. **Note this "text" might be in different columns. For example I might have the text...

I have a "Time" Column with about 23,000 rows of assorted times and various other data in a particular row. I want to filter out rows with Times between 8:00:00 am to 5:00:00 pm. In Other words I don't want to see those rows. EXAMPLE: <tbody> Time 08:06:06 AM...

Hi, I'm trying to auto - filter column 2 "Frequency" by today's current date, Cell A1 & by the word "Daily". I'm trying to make this happen automatically once the user opens the workbook. For example, if the user opens the workbook on a Wednesday, the Frequency table should be filtered to...

Hi everyone I'm trying to generate a report wherein i dump a relatively large dataset in a hidden sheet. To create the summary from this, I need to use a criteria on a one field and then sumproduct the visible records from two others For illustration, consider the following table: Scenario ...

Hello I really need some help, I would like to set up a Macro/VBA that filters the contents of my table based on the contents of a cell in another sheet. Key Info: The table is in a sheet called: 'GOALS ANALYSIS 2.0' The table ranges from cells: A4:HQ368 (Including headings) The column I...

Hello folks I have a problem that cannot be completed using the advanced filter; I have >1500 columns in a dataset (D:BIH), and I need to extract the unique values for each individual column. The advanced filter fails after doing any more than 3 columns at a time, simply doing a copy/paste of...

Actually my Basic question is how can I copy data from filtered data and paste in visible cells only For Example I have copied Row no. 2,4,6 fro this GREEN table and want to paste same date in J and K column (in same row numbers)then how can I do this ? File is attached for ref.

I am looking to setup a filter within Excel that will show me all the rows within one worksheet that contain full words from another worksheet. For example: This is in Worksheet A: <tbody> Word List A </tbody> <tbody> email software free email client free email programs free email...

I am in real trouble. I have been searching endlessly for a solution and have gotten nowhere. Basically I have a report that needs to be updated every month on the redemptions a website has orders through. I receive a datasheet that has basically all the data before hand from where it all...