Re: $$Excel-Macros$$ Autofilter criteria

2013-07-06 Thread rekha siri
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(

Re: $$Excel-Macros$$ Autofilter criteria

2013-06-27 Thread अनिल नारायण गवली
Dear Rekha, Pl see the attached workbook. Warm Regards, Gawli Anil On Fri, Jun 28, 2013 at 10:36 AM, rekha siri 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) F

$$Excel-Macros$$ Autofilter criteria

2013-06-27 Thread rekha siri
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