Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[Kuldeep Singh]

Hi Lakshman G,

You're right. But Mr. Ashish says, Require output value 4625000, So I
solved query for required output.

Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Tue, Aug 7, 2012 at 11:53 AM, LAKSHMAN PRASAD wrote:

> C the attached file. ? u r missing.
>
>
>   --
> *From:* Kuldeep Singh 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, August 6, 2012 12:44 PM
> *Subject:* Re: $$Excel-Macros$$ Sumproduct function to get sum between
> two date
>
>
> Dear Lakshman,
>
> Require output value 4625000 your formula is not working.
>
> It's working fine. =SUMPRODUCT((A7:A24>=E1)*(A7:A24<=F1)*(F7:F24))
>
> Regards,
> Kuldeep Singh
> Phone.: +91-120-4763789, Extn.: 789
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mail unless
> you really need to.*
>
> On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD 
> wrote:
>
> You are missing
>
>
> SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> *Lakshman Prasad*
> Manager (Finance)
> GAURSONS INDIA LIMITED
> Ph: +91 12 456777 Mob. No. 9582279261
> Website: http://www.gaursonsindia.com/
>
>   --
> *From:* Ashish Bhalara 
> *To:* excel-macros@googlegroups.com
> *Sent:* Saturday, August 4, 2012 4:02 PM
>
> *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
> date
>
> Dear experts,
>
> I need output of sum between two date by using of Sumproduct as below
> formula but the error is occur in fuction, please see attache sheet.
>
>  =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>  --
> 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
>
>
>
>
>   --
> 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 

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[LAKSHMAN PRASAD]

C the attached file. ? u r missing.




 From: Kuldeep Singh 
To: excel-macros@googlegroups.com 
Sent: Monday, August 6, 2012 12:44 PM
Subject: Re: $$Excel-Macros$$ Sumproduct function to get sum between two date
 


Dear Lakshman,

Require output value 4625000 your formula is not working.

It's working fine. =SUMPRODUCT((A7:A24>=E1)*(A7:A24<=F1)*(F7:F24))

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
PleaseConsider the environment. Please don't print this e-mail unless you 
really need to.


On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD  wrote:

You are missing 
>
>
>
>
>SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> 
>Lakshman Prasad
>Manager (Finance)
>GAURSONS INDIA LIMITED 
>Ph: +91 12 456777 Mob. No. 9582279261
>Website: http://www.gaursonsindia.com/
>
>
>
>
> From: Ashish Bhalara 
>To: excel-macros@googlegroups.com 
>Sent: Saturday, August 4, 2012 4:02 PM
>
>Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date
> 
>
>
>Dear experts,
>
>
>I need output of sum between two date by using of Sumproduct as below formula 
>but the error is occur in fuction, please see attache sheet.
>
>
> =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> 
>Thanks & regards.
>
>
>Ashish Bhalara
>9624111822
>PPlease do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣
>
>
>
-- 
>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
> 
> 
>
>
>
-- 
>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, 
U

Re: $$Excel-Macros$$ Help for formula (which formula give me exact numbers when I change month)

[amar takale]

First Thanks very much Kantilal Sir,But I would like to which I desired
output in sheet (Yellow color) Is it possible?

On Mon, Aug 6, 2012 at 11:01 AM, Kantilal Badale
wrote:

> Hi,
>
> See if attached sheet is useful.
>
> U can Change month in value field to get the desired result
>
> Regards
>
> CA Kantilal K Badale
> Chartered Accountant
> "E" Hall, First Floor,
> B. J. Market,
> Jalgaon (Maharashtra)
> 9822250393
>
>
>
>
>
>
> On Mon, Aug 6, 2012 at 10:33 AM, amar takale  wrote:
>
>> I will try this but output is not give properly exact numbers.I will send
>> again file with your index formula Pls see it
>>
>>
>> On Sat, Aug 4, 2012 at 2:36 PM, vijayajith VA wrote:
>>
>>> Hi ,,
>>>
>>> Use Ctrl Shift enter for  Priti_Verma  s formula...
>>>
>>> Thanks
>>>
>>>
>>> On Sat, Aug 4, 2012 at 1:17 PM, amar takale wrote:
>>>
 Pls help me all experts.I attached file.

 --
 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



>>>
>>>  --
>>> 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
>>>
>>>
>>>
>>
>> --
>> 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/th

Re: $$Excel-Macros$$ Marquee text in Powerpoint

[Rajasekhar Praharaju]

Ashish, any idea in this regards as already you have created in excel.

Thanks for your help in advance!!

On Sat, Aug 4, 2012 at 3:46 AM, David Grugeon  wrote:

> You might do better asking PowerPoint questions on a Powerpoint forum.  As
> its name indicates this forum is about Excel Macros.
>
>
> On 4 August 2012 02:24, rekha siri  wrote:
>
>> Hi Experts,
>>
>> Please assist in this concern i deal with xlius earlier now we are using
>> only power point dashboard presentation.
>>
>> is there any possibility to place the scrolling marquee kind of text as
>> Headings of power point slides.
>>
>> which needs to be scrolling continously.
>>
>>
>> Thanks,
>> Rekha
>>
>> --
>> 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
>>
>>
>>
>
>
>
> --
> Regards
> David Grugeon
>
>  --
> 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 & Regards,
Rajasekhar.P

Subscribe to our group and receive daily updates.
Excel groups

https://sites.google.com/site/excelencyclopedia/how-to-join/assignments

Send your queries and Suggestions @
excel-gro...@googglegroups.com

Excelforum Blogspot

http://feedburner.google.com/fb/a/mailverify?uri=ExcelForum&loc=en_US">Subscribe
to excel forum by Email

-- 
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

[Kantilal Badale]

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  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-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.
>>
>>
>>
>
>
>
> --
> 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.
>
>
>

-- 

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[Kuldeep Singh]

Dear Lakshman,

Require output value 4625000 your formula is not working.

It's working fine. =SUMPRODUCT((A7:A24>=E1)*(A7:A24<=F1)*(F7:F24))

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD wrote:

> You are missing
>
>
> SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> *Lakshman Prasad*
> Manager (Finance)
> GAURSONS INDIA LIMITED
> Ph: +91 12 456777 Mob. No. 9582279261
> Website: http://www.gaursonsindia.com/
>
>   --
> *From:* Ashish Bhalara 
> *To:* excel-macros@googlegroups.com
> *Sent:* Saturday, August 4, 2012 4:02 PM
>
> *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
> date
>
> Dear experts,
>
> I need output of sum between two date by using of Sumproduct as below
> formula but the error is occur in fuction, please see attache sheet.
>
>  =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>  --
> 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
>
>
>
>
>   --
> 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$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

[pesh]

This works great! Thank you!

On Sunday, August 5, 2012 9:09:06 AM UTC-4, Don Guillett wrote:
>
>   Or
>  
> Sub SplitStringSAS()
> Dim VarArr
> With Selection
>   VarArr = Split(.Value, "|")
> .Resize(1, UBound(VarArr)).Value = VarArr
> End With
> End Sub
>  
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>   
>  *From:* Rajan_Verma  
> *Sent:* Sunday, August 05, 2012 12:48 AM
> *To:* excel-macros@googlegroups.com 
> *Subject:* RE: $$Excel-Macros$$ Excel VBA Question: Splitting a String 
> based on a Parameter and outputting it into cells
>  
>  
> *Hi*
>
> *Use this :*
>
> ** 
>
> *Sub SplitString()*
>
> ** 
>
> *Dim StrString As String*
>
> *Dim VarArr*
>
> *StrString = "| ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|"*
>
> *StrString = Mid(StrString, 2, Len(StrString) - 2)*
>
> *VarArr = Split(StrString, "|")*
>
> *Range("A1").Resize(1, UBound(VarArr)).Value = VarArr*
>
> **
>
> *End Sub*
>
> ** 
>
> ** 
>
> ** 
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** 
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Alpesh Shah
> *Sent:* 05 August 2012 6:13
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Excel VBA Question: Splitting a String based 
> on a Parameter and outputting it into cells
>
>  
>
> Dear Excel Experts,
>
> I am working with a string as follows:
>
> " | ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|"
>
> There are a total of 8 pipes | .
>
> My issue is that I am trying to Split this based on the pipes, and output 
> the words in between into cells.
>
> I have been trying to solve this for a long time with VBA, but I cannot 
> seem to get it to succeed.
>
> Please help.
>
> Thank you.
> Alpesh
>
> -- 
> 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
>  
>  
> -- 
> 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
>  
>  
>

-- 
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

[Sam Mathai Chacko]

=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-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.
>
>
>



-- 
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.

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

[ashish koul]

=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-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.

Re: $$Excel-Macros$$ need help to send excel userform data to send email body...

[ashish koul]

share the form and message

On Mon, Aug 6, 2012 at 1:27 PM, Dhartikumar Sahu wrote:

> hi expert guru's
>
> I want to send mail my userform data to my group mail id. how to write ma
> code to send my userform data.
>
> awaiting for your prompt reply.
> --
>
> *Regards,*
>
> *Dhartikumar Sahu*
>
> Sr.Database Manager - Institutional Equities
>
> * **IDBI Capital Markets Services Ltd*
>
> 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21
>
> Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450
>
>  --
> 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.

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

[ashish koul]

see if it helps


On Mon, Aug 6, 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.




sample.xlsm
Description: Binary data

RE: $$Excel-Macros$$ Data Entry Form

[Rajan_Verma]

 

Advance Option ->Customize -> All Command -> Form

 

Once you add form in any ToolBar, just select the heading and Click on that 
Form ICON , a user entry form will appear , you can enter the data ,

 

This form will consider Validation as well.

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of trawets
Sent: 06 August 2012 1:05
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Data Entry Form

 

Hi  bé trần văn 

 

Again thanks for your efforts in helping with this, I am struggling to 
incorporate this into my workbook, I have some 200 records already and 
expecting in the region of 3000 more, I have attached my file could you advise 
how I would include your code.

 

hope you don't mind me asking this

 

best regards

On Sunday, August 5, 2012 6:04:13 PM UTC+1, trawets wrote:

Thank you for your excellent response, I am currently trying to eveluate but it 
looks as though it does the job, will be back with more comments later.

Again thanks for you time and assistance with this

On Sunday, August 5, 2012 5:05:00 PM UTC+1, bé trần văn wrote:

Do not know the request of you?

2012/8/5 trawets 



Hi Guys 

Could someone help with my problem, I have a simple defect recording 
spreadsheet, I would like to create a data entry form which I can do using the 
excel form command, however I would like to expand the functionality by having 
the number being displayed and being auto-number. some other fields I would 
like them to be list selection and dates (a calendar block would be nice). I 
know all this can be quite easily done using access but I'm not allowed to use 
this due to licencing restrictions 
below is a full list of the fields in the sheet  

 

any pointers would be appreciated

DEFECT NUMBER _ Auto-number 
COMPARMENT 
DEFECT 
DEFECT CODE /TRADE 
PRIORITY _ List 
DATE RAISED 
Week No 
RAISED BY_ List 
STATUS _ List 
DATE CLEARED 
CLEARED BY   _ List  

-- 
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 th

$$Excel-Macros$$ Help with Formula Destination

[Ashish Pradhan]

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.

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

[Dhananjay Pinjan]

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.

Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

[Ashish Bhalara]

Thanks to all, I make very silly mistake.

On Mon, Aug 6, 2012 at 12:29 PM, LAKSHMAN PRASAD wrote:

> You are missing
>
>
> SUMPRODUCT((A7:A23>E1)*(A7:A23
>
> *Lakshman Prasad*
> Manager (Finance)
> GAURSONS INDIA LIMITED
> Ph: +91 12 456777 Mob. No. 9582279261
> Website: http://www.gaursonsindia.com/
>
>   --
> *From:* Ashish Bhalara 
> *To:* excel-macros@googlegroups.com
> *Sent:* Saturday, August 4, 2012 4:02 PM
>
> *Subject:* $$Excel-Macros$$ Sumproduct function to get sum between two
> date
>
> Dear experts,
>
> I need output of sum between two date by using of Sumproduct as below
> formula but the error is occur in fuction, please see attache sheet.
>
>  =SUMPRODUCT(A7:A23>E1)*(A7:A23
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624111822
> P*Please do not print this email unless it is absolutely necessary.
> Spread environmental üawareness.♣♣♣*
>
>
>  --
> 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
>
>
>
>
>   --
> 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.
>
>
>



-- 
Thanks & regards.

Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*

-- 
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$$ Need help in mandays

[Ahmed Honest]

Dear Deepak,

Looking at your sample data one of your Outlet name : Janata Stores(S)
starting from 9 to 15-Jul status is available only for 14 and 15-July as
Off and Working,

*what shall be considered as status for rest of the days i.e from 9 to
13-July ??*

**
* *
*

*

On Mon, Aug 6, 2012 at 2:58 PM, Deepak Rawat wrote:

> Hi,
>
> I have a data where i have to calculate mandays, i hv attached a sample
> data in which a field is Working/OFF
>
> What i need
> 1. I have to calculate mandays working day + one off or weekday.
> 2. i have to make a date wise pivot table in wich i want, 1 where working
> , off where off, WOFF where Weekly off sample of report is here as under:
>
>   OUTLET NAME 23-Jun 24-Jun 25-Jun 26-Jun 27-Jun 28-Jun 29-Jun 30-Jun
> 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul  Days SAT SUN MON TUE WED
> THU FRI SAT SUN MON TUE WED THU FRI SAT SUN  Vodafone (Dwarka) 1 1 1 OF 1
> 1 1 1 1 1 1 1 1 1 1 1  Vodafone (Vasant Vihar) 1 1 1 1 1 1 1 1 1 1 W.OFF 1
> 1 1 1 1  Vodafone (South Ext) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1  Vodafone
> (Lajpat Nagar) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1  Vodafone (C P) 1 W.OFF 1 1
> 1 1 1 1 W.OFF 1 1 1 1 1 1 W.OFF
> I am trying on pivot but its showing only count & not the value.
>
> Database is huge more than 2 Lac so i need some technique which wl work
> shortly & in precise way.
>
> Regards,
> Deepak
>
>
> --
> 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.
>
>
>



-- 
Ahmed Bawazir
*احمد باوزير*

-- 
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$$ Noorain Ansari - Most Helpful Member July 2012

[Venkat CV]

Congrats Noorain.

-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*


On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain  wrote:

> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel expertise.
>
> I truly appreciate his consistency and commitment to the group. He is
> really doing great job.
>
> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
> Sunita and other folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> Regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> 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
>
>
>



*
*
*
*

-- 
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$$ Need help in mandays

[Kuldeep Singh]

Hi Deepak,

Please See attachment.

Regards,
Kuldeep Singh
Phone.: +91-120-4763789, Extn.: 789
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*

On Mon, Aug 6, 2012 at 5:28 PM, Deepak Rawat wrote:

> Hi,
>
> I have a data where i have to calculate mandays, i hv attached a sample
> data in which a field is Working/OFF
>
> What i need
> 1. I have to calculate mandays working day + one off or weekday.
> 2. i have to make a date wise pivot table in wich i want, 1 where working
> , off where off, WOFF where Weekly off sample of report is here as under:
>
>   OUTLET NAME 23-Jun 24-Jun 25-Jun 26-Jun 27-Jun 28-Jun 29-Jun 30-Jun
> 1-Jul 2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul  Days SAT SUN MON TUE WED
> THU FRI SAT SUN MON TUE WED THU FRI SAT SUN  Vodafone (Dwarka) 1 1 1 OF 1
> 1 1 1 1 1 1 1 1 1 1 1  Vodafone (Vasant Vihar) 1 1 1 1 1 1 1 1 1 1 W.OFF 1
> 1 1 1 1  Vodafone (South Ext) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1  Vodafone
> (Lajpat Nagar) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1  Vodafone (C P) 1 W.OFF 1 1
> 1 1 1 1 W.OFF 1 1 1 1 1 1 W.OFF
> I am trying on pivot but its showing only count & not the value.
>
> Database is huge more than 2 Lac so i need some technique which wl work
> shortly & in precise way.
>
> Regards,
> Deepak
>
>
> --
> 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 Data Query Solved.xlsb
Description: Binary data

$$Excel-Macros$$ Need help in mandays

[Deepak Rawat]

Hi,

I have a data where i have to calculate mandays, i hv attached a sample
data in which a field is Working/OFF

What i need
1. I have to calculate mandays working day + one off or weekday.
2. i have to make a date wise pivot table in wich i want, 1 where working ,
off where off, WOFF where Weekly off sample of report is here as under:

  OUTLET NAME 23-Jun 24-Jun 25-Jun 26-Jun 27-Jun 28-Jun 29-Jun 30-Jun 1-Jul
2-Jul 3-Jul 4-Jul 5-Jul 6-Jul 7-Jul 8-Jul  Days SAT SUN MON TUE WED THU FRI
SAT SUN MON TUE WED THU FRI SAT SUN  Vodafone (Dwarka) 1 1 1 OF 1 1 1 1 1 1
1 1 1 1 1 1  Vodafone (Vasant Vihar) 1 1 1 1 1 1 1 1 1 1 W.OFF 1 1 1 1
1  Vodafone
(South Ext) 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1  Vodafone (Lajpat Nagar) 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1  Vodafone (C P) 1 W.OFF 1 1 1 1 1 1 W.OFF 1 1 1 1 1
1 W.OFF
I am trying on pivot but its showing only count & not the value.

Database is huge more than 2 Lac so i need some technique which wl work
shortly & in precise way.

Regards,
Deepak

-- 
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 Data.xlsb
Description: Binary data

Re: $$Excel-Macros$$ Run-time error popup message

[अनिल नारायण गवली]

I didn't understand your remaining 50% query.
Exactly what u want and how?
Pl elaborate it...
Regards,
Gawli Anil

On Mon, Aug 6, 2012 at 2:25 PM, Lokesh Loki <> wrote:

> Hi All,
>
> It's urgent anybody please resolve my query. I hope all of you understand
> my concern.
>
> Regards
> Lokesh.M
>
>
> On Mon, Aug 6, 2012 at 11:18 AM, Lokesh Loki wrote:
>
>> Hi All,
>>
>> From last week to till now i am sending mails to the group but till now i
>> did not get any reply from the group. Only rajan has replied to my mail but
>> 50% of the problem has been resolved and remaining still i am facing issue
>> on VBA code. So team please resolve the vba code it would be very helpful
>> to me get report ASAP.
>>
>> Regards
>> Lokesh.M
>>
>>
>> On Sat, Aug 4, 2012 at 10:40 PM, Lokesh Loki wrote:
>>
>>> Hi Rajan,
>>>
>>> I have replaced the error line and i got the exact employee's number of
>>> working days, but the 4 hrs of macro timings are not multiplied to those
>>> users. Please check and do the needful brother.
>>>
>>> Regards
>>> Lokesh.M
>>>
>>>
>>> On Sat, Aug 4, 2012 at 4:11 PM, Rajan_Verma wrote:
>>>
  *Replace error line with this :*

 * *

 *.Offset(lngCellLoop, 1).Value = Format(CDate(.Offset(lngCellLoop,
 -1).Value + (4 * objDic.Count)), "hh:mm:ss")*

 * *

 * *

 * *

 *Regards*

 *Rajan verma*

 *+91 7838100659 [IM-Gtalk]*

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *lokesh
 *Sent:* 02 August 2012 5:59
 *To:* excel-macros@googlegroups.com

 *Subject:* $$Excel-Macros$$ Run-time error popup message

 ** **

 Hi All,

  

 When I am clicked the Get Report to know monthly report I got the error
 popup message window saying that “Run-time error’13 in VBA’” , hence I did
 not get the monthly report. 

  

 Please find the above attached print screen of VBA line error and do
 the needful.

 ** **

 ** **

 Regards

 Lokesh.M

 --
 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

  

 --
 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



>>>
>>>
>>
> --
> 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 allow

Re: $$Excel-Macros$$ Run-time error popup message

[Lokesh Loki]

Hi All,

It's urgent anybody please resolve my query. I hope all of you understand
my concern.

Regards
Lokesh.M

On Mon, Aug 6, 2012 at 11:18 AM, Lokesh Loki wrote:

> Hi All,
>
> From last week to till now i am sending mails to the group but till now i
> did not get any reply from the group. Only rajan has replied to my mail but
> 50% of the problem has been resolved and remaining still i am facing issue
> on VBA code. So team please resolve the vba code it would be very helpful
> to me get report ASAP.
>
> Regards
> Lokesh.M
>
>
> On Sat, Aug 4, 2012 at 10:40 PM, Lokesh Loki wrote:
>
>> Hi Rajan,
>>
>> I have replaced the error line and i got the exact employee's number of
>> working days, but the 4 hrs of macro timings are not multiplied to those
>> users. Please check and do the needful brother.
>>
>> Regards
>> Lokesh.M
>>
>>
>> On Sat, Aug 4, 2012 at 4:11 PM, Rajan_Verma wrote:
>>
>>> *Replace error line with this :*
>>>
>>> * *
>>>
>>> *.Offset(lngCellLoop, 1).Value = Format(CDate(.Offset(lngCellLoop,
>>> -1).Value + (4 * objDic.Count)), "hh:mm:ss")*
>>>
>>> * *
>>>
>>> * *
>>>
>>> * *
>>>
>>> *Regards*
>>>
>>> *Rajan verma*
>>>
>>> *+91 7838100659 [IM-Gtalk]*
>>>
>>> * *
>>>
>>> *From:* excel-macros@googlegroups.com [mailto:
>>> excel-macros@googlegroups.com] *On Behalf Of *lokesh
>>> *Sent:* 02 August 2012 5:59
>>> *To:* excel-macros@googlegroups.com
>>>
>>> *Subject:* $$Excel-Macros$$ Run-time error popup message
>>>
>>> ** **
>>>
>>> Hi All,
>>>
>>>  
>>>
>>> When I am clicked the Get Report to know monthly report I got the error
>>> popup message window saying that “Run-time error’13 in VBA’” , hence I did
>>> not get the monthly report. 
>>>
>>>  
>>>
>>> Please find the above attached print screen of VBA line error and do the
>>> needful.
>>>
>>> ** **
>>>
>>> ** **
>>>
>>> Regards
>>>
>>> Lokesh.M
>>>
>>> --
>>> 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
>>>
>>>  
>>>
>>> --
>>> 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
>>>
>>>
>>>
>>
>>
>

-- 
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

$$Excel-Macros$$ need help to send excel userform data to send email body...

[Dhartikumar Sahu]

hi expert guru's

I want to send mail my userform data to my group mail id. how to write ma
code to send my userform data.

awaiting for your prompt reply.
-- 

*Regards,*

*Dhartikumar Sahu*

Sr.Database Manager - Institutional Equities

* **IDBI Capital Markets Services Ltd*

5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21

Board: +91 22 4322 1212 | Dir: +91 22 4322 1169 | Cell: +91 77383 63450

-- 
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$$ Excel formula / training material in ppt format

[Amit Desai (MERU)]

Dear Friends,

Does any one have training material in ppt form for all excel formulas (basic & 
Advanced)? If you please forward, this will help us to train others in the 
organization.

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
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: Urgent Help needed

[francis vinod]

Hi Ashish,

Thank you so much for your quick response. 


Yes, it did help, but the problem was when I tried to implement this formula in 
my work sheet, I am getting an error message, could you please advise what 
could be the reason for this error that would be great.

Error Message

  =lookupall(C2,'Report 1'!$G$2:$K$5760,5)

 
Thanks & Regards,
Francis



 From: ashish koul 
To: excel-macros@googlegroups.com 
Sent: Friday, 3 August 2012 10:35 PM
Subject: Re: $$Excel-Macros$$ Fw: Urgent Help needed
 

check the attachment   see if it helps





On Fri, Aug 3, 2012 at 7:05 PM, francis vinod  wrote:

Hi Don,
>
>
>I never said my request is more urgent than other's request, since I didn't 
>get any response to my earlier mail and I had to do some reporting so included 
>the word 'urgent' in the subject line that's all.
> 
>Thanks & Regards,
>Francis
>
>
>
> From: dguillett1 
>To: excel-macros@googlegroups.com 
>Sent: Friday, 3 August 2012 5:44 PM
>Subject: Re: $$Excel-Macros$$ Fw: Urgent Help needed
> 
>
>
>Why is your request more urgent than the request of any of the 
others?
> 
>Don 
Guillett
>Microsoft Excel Developer
>SalesAid 
Software
>dguille...@gmail.com 
>From: francis vinod 
>Sent: Friday, August 03, 2012 2:35 AM
>To: excel-macros@googlegroups.com 
>Subject: $$Excel-Macros$$ Fw: Urgent Help needed
>  Hello Experts,
>
>Could you please provide me a solution on the below 
scenario.
>
>Thanks & Regards,
>
>Francis
>
>- Forwarded Message -
>From: francis vinod 

>To: "excel-macros@googlegroups.com" 
 
>Sent: Wednesday, 1 August 2012 6:54 
PM
>Subject: Help 
needed
>
> 
>Hello Team, 
>
>
>
>Could you please help me in the below scenario.
>I have two different reports from which I have to prepare a single 
report for reporting purpose.
>In sheet 1 the reports contains tracking#, HW details etc. & and sheet 
2 the report contains the values of the HW, tracking # 
etc
>
>The report which I want should have the details of both Shee1 & 
Sheet 2 for which I have used the Vlookup formula and its fine.  The issue 
what I am facing is a single tracking # can have multiple line items and in the 
equipment report the equipments are split into seperate rows.  For eg, If a 
tracking # has 5 different equipments with discreptions in 5 lineitems then 
when 
I use a VLookup formula it only shows the detail of equipment in 1st 
line.
>
>
>So I want your help on this so that I get all the 5 equipment details 
in my report.  
>
>
>
>Please find attached the excel file with an example.
>
>
>If you could guide me it would be a great help and learning for 
me.
>
> 
>Thanks & 
Regards,
>Francis
>
>-- 
>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
> 
> 
>
-- 
>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
> 
> 
>
>
>
> -- 
>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