Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
filtering he data is not always correct
Hello,
This is the VBA of filtering a data and then copy it to another sheet. This code I found from this very helful forum. My question if I filter it for M Code only( coz the project code is M10-7-001 or E10-7-005 and so on) it show all, not only M. Anyone can help me why? Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 5 And Target.Column = 4 Then 'calculate criteria cell in case calculation mode is manual Sheets("data").Range("Criteria2").Calculate Worksheets("data").Range("database") _ .AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheets("data").Range("criteria2"), _ CopyToRange:=Range("B10:v10"), Unique:=False End If End Sub Thanks very much Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering of data - autmatically based on data on other sheet | Excel Discussion (Misc queries) | |||
Comparing Data (Im not sure if that is the correct tern) | Excel Discussion (Misc queries) | |||
Autopaste data based on correct MO. | Excel Programming | |||
Pivot table converts data to a 1,2,3 how do I get data to correct | Excel Discussion (Misc queries) | |||
joining to worksheets or filtering not sure of correct terminology | New Users to Excel |