Hi All, Please assist with Auto filter Here the data is limited only few lines as sample i have given.
but in reality data will more two lac lines .. can you please place even if data rows count increases. i tried for vlookup like dis Range("F2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],CCLIST,5,0)" Selection.AutoFill Destination:=Range("F2:F" & Cells(Rows.Count, "A").End(xlUp).Row) can you please advise how can i replicate same to autofilter Sub Anil() ActiveSheet.Range("$A$1:$H$47").AutoFilter Field:=4, Criteria1:="=ROY*", _ Operator:=xlOr, Criteria2:="=ROD*" ActiveSheet.Range("$A$1:$H$47").AutoFilter Field:=7, Criteria1:=">0", _ Operator:=xlAnd Range("H2").Select Range("H2").Value = "Updated" Range("H2").Select Selection.Copy Range("H4:H46").Select Selection.SpecialCells(xlCellTypeVisible).Select ActiveSheet.Paste Range("A1").Select Application.CutCopyMode = False End Sub Thanks, Rekha On Fri, Jun 28, 2013 at 11:57 AM, अनिल नारायण गवली <gawlianil8...@gmail.com>wrote: > Dear Rekha, > > Pl see the attached workbook. > > Warm Regards, > Gawli Anil > > > On Fri, Jun 28, 2013 at 10:36 AM, rekha siri <rekha.siri2...@gmail.com>wrote: > >> Hi Experts, >> >> Please help in this concern >> >> i am attaching sample data spread from Column A TO H >> >> in H Column i want to update Status as per below criteria >> >> >> 1) Filter Reference column --> custom filter --> Begins with ROD OR >> Begins with ROY >> Update the Status as Excluded for visible cells in Column H >> >> 2) Filter Reference column --> custom filter --> Begins with ROD OR >> Begins with ROY >> and apply filter in G column as select values greater than 0 >> Update the Status as Defined for visible cells in Column H . >> >> I am placing sample data for around 100 line items , data may have more >> than 1lac records. >> >> Thanks, >> Rekha >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > > -- > Thanks & Regards, > Gawli Anil Narayan > Software Developer, > Abacus Software Services Pvt Ltd > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.