advanced filter

I'm struggling with what I think should be simple. I'm using excel 2010. I have a data set with many columns, 2 of which i'm interested in. Let's say column A is "Department Name" and the Column B is "Product name". Both columns could change at any time (More depts could be added, and the...

Hi Guys, What I'm looking for is to have a macro which would do two things :- 1) A macro which looks at one column which contains date and time in "dd/mm/yyyy HH:MM:SS" , and irrespective of time, filters for the record corresponding to the start date and end date. 2)Since the source sheet...

I'm trying to use a adv filter to pull out, in a separate table, items from a table which meet a criteria based on a formula ie. the criteria should look at 'starting column' F, and is only if that number is smaller than the sum of columns D & E. If tried a IF Formula but cant seem to get it...

I know there are TONS of posts like this, but I have not yet been able to implement one of them that I can get to work. Its probably because I'm a complete noob at VBA though. I have an advanced filtered data set that dynamically changes in row size and goes to column N that is on Sheet...

Hi all I have searched far and wide for a solution to this, and i think i'm out of my level of expertise now, so here goes: I have a doc with 3 worksheets. Worksheet 1 needs to pull data from a master data worksheet in #3. In order to do this i've been using advanced filter and copy to location...

hi all need your help again :) as u can see on picture I have some data and i want it to filter with "debet" and "credit", while debet can be zero or number x when in the same time credit can be zero or the same number x so when entering number x meaning e.g. 500 i get to rows first debet =...

Greetings I am new on this forum and learning excel vba programming. I currently want to be able to filter a large amount of data based on a criteria supplied into a separate range from a userform with multiple list boxes. I have managed the form and the listboxes, i just want to be able to...

Morning, I'm new to the Mr Excel forums but am in a bit of a loggerhead with a searchable/filterable database I am trying to set up. I have a rough understanding of VBA (mostly I record macros to see what the code looks like then edit it it suit my needs). I'm trying to set up a a spreadsheet...

Hi, I have done a bunch of searching but just can't really figure out how to phrase what I am looking for, so hopefully someone here can help me out. I have an array that has a bunch of names with dollar values of an account of theirs next to them. People have multiple accounts and come up on...

Is there anyway to send the criteria via VBA? rather than having them on a worksheet? For instance via the data held in an array?

I need help to figure out why the date criteria is not working. I'm still learning about advanced filters and criteria with formulas, but this date thing is really testing me. Strangely enough, if the date comparison filter is changed to less than, it works, but comparing greater than doesn't...

I have some shares and i want to do some comparisons. eg. This month vs last month, this week vs last week, this week vs last 6 weeks ect I have been experimenting with the advanced filter but keep bringing my self to confusion. For now what i need is to extract data for each year, month, and...

Hi everyone, First time poster, long time follower. I have been struggling hard with a particular VBA code. I'm trying to take a column of data on a sheet (sheet1) and use it as filter criteria for a specific column on another sheet (Q1 2009) within the same workbook. I have code below that...

Hello and thank you for the help. At work, I have a workbook with multiple tabs that contain lists. Each tab has a corresponding Pivot Table. There is a business requirement that a user can specify a name, which filters the data. For the sake of simplicity use this for an example Column...

Hello, I'm trying to use an advanced filter to filter a large data set using several parameters. I had this worked out before but there have been some parameters added that have thrown my filter off balance and I'm struggling getting it back. Here's the criteria I need to filter Column 1...

Hi guys and girls, sorry for the re-post but I just figured out how to share my file on Windows SkyDrive. https://skydrive.live.com/redir.aspx?cid=4cdbd283ac4cd6f6&resid=4CDBD283AC4CD6F6!102 In the attachment you will find a list of products named "list." The first column is the product...

I have a master list of all of our parts for our inventory system as seen below <TABLE style="WIDTH: 959pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1279><COLGROUP><COL style="WIDTH: 45pt; mso-width-source: userset; mso-width-alt: 2194" width=60><COL style="WIDTH...

Hi all, I've managed to modify some code I've found on the site (Thanks RoyUK!), that I would like to perform an advanced filter on my data and create a sheet for each unique value, then copy and paste the data for the unique value. The code below, currently works if I use the file I...

Hello, I am trying to correct a very simple macro for filtering and copying data from "Master" sheet to a second "Complete" and third "In Progress" sheet. I would like to filter rows denoted with the data "C" in the "Master" sheet to the sheet "Complete." Rows with data "IP" will be filtered...

Hi, If you could help me resolve a minor issue, it would be appreciated. I'm using Excel 2007. Basically I have a table that consists of multiple columns with the headers in row 8 (Table Range - A8:F81). I want to filter this using advanced filter to remove 'blank' cells. The cells that are...