Hi Vabs
Set rng = Application.InputBox("Select cell/range for which you want to
update chq no.", Type:=8)
For the above function can we make following cells by default:
*C4 to C21*
*F4 to F21*
*I4 to I21*
*O4 to O15*
Because I want the result to be come in these cells only.
Regards
Pravin Gunjal
On Wed, Jan 14, 2015 at 1:39 PM, Vaibhav Joshi <v...@vabs.in> wrote:
> Pravin,
>
> Chek this...Logic for fetching data remains same..
>
> Also i have added one more functionality, just doubl click on chq. count
> to see it..
>
> Cheers!!
> ᐧ
>
> On Wed, Jan 14, 2015 at 12:20 PM, Pravin Gunjal <isk1...@gmail.com> wrote:
>
>> Dear Vabs
>>
>> Thank you for looking in to my query.
>>
>> I have checked the file given by you and it's giving the cheque details
>> in main sheet, instead I want only *no. of cheques (how many cheques are
>> not utilized) *available in main sheet.
>>
>> Also I want conditional format to be copied in other sheets too from
>> sheet "Mahavir".
>>
>> Could you please check it once again. Thank you,
>>
>> Regards
>> Pravin Gunjal
>>
>> On Sat, Jan 10, 2015 at 10:12 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>>
>>> Hi Pravin,
>>>
>>> Check this...hope you must have handled conditional formatting, i worked
>>> on part for updating chq no..
>>>
>>> Click on CHQ button select range from A4 to anything, or just single
>>> cell with customer name ..rest macro will take care..
>>>
>>> Cheers!!
>>>
>>>
>>>
>>> On Sat, Jan 10, 2015 at 3:06 PM, Vaibhav Joshi <v...@vabs.in> wrote:
>>>
>>>> is this resolved at your end or still pending?
>>>> ᐧ
>>>>
>>>> On Fri, Jan 9, 2015 at 1:14 PM, Pravin Gunjal <isk1...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hello Friends,
>>>>>
>>>>> I have an excel file with many sheets which is attached for your
>>>>> reference.
>>>>>
>>>>> In this file there is a sheet called: "Mahavir" ( you may go to this
>>>>> sheet by clicking on cell: *D18 *) in which I have set one
>>>>> conditional formatting which I wanted for all other sheets except "Main
>>>>> Sheet - Sheet No.1"
>>>>>
>>>>> Could anybody help me to do this. Thank you,
>>>>>
>>>>> *Also one more help is required in the same file. **There is columns
>>>>> heading with "CHQ" in main sheet.*
>>>>>
>>>>> *For Example please go to sheet "Ambika" here whatever "Cheque Dates"
>>>>> are blank against "Cheque No." those no. of entries I erquired in Main
>>>>> Sheet under "CHQ" filed before Ambika Agencies. So the No. will come as 1
>>>>> in main sheet in cell : "C5".*
>>>>>
>>>>> *I hope it is possible. Kindly help me out on this subject. It can
>>>>> be very very helpful for me in day to day activities. Thanks a lot in
>>>>> advance.*
>>>>>
>>>>> Regards
>>>>> Pravin Gunjal
>>>>>
>>>>> --
>>>>> 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 a topic in the
>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/excel-macros/Tn0p8fYTBVg/unsubscribe.
>>> To unsubscribe from this group and all its topics, 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 a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/Tn0p8fYTBVg/unsubscribe.
> To unsubscribe from this group and all its topics, 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.
