Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Advance Filter
Hi All,
PLease help me. I Have a Data sheet which have 200 record which we protect and deliverd to user and have A to I column. I can another Product List where data comes from datasheet with one critera. I can take help from http://www.contextures.com/excelfiles.html under Filters, for 'FL0002 - which is 95% same as my requirement. I have only one problem. in my data sheet have A to I column and In product sheet I need only selected column like A,B,D,F,G only. I can show which code i use. Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row = 2 And Target.Column = 3 Then 'calculate criteria cell in case calculation mode is manual Sheets("ProductsList").Range("Criteria").Calculate Worksheets("ProductsList").Range("Database") _ .AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheets("ProductsList").Range("Crite ria"), _ CopyToRange:=Range("A6:I6"), Unique:=False 'calculate summary total in case calculation mode is manual Sheets("Data Entry").Range("D2").Calculate End If End Sub Exmaple Data Sheet Product sheet (after advance filter) Column A B C D E F G H I A B D F G Thanks RKS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advance Filter Formula | Excel Discussion (Misc queries) | |||
Advance Filter update | Excel Discussion (Misc queries) | |||
Advance Filter | Excel Discussion (Misc queries) | |||
advance filter | Excel Discussion (Misc queries) | |||
about advance filter | New Users to Excel |