$$Excel-Macros$$ payback Period Formula / Macro

[sharad jain]

Hi,

I need a formula or macro for calculating payback period which is dynamic.
I mean that it can calculate the payback period for series of data without
changing the formula itself again again.

I am attaching an example sheet with 3 scenarios where we can have same
formula / macro.

Will appreciate any type of help here.

Thanks,
Sharad

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Example.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ want to show always last date in date range in chart X-Axis

[NOORAIN ANSARI]

Dear Divaker,

Can you share a sample with group for better clarity.

On Thu, Aug 9, 2012 at 7:17 PM, Divaker Pandey  wrote:

> Hi Expert,
>
> can any one help me to show last available date in chart -xaxis range.
>
>
> Divaker
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Re: Unable to increase the rows anywhere in excel file - please help

[Anoop K Sharma]

Hi Pravin,

Delete few rows from the bottom of the sheet in which you want to insert
new rows.

Regards,
Anoop

On Thu, Aug 9, 2012 at 9:37 PM, Prince Dubey  wrote:

> Hi Pravin,
>
> Please go officebutton->excel option->advanced->Display option for this
> workbook->All (option ) select this option will allow you to insert row
> without any error.
> regards
> prince
>
> On Thursday, August 9, 2012 6:26:55 PM UTC+5:30, Pravin Gunjal wrote:
>>
>>
>> *With regards,
>>
>> **Pravin Gunjal**
>> **Mobile: **83418 89718**
>> E-Mail: **isk...@gmail.com*
>>
>> *  *
>>
>>
>>
>>
>> -- Forwarded message --
>> From: Pravin Gunjal 
>> Date: Thu, Aug 9, 2012 at 12:04 PM
>> Subject: Unable to increase the rows anywhere in excel file - please help
>> To: excel-...@googlegroups.com
>>
>>
>> Dear Sir,
>>
>>
>>
>> I am unable to increase the rows in the attached file, and the system is
>> giving the following error.
>>
>>
>>
>> Error : Cannot shift objects off sheet.
>>
>>
>>
>> Kindly help me out on this issue please.  The file is attached for your
>> reference.
>>
>>
>> *With regards,
>>
>> Pravin Gunjal*
>>
>>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Regards,
Anoop

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

[Mangesh Vimay]

THank you so much Noorain. Gn

On Thu, Aug 9, 2012 at 9:14 PM, Ashish kumar wrote:

> Dear Noorain,
>
> Thanks for share this traker. really this traker is very useful.
>
>
> Thanks
> Ashish
>
>
> On 9 August 2012 08:24, NOORAIN ANSARI  wrote:
>
>> Dear Mangesh,
>>
>> see attached workbook without protection.
>>
>>
>> On Thu, Aug 9, 2012 at 8:28 PM, Mangesh Vimay wrote:
>>
>>> Dear Noorain,
>>>
>>> The attendance tracker is locked. If it is possible, can u provide
>>> password so that I can learn how  to develop such forms.
>>> Thanks.
>>>
>>>
>>>
>>> On Thu, Aug 9, 2012 at 7:55 PM, NOORAIN ANSARI >> > wrote:
>>>
 Thanks bro


 On Thu, Aug 9, 2012 at 7:40 PM, Mangesh Vimay 
 wrote:

> So Awesome Noorain Bhai !!!
>
>
> On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Ashish,
>>
>> Please find attached updated attendance tracker.
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>
>>
>> On Wed, Aug 1, 2012 at 6:04 PM, Ashish kumar <
>> kumar.ashish...@gmail.com> wrote:
>>
>>> Dear Noorain,
>>>
>>> This Attendance Tracker is very useful but whenever I'hve click on
>>> Attendance Calculator Button and fill the Emp Id. field, the status was 
>>> not
>>> generated automatically. kindly explain it. & thanks for sharing it.
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>>
>>>
>>> On 30 July 2012 20:38, NOORAIN ANSARI wrote:
>>>
 Dear Hemant,

 Please find attached Attendance Tracker, Hope it will help to you.


 On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar <
 hema5s...@gmail.com> wrote:

> Dear Ashish,
>
> How will I mark leave, I have Sick Leave, Un Planned Leave ,
> Planned Leave , Vacation?
>
> On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 <
> kumar.ashish...@gmail.com> wrote:
>
>> Dear Hemanath.D
>>
>> Pls find the attached Excel Sheet.
>>
>>
>> Thanks
>> Ashish kumar
>>
>>
>>
>> On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar
>> wrote:
>>>
>>> Friends,
>>>
>>> Can any one help me in providing Employee Attendance tracker
>>> format with Employee utilization in Excel?
>>>
>>> --
>>> Thanks
>>> Hemanath.D
>>>
>>>
>>>
>>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this
>> forum in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a
>> workbook. Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to
>> excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
>  --
> Thanks
> HemanatH
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this
> forum in signatures are prohibited.
>
> NOTE : Don't ever post per

Re: $$Excel-Macros$$ Help with Formula Destination

[Prince Dubey]

Thanks Sam , it is useful for me also.
prince

On Monday, August 6, 2012 10:08:09 PM UTC+5:30, Sam Mathai Chacko wrote:
>
> =HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)
>
> Regards
>
> Sam Mathai Chacko
>
> On Mon, Aug 6, 2012 at 9:41 PM, ashish koul 
> > wrote:
>
>> =HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3)
>>
>>
>>
>>
>> On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan 
>> 
>> > wrote:
>>
>>>  
>>> Hello
>>>
>>> I have many cells with formulae in them in Sheet "Main"
>>>
>>> For Example:
>>>
>>> ='Staff Bonus'!E67
>>>
>>> Is there a simpler way to go to the Sheet "Staff Bonus" and cell "E67" 
>>> from the "Main" sheet which contains this formulae?
>>>
>>> I think I was able to do this much earlier, but either I am mistaken or 
>>> have simply forgotten. Any help / clarification would ease my work a lot 
>>> and be highly appreciated. 
>>>
>>> Just as an additional piece of information, I use Excel 2003 (SP3)
>>>
>>>  -- 
>>> Thanks
>>>
>>> Ashish Pradhan
>>>
>>>  -- 
>>> Join official facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>  
>>> FORUM RULES (1120+ members already BANNED for violation)
>>>  
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in 
>>> signatures are prohibited. 
>>>  
>>> 6) Jobs posting is not allowed.
>>>  
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>  
>>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-...@googlegroups.com
>>> .
>>> To unsubscribe from this group, send email to 
>>> excel-macros...@googlegroups.com .
>>>  
>>>  
>>>
>>
>>
>>
>> -- 
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/*
>>
>> P Before printing, think about the environment.
>>
>>  
>>
>>  -- 
>> Join official facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES (1120+ members already BANNED for violation)
>>  
>> 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) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> 6) Jobs posting is not allowed.
>>  
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>  
>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>>  
>>  
>>
>
>
>
> -- 
> Sam Mathai Chacko
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: Unable to increase the rows anywhere in excel file - please help

[Prince Dubey]

Hi Pravin,

Please go officebutton->excel option->advanced->Display option for this 
workbook->All (option ) select this option will allow you to insert row 
without any error.
regards
prince 

On Thursday, August 9, 2012 6:26:55 PM UTC+5:30, Pravin Gunjal wrote:
>
>
> *With regards,
>
> **Pravin Gunjal**
> **Mobile: **83418 89718**
> E-Mail: **isk...@gmail.com *
>
> *  *
>
>
>
>
> -- Forwarded message --
> From: Pravin Gunjal >
> Date: Thu, Aug 9, 2012 at 12:04 PM
> Subject: Unable to increase the rows anywhere in excel file - please help
> To: excel-...@googlegroups.com 
>
>
> Dear Sir,
>
>  
>
> I am unable to increase the rows in the attached file, and the system is 
> giving the following error.
>
>  
>
> Error : Cannot shift objects off sheet.
>
>  
>
> Kindly help me out on this issue please.  The file is attached for your 
> reference.
>
>  
> *With regards,
>
> Pravin Gunjal* 
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

[Ashish kumar]

Dear Noorain,

Thanks for share this traker. really this traker is very useful.


Thanks
Ashish

On 9 August 2012 08:24, NOORAIN ANSARI  wrote:

> Dear Mangesh,
>
> see attached workbook without protection.
>
>
> On Thu, Aug 9, 2012 at 8:28 PM, Mangesh Vimay wrote:
>
>> Dear Noorain,
>>
>> The attendance tracker is locked. If it is possible, can u provide
>> password so that I can learn how  to develop such forms.
>> Thanks.
>>
>>
>>
>> On Thu, Aug 9, 2012 at 7:55 PM, NOORAIN ANSARI 
>> wrote:
>>
>>> Thanks bro
>>>
>>>
>>> On Thu, Aug 9, 2012 at 7:40 PM, Mangesh Vimay 
>>> wrote:
>>>
 So Awesome Noorain Bhai !!!


 On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Ashish,
>
> Please find attached updated attendance tracker.
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>
> On Wed, Aug 1, 2012 at 6:04 PM, Ashish kumar <
> kumar.ashish...@gmail.com> wrote:
>
>> Dear Noorain,
>>
>> This Attendance Tracker is very useful but whenever I'hve click on
>> Attendance Calculator Button and fill the Emp Id. field, the status was 
>> not
>> generated automatically. kindly explain it. & thanks for sharing it.
>>
>> Thanks
>> Ashish
>>
>>
>>
>>
>> On 30 July 2012 20:38, NOORAIN ANSARI wrote:
>>
>>> Dear Hemant,
>>>
>>> Please find attached Attendance Tracker, Hope it will help to you.
>>>
>>>
>>> On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar <
>>> hema5s...@gmail.com> wrote:
>>>
 Dear Ashish,

 How will I mark leave, I have Sick Leave, Un Planned Leave ,
 Planned Leave , Vacation?

 On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 <
 kumar.ashish...@gmail.com> wrote:

> Dear Hemanath.D
>
> Pls find the attached Excel Sheet.
>
>
> Thanks
> Ashish kumar
>
>
>
> On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar
> wrote:
>>
>> Friends,
>>
>> Can any one help me in providing Employee Attendance tracker
>> format with Employee utilization in Excel?
>>
>> --
>> Thanks
>> Hemanath.D
>>
>>
>>
>>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this
> forum in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a
> workbook. Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



  --
 Thanks
 HemanatH


  --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this
 forum in signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email 

Re: $$Excel-Macros$$ Barcode

[Manoj Kumar]

Thanks dear

Manoj
On Aug 9, 2012 8:58 PM, "NOORAIN ANSARI"  wrote:

> Dear Manoj,
>
> One easy way to create bar code in excel
>
> Please visit here
> http://strokescribe.com/en/create-barcode-excel-2007-activex.html
>
> On Thu, Aug 9, 2012 at 8:31 PM, Manoj Kumar wrote:
>
>> Dear group
>>
>> I want to make a barcode in excel. So i how make a barcode plz help me on
>> this.
>>
>> Thanks
>> Manoj
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Barcode

[NOORAIN ANSARI]

Dear Manoj,

One easy way to create bar code in excel

Please visit here
http://strokescribe.com/en/create-barcode-excel-2007-activex.html

On Thu, Aug 9, 2012 at 8:31 PM, Manoj Kumar  wrote:

> Dear group
>
> I want to make a barcode in excel. So i how make a barcode plz help me on
> this.
>
> Thanks
> Manoj
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ FW: Excel Formula challenge

[Rajan_Verma]

Noorain,

 

If you can build the Formula by Excel Native Function , would be great.

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 09 August 2012 8:30
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ FW: Excel Formula challenge

 

Dear Rajan,

 

We can use it..

 

Function NTest(rng As String)

Dim ch As String

Dim i As Integer

Dim j As Integer

With Application.WorksheetFunction

rng = .Trim(.Substitute(rng, "|", ""))

For j = 1 To Len(rng)

If VBA.Mid(rng, 1, 1) <> vbNullString Then

ch = VBA.Mid(rng, 1, 1)

rng = .Trim(.Substitute(rng, ch, ""))

NTest = .Trim(NTest & ch & "|")

Else

Exit For

End If

Next j

End With

NTest = Left(NTest, Len(NTest) - 1)

End Function

 

see the attachment.

 

-- 
With Regards,
Noorain Ansari
  http://noorainansari.com
 
  http://excelvbaclinic.com
  

On Thu, Aug 9, 2012 at 8:21 PM, Rajan_Verma 
wrote:

 

Any Reply???

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: Rajan_Verma [mailto:rajanverma1...@gmail.com] 
Sent: 08 August 2012 9:33
To: excel-macros@googlegroups.com
Subject: Excel Formula challenge 

 

 

Hi group,

 

Hope you will post an excellent solution here :

Let suppose you have a string like below :

A|A|A|B|B|C|A|B|C|D

As you can see the characters are being repeat in this string 

output should be : A|B|C|D

I don't think helper column is required J

 

 

You can comment here also

http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
 .
 
 





 

 

 

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal o

$$Excel-Macros$$ Barcode

[Manoj Kumar]

Dear group

I want to make a barcode in excel. So i how make a barcode plz help me on
this.

Thanks
Manoj

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ FW: Excel Formula challenge

[NOORAIN ANSARI]

Dear Rajan,

We can use it..

Function NTest(rng As String)
Dim ch As String
Dim i As Integer
Dim j As Integer
With Application.WorksheetFunction
rng = .Trim(.Substitute(rng, "|", ""))
For j = 1 To Len(rng)
If VBA.Mid(rng, 1, 1) <> vbNullString Then
ch = VBA.Mid(rng, 1, 1)
rng = .Trim(.Substitute(rng, ch, ""))
NTest = .Trim(NTest & ch & "|")
Else
Exit For
End If
Next j
End With
NTest = Left(NTest, Len(NTest) - 1)
End Function

see the attachment.

-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com


On Thu, Aug 9, 2012 at 8:21 PM, Rajan_Verma wrote:

> * *
>
> *Any Reply???*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* Rajan_Verma [mailto:rajanverma1...@gmail.com]
> *Sent:* 08 August 2012 9:33
> *To:* excel-macros@googlegroups.com
> *Subject:* Excel Formula challenge 
>
> ** **
>
> * *
>
> *Hi group,*
>
> * *
>
> *Hope you will post an excellent solution here :*
>
> *Let suppose you have a string like below :*
>
> *A|A|A|B|B|C|A|B|C|D*
>
> *As you can see the characters are being repeat in this string *
>
> *output should be : A|B|C|D*
>
> *I don’t think helper column is required **J*
>
> * *
>
> * *
>
> *You can comment here also*
>
> *http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Test.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

[Mangesh Vimay]

Dear Noorain,

The attendance tracker is locked. If it is possible, can u provide password
so that I can learn how  to develop such forms.
Thanks.



On Thu, Aug 9, 2012 at 7:55 PM, NOORAIN ANSARI wrote:

> Thanks bro
>
>
> On Thu, Aug 9, 2012 at 7:40 PM, Mangesh Vimay wrote:
>
>> So Awesome Noorain Bhai !!!
>>
>>
>> On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI 
>> wrote:
>>
>>> Dear Ashish,
>>>
>>> Please find attached updated attendance tracker.
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.com
>>>
>>>
>>>
>>> On Wed, Aug 1, 2012 at 6:04 PM, Ashish kumar 
>>> wrote:
>>>
 Dear Noorain,

 This Attendance Tracker is very useful but whenever I'hve click on
 Attendance Calculator Button and fill the Emp Id. field, the status was not
 generated automatically. kindly explain it. & thanks for sharing it.

 Thanks
 Ashish




 On 30 July 2012 20:38, NOORAIN ANSARI  wrote:

> Dear Hemant,
>
> Please find attached Attendance Tracker, Hope it will help to you.
>
>
> On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar <
> hema5s...@gmail.com> wrote:
>
>> Dear Ashish,
>>
>> How will I mark leave, I have Sick Leave, Un Planned Leave , Planned
>> Leave , Vacation?
>>
>> On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 <
>> kumar.ashish...@gmail.com> wrote:
>>
>>> Dear Hemanath.D
>>>
>>> Pls find the attached Excel Sheet.
>>>
>>>
>>> Thanks
>>> Ashish kumar
>>>
>>>
>>>
>>> On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar
>>> wrote:

 Friends,

 Can any one help me in providing Employee Attendance tracker format
 with Employee utilization in Excel?

 --
 Thanks
 Hemanath.D




>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum
>>> in signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>
>>
>>
>>  --
>> Thanks
>> HemanatH
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.blogspot.com 
> http://accesssqclinic.blogspot.in/
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, li

$$Excel-Macros$$ FW: Excel Formula challenge

[Rajan_Verma]

 

Any Reply???

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: Rajan_Verma [mailto:rajanverma1...@gmail.com] 
Sent: 08 August 2012 9:33
To: excel-macros@googlegroups.com
Subject: Excel Formula challenge 

 

 

Hi group,

 

Hope you will post an excellent solution here :

Let suppose you have a string like below :

A|A|A|B|B|C|A|B|C|D

As you can see the characters are being repeat in this string 

output should be : A|B|C|D

I don't think helper column is required J

 

 

You can comment here also

http://excelpoweruser.wordpress.com/2012/08/08/excel-formula-challenge/

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Fwd: Unable to increase the rows anywhere in excel file - please help

[NOORAIN ANSARI]

Dear Pravin,

In VBA Version you can also try..
Sub Test()
ActiveWorkbook.DisplayDrawingObjects = xlAll
End Sub


On Thu, Aug 9, 2012 at 6:26 PM, Pravin Gunjal  wrote:

>
> *With regards,
>
> **Pravin Gunjal**
> **Mobile: **83418 89718**
> E-Mail: **isk1...@gmail.com*
>
> *  *
>
>
>
>
> -- Forwarded message --
> From: Pravin Gunjal 
> Date: Thu, Aug 9, 2012 at 12:04 PM
> Subject: Unable to increase the rows anywhere in excel file - please help
> To: excel-macros@googlegroups.com
>
>
> Dear Sir,
>
>
>
> I am unable to increase the rows in the attached file, and the system is
> giving the following error.
>
>
>
> Error : Cannot shift objects off sheet.
>
>
>
> Kindly help me out on this issue please.  The file is attached for your
> reference.
>
>
> *With regards,
>
> Pravin Gunjal*
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

[Shekhar Sharma]

Raja,

Let me try this as well.

On Thu, Aug 9, 2012 at 9:59 AM, RAJA SEKAR  wrote:

> Hi Shekhar,
>
> you can use same formula by changing the column type to Text.
>
> excel will treat (8911.11) as negative numeric value.
>
> You just change the Column Type from General to Text and apply the same
> formula..
>
> Else
>
> try this...
>
>
> =RIGHT(A1,LEN(A1)-IF(ISERROR(FIND("(",A1,2)),LEN(A1),FIND("(",A1,2)))&B9&IF(LEN(C9)<>NOT(ISERROR(FIND(")",C9,1))),LEFT(C9,FIND(")",C9,1)-1),"")
>
> Regards
>
> RS.
>
>  On 8 August 2012 16:00, Shekhar Sharma  wrote:
>
>> )
>
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
Shekhar Sharma
9910010060
"Life consists not in holding good cards but in playing
those  you hold well"
 "Before you judge another, think of your own last mistake."

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ How to use data of one column by identifying available parentheses ) (

[Shekhar Sharma]

David,

I will share that with you shortly.

On Wed, Aug 8, 2012 at 4:45 PM, David Grugeon  wrote:

> Post a sheet with a sample of the data (at least 20 rows). then we can
> test our formulae.
>
>
> On 8 August 2012 20:35, Shekhar Sharma  wrote:
>
>> Guyz,
>>
>> Can you suggest a VBA code for the same, as I think no formula is working.
>>
>> I have lots of row and multiple of conditions
>>
>> Regards
>> Shekhar Sharma
>>
>>  On Wed, Aug 8, 2012 at 4:03 PM, Shekhar Sharma wrote:
>>
>>> Sorry David,
>>>
>>> Its not working.
>>>
>>>  On Tue, Aug 7, 2012 at 5:58 PM, David Grugeon wrote:
>>>
 =MID(A1&B1&C1,SEARCH("(",A1&B1&C1),SEARCH(")",A1&B1&C1)-SEARCH("(",A1&B1&C1)+1)



 On 7 August 2012 21:45, RAJA SEKAR  wrote:

> Try This
>
> =RIGHT(A1,LEN(A1)-FIND("(",A1,2)) & B1 & IF(LEN(C1)<>FIND(")",C1,1),
> LEFT(C1,FIND(")",C1,1)-1),"")
>
>
>
> On 7 August 2012 16:48, Shekhar Sharma  wrote:
>
>> Hi Friends
>>
>> I am struggling with one problem and need your help.
>>
>> I have three columns available like:
>>  *Column A* *Column B* *Column C* 92683 (1 18067.0 1)   (8625.11)
>>
>>
>>
>> 1)  Now I would like to have a formula in Column D where it will
>> check the destination of "(" (if exist) and merge the data coming after 
>> "("
>> (along with "("  from column A) with column B
>>
>>  Column B value should become (118067.0
>>
>> 2)  After this I need a formula in Column E where it will check the
>> destination of ")" (if exist) and merge the data coming before ")" (along
>> with ")" from Column C) with Column D value
>>
>>  Column E should become (118067.01)
>>
>>
>> Note:
>>
>> 1) If "(" is coming in Column A as (92683, formula should update
>> Column D with value as 18067.0
>> 2) if ")" is coming in Column C as 8625.11) formula should update
>> Column E with Value as 18067.0
>> 3) if any VBA code can be built that would be really great otherwise
>> I am ok with formula.
>>
>> --
>> Shekhar Sharma
>> 9910010060
>> "Life consists not in holding good cards but in playing
>> those  you hold well"
>>  "Before you judge another, think of your own last mistake."
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
>> allowed.
>>
>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> "Making a million friends is not a miracle, the miracle is to make a
> friend who will stand by you when a million are against you. "
>
>
>
> 
>
>
> Have a Smileness Day
> With A Smile
> Rs.
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not
> allowed.
>
> NOTE : Don't ever post personal or confidential data i

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

[NOORAIN ANSARI]

Thanks bro

On Thu, Aug 9, 2012 at 7:40 PM, Mangesh Vimay wrote:

> So Awesome Noorain Bhai !!!
>
>
> On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Ashish,
>>
>> Please find attached updated attendance tracker.
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.com
>>
>>
>>
>> On Wed, Aug 1, 2012 at 6:04 PM, Ashish kumar 
>> wrote:
>>
>>> Dear Noorain,
>>>
>>> This Attendance Tracker is very useful but whenever I'hve click on
>>> Attendance Calculator Button and fill the Emp Id. field, the status was not
>>> generated automatically. kindly explain it. & thanks for sharing it.
>>>
>>> Thanks
>>> Ashish
>>>
>>>
>>>
>>>
>>> On 30 July 2012 20:38, NOORAIN ANSARI  wrote:
>>>
 Dear Hemant,

 Please find attached Attendance Tracker, Hope it will help to you.


 On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar <
 hema5s...@gmail.com> wrote:

> Dear Ashish,
>
> How will I mark leave, I have Sick Leave, Un Planned Leave , Planned
> Leave , Vacation?
>
> On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 <
> kumar.ashish...@gmail.com> wrote:
>
>> Dear Hemanath.D
>>
>> Pls find the attached Excel Sheet.
>>
>>
>> Thanks
>> Ashish kumar
>>
>>
>>
>> On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar
>> wrote:
>>>
>>> Friends,
>>>
>>> Can any one help me in providing Employee Attendance tracker format
>>> with Employee utilization in Excel?
>>>
>>> --
>>> Thanks
>>> Hemanath.D
>>>
>>>
>>>
>>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 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) Cross-promotion of, or links to, forums competitive to this forum
>> in signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook.
>> Forum owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>
>
>
>  --
> Thanks
> HemanatH
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



 --
 With Regards,
 Noorain Ansari
 http:// 
 noorainansari.com
 http:// 
 excelvbaclinic.blogspot.com 
 http://accesssqclinic.blogspot.in/




  --
 FORUM RULES (986+ members already BANNED for violation)

 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.

>

Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format

[Mangesh Vimay]

So Awesome Noorain Bhai !!!


On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI wrote:

> Dear Ashish,
>
> Please find attached updated attendance tracker.
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
>
> On Wed, Aug 1, 2012 at 6:04 PM, Ashish kumar wrote:
>
>> Dear Noorain,
>>
>> This Attendance Tracker is very useful but whenever I'hve click on
>> Attendance Calculator Button and fill the Emp Id. field, the status was not
>> generated automatically. kindly explain it. & thanks for sharing it.
>>
>> Thanks
>> Ashish
>>
>>
>>
>>
>> On 30 July 2012 20:38, NOORAIN ANSARI  wrote:
>>
>>> Dear Hemant,
>>>
>>> Please find attached Attendance Tracker, Hope it will help to you.
>>>
>>>
>>> On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar <
>>> hema5s...@gmail.com> wrote:
>>>
 Dear Ashish,

 How will I mark leave, I have Sick Leave, Un Planned Leave , Planned
 Leave , Vacation?

 On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 <
 kumar.ashish...@gmail.com> wrote:

> Dear Hemanath.D
>
> Pls find the attached Excel Sheet.
>
>
> Thanks
> Ashish kumar
>
>
>
> On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar wrote:
>>
>> Friends,
>>
>> Can any one help me in providing Employee Attendance tracker format
>> with Employee utilization in Excel?
>>
>> --
>> Thanks
>> Hemanath.D
>>
>>
>>
>>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



  --
 Thanks
 HemanatH


  --
 FORUM RULES (986+ members already BANNED for violation)

 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) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com



>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.blogspot.com 
>>> http://accesssqclinic.blogspot.in/
>>>
>>>
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 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) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>

Re: $$Excel-Macros$$ last date in the series does not appear on the chart

[dguillett1]

Send me this msg and your file 

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Divaker Pandey 
Sent: Thursday, August 09, 2012 8:51 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ last date in the series does not appear on the chart


Hi Experts,

I have a time series line chart with dates on the x-axis. The dates run in 
ascending order , left to right. The last date in the series does not appear on 
the chart.

After numerous attempts with different scenarios using the various functions 
under the "Scale" tab in the "Formatting Axis" dialoge box, I have been unable 
to
display the last value in this series on the chart.

Is there a method for doing this? Thank you in advance for taking time to 
respond.

Divaker
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ last date in the series does not appear on the chart

[Divaker Pandey]

Hi Experts,

I have a time series line chart with dates on the x-axis. The dates run in
ascending order , left to right. The last date in the series does not
appear on the chart.

After numerous attempts with different scenarios using the various
functions under the "Scale" tab in the "Formatting Axis" dialoge box, I
have been unable to
display the last value in this series on the chart.

Is there a method for doing this? Thank you in advance for taking time to
respond.

Divaker

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ want to show always last date in date range in chart X-Axis

[Divaker Pandey]

Hi Expert,

can any one help me to show last available date in chart -xaxis range.


Divaker

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Help with Formula Destination

[Ashish Pradhan]

Dear Kantilal, Sam & Ashish

All your options work and are helpful. Appreciate your help and thanks a 
lot (Couldn't respond earlier as I was away)


Thanks

Ashish Pradhan

On 07-08-2012 10:56, Kantilal Badale wrote:

Try CTRL+[ ] from formula cell
CA Kantilal Badale
E-Hall, First Floor,
B. J. Market,
Jalgaon.(Maharashtra)
9822250393


On Mon, Aug 6, 2012 at 10:08 PM, Sam Mathai Chacko > wrote:


=HYPERLINK("#"&CELL("address",Sheet3!A1),Sheet3!A1)

Regards

Sam Mathai Chacko


On Mon, Aug 6, 2012 at 9:41 PM, ashish koul mailto:koul.ash...@gmail.com>> wrote:


=HYPERLINK("#'"&SUBSTITUTE(CELL("address",Sheet2!A3),"!","'!"),Sheet2!A3)





On Mon, Aug 6, 2012 at 7:09 PM, Ashish Pradhan
mailto:ashlyprad...@gmail.com>> wrote:


Hello

I have many cells with formulae in them in Sheet "Main"

For Example:

='Staff Bonus'!E67

Is there a simpler way to go to the Sheet "Staff Bonus"
and cell "E67" from the "Main" sheet which contains this
formulae?

I think I was able to do this much earlier, but either I
am mistaken or have simply forgotten. Any help /
clarification would ease my work a lot and be highly
appreciated.

Just as an additional piece of information, I use Excel
2003 (SP3)

-- 
Thanks


Ashish Pradhan

-- 
Join official facebook page of this forum @

https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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) Cross-promotion of, or links to, forums competitive to
this forum in signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links
is not allowed.

NOTE : Don't ever post personal or 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 post to this group, send email to
excel-macros@googlegroups.com
.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
.





-- 
*Regards*

**
*Ashish Koul*


*/Visit/*
*/_http://www.excelvbamacros.com/_/*
*/_http://www.accessvbamacros.com/_/*

PBefore printing, think about the environment.


-- 
Join official facebook page of this forum @

https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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) Cross-promotion of, or links to, forums competitive to this
forum in signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is
not allowed.

NOTE : Don't ever post personal or 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 post to this group, send email to
excel-macros@googlegroups.com
.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com
.





-- 
Sam Mathai Chacko


-- 
Join official facebook page of this forum @

https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

1) Use concise, accurate th

$$Excel-Macros$$ Fwd: Unable to increase the rows anywhere in excel file - please help

[Pravin Gunjal]

*With regards,

**Pravin Gunjal**
**Mobile: **83418 89718**
E-Mail: **isk1...@gmail.com*

*  *




-- Forwarded message --
From: Pravin Gunjal 
Date: Thu, Aug 9, 2012 at 12:04 PM
Subject: Unable to increase the rows anywhere in excel file - please help
To: excel-macros@googlegroups.com


Dear Sir,



I am unable to increase the rows in the attached file, and the system is
giving the following error.



Error : Cannot shift objects off sheet.



Kindly help me out on this issue please.  The file is attached for your
reference.


*With regards,

Pravin Gunjal*

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Test working.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Shor cut required to break the internal link within the same work book

[dguillett1]

How does that save time??
sub ddd
activesheet.usedrange.value=activesheet.usedrange.value
end sub


Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Jayaprakash S

Sent: Thursday, August 09, 2012 7:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Shor cut required to break the internal link 
within the same work book


Dear Don,

Thanks for spending your valueable time for my query

Currently doing it manually thrugh Paste special & values .. but
wanted to check whether i can get any simpler way like below :

eg : if you move the "Master sheet" to new work book from the working
file and come back to the working file and click on Data + Edit Links
+ Break Link which will be  done easily and also saves time..

Have a great day!!

JP.

On Thu, Aug 9, 2012 at 5:43 PM, dguillett1  wrote:

Am I missing something?
select your data>edit/copy>edit/paste special>values



Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- From: Jayaprakash S
Sent: Thursday, August 09, 2012 1:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Shor cut required to break the internal link
within the same work book


Dear Experts...

Good Noon..

Need your help per attached example.

Thanks in advance.

JP.

--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.


--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.






--
Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
desirable habit for success - Swamy Vivekananda. This message is for
the designated recipient only and may contain privileged, proprietary,
or otherwise private information. If you have received it in error,
please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.

--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 Goog

Re: $$Excel-Macros$$ Shor cut required to break the internal link within the same work book

[Jayaprakash S]

Dear Don,

Thanks for spending your valueable time for my query

Currently doing it manually thrugh Paste special & values .. but
wanted to check whether i can get any simpler way like below :

eg : if you move the "Master sheet" to new work book from the working
file and come back to the working file and click on Data + Edit Links
+ Break Link which will be  done easily and also saves time..

Have a great day!!

JP.

On Thu, Aug 9, 2012 at 5:43 PM, dguillett1  wrote:
> Am I missing something?
> select your data>edit/copy>edit/paste special>values
>
>
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Jayaprakash S
> Sent: Thursday, August 09, 2012 1:47 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Shor cut required to break the internal link
> within the same work book
>
>
> Dear Experts...
>
> Good Noon..
>
> Need your help per attached example.
>
> Thanks in advance.
>
> JP.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>



-- 
Regards, Jayaprakash. S (JAYAPRAKASH. S.) Adaptability is the most
desirable habit for success - Swamy Vivekananda. This message is for
the designated recipient only and may contain privileged, proprietary,
or otherwise private information. If you have received it in error,
please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Short cut for Making it as Range Value within the same work book.xlsx

Re: $$Excel-Macros$$ Shor cut required to break the internal link within the same work book

[dguillett1]

Am I missing something?
select your data>edit/copy>edit/paste special>values



Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Jayaprakash S

Sent: Thursday, August 09, 2012 1:47 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Shor cut required to break the internal link 
within the same work book


Dear Experts...

Good Noon..

Need your help per attached example.

Thanks in advance.

JP.

--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel


FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.



--
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Re: Make Bold the relevant data.....

[NOORAIN ANSARI]

Dear Muneer,

Please try it,


Option Explicit
Sub make_bold()
Dim sh As Worksheet
Dim rng As Range
Dim cell As Range
Set sh = ThisWorkbook.Sheets(1)
Set rng = sh.Range("A3:A" & sh.Cells(Rows.Count, "A").End(xlUp).Row)
For Each cell In rng
If cell.Value = sh.Cells(1, 1).Value Then
cell.Font.Bold = True
End If
Next cell
End Sub

and see attached sheet.

On Wed, Aug 8, 2012 at 11:07 PM, Prince Dubey wrote:

> hi muneer,
>
> please see the attachment.
>
> prince
>
> On Wednesday, August 8, 2012 5:34:03 PM UTC+5:30, Mohammed Muneer wrote:
>>
>> Dear Group,
>>
>>
>>
>>   Make bold the data relevant in the below rows that follows the yellow
>> highlighted in cell A1.
>>
>>
>>
>>
>>
>>
>>
>>   Regards,
>>
>>   Muneer,
>>
>>   CC….
>>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Make Bold the relevant Solved Quaryxlsm
Description: Binary data

Re: $$Excel-Macros$$ formula base on condition

[pawel lupinski]

Don/Prince,
 
Thanks a lot
 
pawel



From: dguillett1 
To: excel-macros@googlegroups.com 
Sent: Wednesday, August 8, 2012 8:15 PM
Subject: Re: $$Excel-Macros$$ formula base on condition


=IF(AND(LEN(D3)<>LEN(M3),RIGHT(D3,8)=RIGHT(M3,8)),L3,"")

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: pawel lupinski 
Sent: Wednesday, August 08, 2012 12:45 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ formula base on condition
Hi All,

I'm looking for formula that will be checking cell base on the condition that 
last 8 digits will be match, with 8 digits from different cell. Pls see 
attachement.

Regards,

Pawel-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
 
 
-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES (1120+ members already BANNED for violation)
 
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) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
6) Jobs posting is not allowed.
 
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
 
NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Fwd: $$Excel-Macros$$ time counting macro........

[Dhananjay Pinjan]

Thanks Ashish.

-- Forwarded message --
From: ashish koul 
Date: Mon, 6 Aug 2012 20:07:56 +0530
Subject: Re: $$Excel-Macros$$ time counting macro
To: excel-macros@googlegroups.com

see if it helps


On Wed, Aug 1, 2012 at 6:39 PM, Dhananjay Pinjan  wrote:

> Dear Experts,
>
>  I need a macro which START counting from "ZERO" in
> "hh:mm:ss: format. When I stop the STOP Macro Button, The counting
> also should have to stop.
>
> Ex - If I Start Macro, The cell should have to start counting
> '00:00:00' & if I press 'STOP' Button after 5 Min. & 45 Sec.' the cell
> figure should have to stop on "00:05:45".
> If again I click on START button, again cell should have start
> counting from '00:00:00'.
>
> Is it possible?
>
> Regards,
> Dhananjay
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum
in signatures are prohibited.

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




sample.xlsm
Description: Binary data