YTLE#65: Merge 2 Tables: VLOOKUP & Advanced Filter

Hi,

I am using the advanced filter to create a new table in a separate worksheet. The table creates fine, but when I update my original table, my new table in the other worksheet does not pick up the new entry.

Could anyone please tell me the solution to this


Many thanks

Walker20

Hi, I'm trying to select all cells which don't begin with letters. However, I am using the advanced filter tab with 26 checks. Is there any more generic way to check of a cell begins with a letter?

Hi!

Does anyone here know how to go about filtering criteria based on three different columns, using xlFilterCopy from one worksheet to another?

I am using the code below now for 1 filter criteria, works great, but I need to filter 2 other additional columns... Does any one know how to mod this code to make this happen??

Your help will be appreciated.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 2 And Target.Column = 2 Then
Sheets("Parts Entry").Range("Criteria").Calculate
Worksheets("Parts Entry").Range("Database") _
.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("Parts Entry").Range("Criteria"), _
CopyToRange:=Range("A6:K6"), Unique:=False
Sheets("Part Search").Range("B3").Calculate
End If
End Sub

Thank you in advance!

Input Output



1 1



2 2



3 3



1 1



4 4



3




3










I've used the advanced filter in order to filter out duplicate rows. However, based on the output, "1" does not filter out by the function. Could someone please tell me whether

there is any limitation on this advanced filter funtion? Thank you

I have a spreadsheet which I perform an advanced filter, but the problem I have is that when I get the results of the advanced filter I wish To filter further.
This causes the advanced filter to be removed. Is there some way of filtering the results of an advanced filter.

Thanks for you help

Des

Have spent a good while researching this and haven't found anything.

All I "simply" want to do is use auto filter and advanced filter to filter a column of numbers based on the first digits.

For example, let's say I have a column of data such as:-

177990
177346
189344
905343
177343
905454


I want to enter criteria such that I select all the rows that begin with "177".

You might have thought this was easy and just need to use 177* with the "begin with" auto filter statement or "=177*" with advanced filter. However, both criteria select nothing.

After a little testing I realised this is because excel must store the numbers as numbers (i.e. not strings). So if I insert a ' in all columns the above criteria works but NOT if I use the criteria as above.
The *silly* thing is if I try to match the whole number (not just first 3 digits") the criteria works fine.

Now, surely I'm missing something simple here and there is a way to filter part of a number?

Thanks!

Hi everyone,

I'm trying to filter some data so that entries with empty cells aren't included. I have this:

Code:

 
 Range("C1").Copy Destination:=Sheets("sketchpad").Range("A1")
'
Sheets("sketchpad").Range("A2") = """"""

but it's not working.
Can you help?

Thanks,Nigel

Hi

Can anyone explain why the unique filter does not produce a unique result - sample attached?

Thanks

I have a project I'm trying to do for work. I have a catalog of about 280 entries (this will grow) with 8 columns each. Each row is numbered sequentially in the left-most column, and my goal is to have a user be able to type in a number in a separate field in order to populate an entire row with the rest of the data from that row. For example:

Code:

Number   Color   Animal   Shape   State
   1     Green     Dog    Square    WI 
   2     Blue     Bird              WA
   3     Blue      Cat    Circle    CA

If the user would enter a 2 in the field, the rest of that row would auto-fill a blank row with the rest of the data (Blue, Bird, , WA). On top of this, I would like to make it so the user could enter any value from any of the columns and that would also fill the rest of the row data in the blank row. Here's what I mean:

Code:

Enter a number:   2              Enter a color:  
Resulting row:     
Number   Color   Animal   Shape   State
   2     Blue     Bird              WA

To make this even more complicated, some of the cells in the columns have the same value (like the color Blue), and I want to make it so that if the user were to enter the value Blue, all the rows with Blue in them would be auto-filled in the blank rows:

Code:

Enter a number:                   Enter a color:  Blue
Resulting rows:
Number   Color   Animal   Shape   State
   2     Blue     Bird              WA
   3     Blue      Cat    Circle    CA

I have tried using functions to make this happen, but I am running into quite a few issues. I have played with macros to accomplish this, but I'm short on time and am hitting too many walls.

Any help would be GREATLY appreciated, and I will try to better explain this project if I need to.

Hello,
I have 3 sheets. One is my data sheet, one is the results sheet where I want my filtered data to display and one sheet is the one where i have 5 comboboxes that are supposed to filter the date from my date sheet. What I want to do is somehow use the comboboxes (each has one criteria) to filter the data from the data sheet and take that filtered data and display it in my results sheet.

Is that possible at all? I tried to use the advanced filter but it doesn't accept my comboboxes as criteria. Also I don't know how I can connect my combos so that one variable depends on the other.

I am fairly new to excel and VBA. So far I have mostly used recorded macros but I guess that won't do it this time.

Please help me!! Thank you soooo much!!!