Vaibhav Bhai,
Superb solutions according to the requirement.
Regards
Ashish
On 4 September 2014 15:57, Vaibhav Joshi <v...@vabs.in> wrote:
> cheers!!
>
>
> On Thu, Sep 4, 2014 at 3:43 PM, Sunil Kumar Yadav <sk.yadav7...@gmail.com>
> wrote:
>
>> yeah :-), it is absolutely working as per my requirement.
>>
>> Thank you so much! :-)
>>
>>
>> *Thanks & Regards, Sunil Kumar Yadav*
>>
>>
>> On Thu, Sep 4, 2014 at 3:13 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>>
>>> Ok, i goofed up in last stat..
>>>
>>> Check this now..
>>>
>>>
>>> On Thu, Sep 4, 2014 at 1:51 PM, Sunil Kumar Yadav <
>>> sk.yadav7...@gmail.com> wrote:
>>>
>>>> yes but first filter 5 against filter GPRS by "contains"(all type
>>>> GPRS), if GPRS not found then sub procedure close or find it then fill
>>>> Correct.
>>>>
>>>> but my create procedure when GPRS not found then fill correct against
>>>> all number like 6,7,8,9,12 etc. that is wrong.
>>>>
>>>>
>>>> *Thanks & Regards,Sunil Kumar Yadav*
>>>>
>>>>
>>>> On Thu, Sep 4, 2014 at 1:27 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>>>>
>>>>> It means if you find GPRS & 5 then only you want to paste "Correct" am
>>>>> i right?
>>>>>
>>>>>
>>>>> On Wed, Sep 3, 2014 at 6:51 PM, Sunil Kumar Yadav <
>>>>> sk.yadav7...@gmail.com> wrote:
>>>>>
>>>>>> Sorry sir, but i think u r not understand what i want, may be in this
>>>>>> my mistake...i tell you again....!
>>>>>>
>>>>>>
>>>>>> please find the enclosed file...1)correct 2)Incorrect and
>>>>>> 3)your coding file.
>>>>>> i have mentioned coding in both file in module....pls run and check
>>>>>> status column of both file.
>>>>>>
>>>>>> In incorrect file, when filter not found GPRS against 5 then filled
>>>>>> correct in all row...that is wrong
>>>>>> in correct file, when filter found GPRS against 5 then skip other
>>>>>> rows(2,3,10,9 etc) means blank...that is right.
>>>>>>
>>>>>> now i want when filter not found GPRS against 5 then do the skip
>>>>>> other rows(2,3,10,9 etc) means blank.
>>>>>>
>>>>>>
>>>>>>
>>>>>> *Thanks & Regards,Sunil Kumar Yadav*
>>>>>>
>>>>>>
>>>>>> On Wed, Sep 3, 2014 at 3:56 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>>>>>>
>>>>>>> Hi
>>>>>>>
>>>>>>> Check this module 2.
>>>>>>>
>>>>>>> Cheers!!
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Sep 3, 2014 at 2:15 PM, Sunil Kumar Yadav <
>>>>>>> sk.yadav7...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Actually i want first step auto filter, do the filter Column H (in
>>>>>>>> this filter 3,4 and update the correct in column I) then again filter
>>>>>>>> column D (in this filter GPRS all type) and in same time second filter
>>>>>>>> column H (in this filter 5) Now update correct in status column.
>>>>>>>>
>>>>>>>> my question is when filter GPRS in column D after that software not
>>>>>>>> found 5 in Column H then macro fill correct in all number against like
>>>>>>>> 2,6,7,8...i want to 2,6,7,8 etc not fill it, if 5 not found than macro
>>>>>>>> running stop it.
>>>>>>>>
>>>>>>>>
>>>>>>>> *Thanks & Regards,Sunil Kumar Yadav*
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Sep 2, 2014 at 8:22 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>>>>>>>>
>>>>>>>>> share sample book & explain step by step what you want to do..
>>>>>>>>>
>>>>>>>>> Cheers!!
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Tue, Sep 2, 2014 at 6:48 PM, Sunil Kumar Yadav <
>>>>>>>>> sk.yadav7...@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Hi Friends,
>>>>>>>>>>
>>>>>>>>>> Please guide me on my second query
>>>>>>>>>>
>>>>>>>>>> I have recorded macro on auto filter and modified the 2
>>>>>>>>>> conditions but when "GPRS" not found against "5", in this situation
>>>>>>>>>> filter
>>>>>>>>>> fills "correct" in all row of status column, i want to set such
>>>>>>>>>> condition
>>>>>>>>>> when "GPRS" not found against "5" then process work on next step/or
>>>>>>>>>> close
>>>>>>>>>> without fill correct in all row.
>>>>>>>>>>
>>>>>>>>>> in sample word how can set 3 or 4 conditions on different columns
>>>>>>>>>> in auto filter.
>>>>>>>>>>
>>>>>>>>>> Look Table formate:
>>>>>>>>>>
>>>>>>>>>> Len Calltype Status(autofile)
>>>>>>>>>> 3 GPRS Incorrect
>>>>>>>>>> 4 Roaming Correct
>>>>>>>>>> 5 Local GPRS Correct
>>>>>>>>>> 9 Cross Incorrect
>>>>>>>>>> etc
>>>>>>>>>>
>>>>>>>>>> ActiveSheet.Range("$A$1:$AC$1020000").AutoFilter Field:=13,
>>>>>>>>>> Criteria1:=Array( _
>>>>>>>>>> "4", "3"), Operator:=xlFilterValues
>>>>>>>>>>
>>>>>>>>>> Range("N1:N1020000").Cells.SpecialCells(xlCellTypeBlanks).Select
>>>>>>>>>>
>>>>>>>>>> Range("N1:N1020000").Cells.SpecialCells(xlCellTypeBlanks).Value =
>>>>>>>>>> "Correct"
>>>>>>>>>> Selection.AutoFilter
>>>>>>>>>> Range("I1").Select
>>>>>>>>>> Selection.AutoFilter
>>>>>>>>>> ActiveSheet.Range("$A$1:$AC$1020000").AutoFilter Field:=9,
>>>>>>>>>> Criteria1:="=*GPRS*", Operator:=xlAnd
>>>>>>>>>> Range("M1").Select
>>>>>>>>>> ActiveSheet.Range("$A$1:$AC$1020000").AutoFilter Field:=13,
>>>>>>>>>> Criteria1:="5", Operator:=xlFilterValues
>>>>>>>>>>
>>>>>>>>>> Range("N1:N1020000").Cells.SpecialCells(xlCellTypeBlanks).Select
>>>>>>>>>>
>>>>>>>>>> Range("N1:N1020000").Cells.SpecialCells(xlCellTypeBlanks).Value =
>>>>>>>>>> "Correct"
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> *Thanks & Regards, Sunil Kumar Yadav*
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> 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/d/optout.
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> 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/d/optout.
>>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> 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/d/optout.
>>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> 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/d/optout.
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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/d/optout.
>>>>>>
>>>>>
>>>>> --
>>>>> 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/d/optout.
>>>>>
>>>>
>>>> --
>>>> 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/d/optout.
>>>>
>>>
>>> --
>>> 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/d/optout.
>>>
>>
>> --
>> 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/d/optout.
>>
>
> --
> 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/d/optout.
>
--
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/d/optout.
