Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

[pankaj gmail account]

Thank You Abhishek Great!

I was just looking for the same.

in future I will try to provide a sample query or form..

Regards,
Pankaj Michael

On Thu, May 2, 2013 at 11:28 AM, Abhishek Jain wrote:

> Dear Pankaj,
>
> Please see attached. Hope this is what you are looking for, if not, let me
> know.
>
> However, it is advisable to have a sample file for your query ready with
> you, particularly for VBA and User Form related problems. You would
> appreciate that in this forum people voluntarily take time and help each
> other as much as they can but trust me, asking to create a whole userform
> from scratch is a bit much to ask. Besides, if there is a ready sample
> file, people get to see what and where is the exact problem rather then
> creating their own files and then recreating the problem thereon. Queries
> with sample forms are resolved much sooner.
>
> Hope this makes sense to you.
>
> Cheers!
>
> AJ
>
> On Thu, May 2, 2013 at 9:30 AM, pankaj gmail account  > wrote:
>
>> in VBA Form.
>>
>> Regards,
>> Pankaj
>>
>
> Dear Priti,
>
> I want user  restriction in Excel GUI form.
>
> Regards,
> Pankaj
>
>>
>> On Wed, May 1, 2013 at 4:30 PM, ravinder negi wrote:
>>
>>> please give more detail with example file so we can understand properly
>>> whether you want this in VBA for or normally in excel sheet.
>>>
>>>
>>> --- On *Wed, 5/1/13, pankaj gmail account * wrote:
>>>
>>>
>>> From: pankaj gmail account 
>>> Subject: $$Excel-Macros$$ Fwd: Mandatory Cell Entry
>>> To: excel-macros@googlegroups.com
>>> Date: Wednesday, May 1, 2013, 2:30 PM
>>>
>>>
>>>
>>>
>>> -- Forwarded message --
>>> From: *pankaj gmail account* 
>>> http://mc/compose?to=pankaji...@gmail.com>
>>> >
>>> Date: Sat, Jan 5, 2013 at 9:10 AM
>>> Subject: Mandatory Cell Entry
>>> To: 
>>> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>
>>>
>>>
>>> Dear Gurus
>>>
>>> I want to make a excel data entry form in which i want some cells to be
>>> mandatory and some can be left out. But with sequence
>>>
>>> Like
>>>
>>> Name (Mandatory)
>>> Address (Mandatory)
>>> Phone ( not mandatory)
>>>
>>> *first field entry should be name, he cannot move to phone directly
>>> until name is filled. is it possible in Excel?
>>> *--
>>>
>>> Thanks
>>> Pankaj Kumar
>>> 9910075248
>>>
>>>
>>>
>>> --
>>>
>>> Thanks
>>> Pankaj Kumar
>>> 9910075248
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>>
>>>
>>>  --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

[pankaj gmail account]

in VBA Form.

Regards,
Pankaj

On Wed, May 1, 2013 at 4:30 PM, ravinder negi wrote:

> please give more detail with example file so we can understand properly
> whether you want this in VBA for or normally in excel sheet.
>
>
> --- On *Wed, 5/1/13, pankaj gmail account * wrote:
>
>
> From: pankaj gmail account 
> Subject: $$Excel-Macros$$ Fwd: Mandatory Cell Entry
> To: excel-macros@googlegroups.com
> Date: Wednesday, May 1, 2013, 2:30 PM
>
>
>
>
> ------ Forwarded message --
> From: *pankaj gmail account* 
> http://mc/compose?to=pankaji...@gmail.com>
> >
> Date: Sat, Jan 5, 2013 at 9:10 AM
> Subject: Mandatory Cell Entry
> To: 
> excel-macros@googlegroups.com<http://mc/compose?to=excel-macros@googlegroups.com>
>
>
> Dear Gurus
>
> I want to make a excel data entry form in which i want some cells to be
> mandatory and some can be left out. But with sequence
>
> Like
>
> Name (Mandatory)
> Address (Mandatory)
> Phone ( not mandatory)
>
> *first field entry should be name, he cannot move to phone directly until
> name is filled. is it possible in Excel?
> *--
>
> Thanks
> Pankaj Kumar
> 9910075248
>
>
>
> --
>
> Thanks
> Pankaj Kumar
> 9910075248
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 

Thanks
Pankaj Kumar
9910075248

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not 

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

[pankaj gmail account]

Dear Priti,

I want user  restriction in Excel GUI form.

Regards,
Pankaj

On Wed, May 1, 2013 at 2:59 PM, priti verma wrote:

> Hi Pankaj,
> I thing you want data validation thats restrict to enter the name in to
> the column of phone number.and to restrict the phone number to enter into
> columns of name. am i right or not.
> Regards,
> Priti verma
>
>
>
> On Wed, May 1, 2013 at 2:30 PM, pankaj gmail account  > wrote:
>
>>
>>
>> ------ Forwarded message --
>> From: pankaj gmail account 
>> Date: Sat, Jan 5, 2013 at 9:10 AM
>> Subject: Mandatory Cell Entry
>> To: excel-macros@googlegroups.com
>>
>>
>> Dear Gurus
>>
>> I want to make a excel data entry form in which i want some cells to be
>> mandatory and some can be left out. But with sequence
>>
>> Like
>>
>> Name (Mandatory)
>> Address (Mandatory)
>> Phone ( not mandatory)
>>
>> *first field entry should be name, he cannot move to phone directly
>> until name is filled. is it possible in Excel?
>> *--
>>
>> Thanks
>> Pankaj Kumar
>> 9910075248
>>
>>
>>
>> --
>>
>> Thanks
>> Pankaj Kumar
>> 9910075248
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>



-- 

Thanks
Pankaj Kumar
9910075248

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Fwd: Mandatory Cell Entry

[pankaj gmail account]

-- Forwarded message --
From: pankaj gmail account 
Date: Sat, Jan 5, 2013 at 9:10 AM
Subject: Mandatory Cell Entry
To: excel-macros@googlegroups.com


Dear Gurus

I want to make a excel data entry form in which i want some cells to be
mandatory and some can be left out. But with sequence

Like

Name (Mandatory)
Address (Mandatory)
Phone ( not mandatory)

*first field entry should be name, he cannot move to phone directly until
name is filled. is it possible in Excel?
*--

Thanks
Pankaj Kumar
9910075248



-- 

Thanks
Pankaj Kumar
9910075248

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Curve Graph Help

[pankaj gmail account]

 Dear Gurus


how can i create Curve bell Graph with this data.
Month - Failure in Month
Year - Failure in Year


Month Yr -2007 2008 2009 2010 2011 2012 2013  1 6 4 1 2   1 1  2 12 7 3
5 9 43 11 7 3 8 4 144 18 12 11 7 12 65 12 12 4 3 8 7 1  6 15 11
7 9 7 13 2  7 13 9 6 10 5 5 1  8 13 7 4 12 9 119 15 17 6 11 7 8 1  10 7
7 5 11 5 611 11 5 10 9 4 712 12 18 5 12 7 613 8 9 8 4 5 6 1  14
7 12 4 5 11 5 2  15 6 12 5 8 1 6 1  16 6 5 1 2 2 317 4 3 3 2 3 118 2
1 3   1 3 1

-- 

Thanks
Pankaj Kumar
9910075248



-- 

Thanks
Pankaj Kumar
9910075248

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

$$Excel-Macros$$ Tricks to hide/restrict viewing excel data in sheets

[pankaj gmail account]

Dear Gurus,

Please suggest ideas to hide/restrict data viewing in excel data sheets
version 2007/2010.
using VBA also.

blocking right click, copy/paste, printing, saving, copy file, not able to
view formula's etc.

-- 

Thanks
Pankaj Kumar
9910075248



-- 

Thanks
Pankaj Kumar
9910075248

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

[pankaj gmail account]

Dear All,

Pleae help to resolve the query.

DEar Prince

Please check




On Tue, Jan 15, 2013 at 12:40 PM, pankaj gmail account  wrote:

> Dear Gurus
>
> Please help.
>
> Regards,
> Pnkaj
>
> On Thu, Jan 10, 2013 at 5:10 PM, Prince  wrote:
>
>> Ok Pankaj
>> i can only reply in evening.
>>
>> regards
>> Prince
>>
>>
>> On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote:
>>
>>>  Don't use differnt mails.
>>>
>>> REgards,
>>> Pankaj
>>>
>>>  On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H wrote:
>>>
>>>>  Hi Prince,
>>>>
>>>> Its not working.
>>>>
>>>> Can you send me example with this formula.
>>>>
>>>> Rgds,
>>>> Prabhakar
>>>>
>>>> On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote:
>>>>
>>>>> yes it is possible, pleas follow the following steps.
>>>>>
>>>>> 1:DATA Tab->Data validation->Data validation->Select *Custom *in
>>>>> allow section-> In formula box Write *=A1<>"" *->Select *Error alert
>>>>> tab* on same popup
>>>>> ->in Style select *stop*->in error message option give your message->
>>>>> And at last* OK*
>>>>>
>>>>>
>>>>> That's All
>>>>>
>>>>> Regards
>>>>> Prince
>>>>>
>>>>> On Saturday, January 5, 2013 9:10:29 AM UTC+5:30, Pankaj wrote:
>>>>>>
>>>>>> Dear Gurus
>>>>>>
>>>>>> I want to make a excel data entry form in which i want some cells to
>>>>>> be mandatory and some can be left out. But with sequence
>>>>>>
>>>>>> Like
>>>>>>
>>>>>> Name (Mandatory)
>>>>>> Address (Mandatory)
>>>>>> Phone ( not mandatory)
>>>>>>
>>>>>> *first field entry should be name, he cannot move to phone directly
>>>>>> until name is filled. is it possible in Excel?
>>>>>> *--
>>>>>>
>>>>>> Thanks
>>>>>> Pankaj Kumar
>>>>>> 9910075248
>>>>>>
>>>>> --
>>>> Join official Facebook page of this forum @ https://www.facebook.com/**
>>>> discussexcel <https://www.facebook.com/discussexcel>
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>> To unsubscribe from this group, send email to excel-macros...@**
>>>> googlegroups.com.
>>>>
>>>> Visit this group at 
>>>> http://groups.google.com/**group/excel-macros?hl=en<http://groups.google.com/group/excel-macros?hl=en>
>>>> .
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> Thanks
>>> Pankaj Kumar
>>> 9910075248
>>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>&g

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

[pankaj gmail account]

Dear Gurus

Please help.

Regards,
Pnkaj

On Thu, Jan 10, 2013 at 5:10 PM, Prince  wrote:

> Ok Pankaj
> i can only reply in evening.
>
> regards
> Prince
>
>
> On Thursday, January 10, 2013 5:02:06 PM UTC+5:30, Pankaj wrote:
>
>>  Don't use differnt mails.
>>
>> REgards,
>> Pankaj
>>
>>  On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H wrote:
>>
>>>  Hi Prince,
>>>
>>> Its not working.
>>>
>>> Can you send me example with this formula.
>>>
>>> Rgds,
>>> Prabhakar
>>>
>>> On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote:
>>>
 yes it is possible, pleas follow the following steps.

 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow
 section-> In formula box Write *=A1<>"" *->Select *Error alert tab* on
 same popup
 ->in Style select *stop*->in error message option give your message->
 And at last* OK*


 That's All

 Regards
 Prince

 On Saturday, January 5, 2013 9:10:29 AM UTC+5:30, Pankaj wrote:
>
> Dear Gurus
>
> I want to make a excel data entry form in which i want some cells to
> be mandatory and some can be left out. But with sequence
>
> Like
>
> Name (Mandatory)
> Address (Mandatory)
> Phone ( not mandatory)
>
> *first field entry should be name, he cannot move to phone directly
> until name is filled. is it possible in Excel?
> *--
>
> Thanks
> Pankaj Kumar
> 9910075248
>
 --
>>> Join official Facebook page of this forum @ https://www.facebook.com/**
>>> discussexcel 
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> To unsubscribe from this group, send email to excel-macros...@**
>>> googlegroups.com.
>>>
>>> Visit this group at 
>>> http://groups.google.com/**group/excel-macros?hl=en
>>> .
>>>
>>>
>>>
>>
>>
>>
>> --
>>
>> Thanks
>> Pankaj Kumar
>> 9910075248
>>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Thanks
Pankaj Kumar
9910075248

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

[pankaj gmail account]

I have not received any answer.

Regards,
Pankaj

On Tue, Jan 8, 2013 at 7:56 PM, pankaj gmail account
wrote:

> Dear Prince and Lalit Thanks for response.
>
> what i wanted in a excel file:-
>
> Student ID Class SubjectMarks(Mandatory)
> 123  V  Maths
> 345  V  Maths
> 123  V  English
> 456  V  Maths
> 123  V  Hindi
>
> Click on *student id(123)* data Entry form should open , Enter  Marks and
> save it as soon it is saved next record should open but marks entered
> records should not visible in marks field. data should saved with mandatory
> fields.
>
>
> Thanks
> Pankaj Michael
>
> On Sun, Jan 6, 2013 at 9:43 AM,  wrote:
>
>> **
>> Hi Pankaj
>>
>> Why don't you use user form for the same with better features.
>>
>> Regards,
>> Lalit Mohan
>> Sent from BlackBerry® on Airtel
>> --
>> *From: * Prince 
>> *Sender: * excel-macros@googlegroups.com
>> *Date: *Sat, 5 Jan 2013 20:03:55 -0800 (PST)
>> *To: *
>> *ReplyTo: * excel-macros@googlegroups.com
>> *Subject: *$$Excel-Macros$$ Re: Mandatory Cell Entry
>>
>> yes it is possible, pleas follow the following steps.
>>
>> 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow
>> section-> In formula box Write *=A1<>"" *->Select *Error alert tab* on
>> same popup
>> ->in Style select *stop*->in error message option give your message->
>> And at last* OK*
>>
>>
>> That's All
>>
>> Regards
>> Prince
>>
>> On Saturday, January 5, 2013 9:10:29 AM UTC+5:30, Pankaj wrote:
>>>
>>> Dear Gurus
>>>
>>> I want to make a excel data entry form in which i want some cells to be
>>> mandatory and some can be left out. But with sequence
>>>
>>> Like
>>>
>>> Name (Mandatory)
>>> Address (Mandatory)
>>> Phone ( not mandatory)
>>>
>>> *first field entry should be name, he cannot move to phone directly
>>> until name is filled. is it possible in Excel?
>>> *--
>>>
>>> Thanks
>>> Pankaj Kumar
>>> 9910075248
>>>
>>  --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>>
>>
>>
>> --
>> Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To uns

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

[pankaj gmail account]

Don't use differnt mails.

REgards,
Pankaj

On Thu, Jan 10, 2013 at 2:22 PM, Prabhakar S H wrote:

> Hi Prince,
>
> Its not working.
>
> Can you send me example with this formula.
>
> Rgds,
> Prabhakar
>
> On Sunday, January 6, 2013 9:33:55 AM UTC+5:30, Prince wrote:
>
>> yes it is possible, pleas follow the following steps.
>>
>> 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow
>> section-> In formula box Write *=A1<>"" *->Select *Error alert tab* on
>> same popup
>> ->in Style select *stop*->in error message option give your message->
>> And at last* OK*
>>
>>
>> That's All
>>
>> Regards
>> Prince
>>
>> On Saturday, January 5, 2013 9:10:29 AM UTC+5:30, Pankaj wrote:
>>>
>>> Dear Gurus
>>>
>>> I want to make a excel data entry form in which i want some cells to be
>>> mandatory and some can be left out. But with sequence
>>>
>>> Like
>>>
>>> Name (Mandatory)
>>> Address (Mandatory)
>>> Phone ( not mandatory)
>>>
>>> *first field entry should be name, he cannot move to phone directly
>>> until name is filled. is it possible in Excel?
>>> *--
>>>
>>> Thanks
>>> Pankaj Kumar
>>> 9910075248
>>>
>>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Thanks
Pankaj Kumar
9910075248

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Re: Mandatory Cell Entry

[pankaj gmail account]

Dear Prince and Lalit Thanks for response.

what i wanted in a excel file:-

Student ID Class SubjectMarks(Mandatory)
123  V  Maths
345  V  Maths
123  V  English
456  V  Maths
123  V  Hindi

Click on *student id(123)* data Entry form should open , Enter  Marks and
save it as soon it is saved next record should open but marks entered
records should not visible in marks field. data should saved with mandatory
fields.


Thanks
Pankaj Michael

On Sun, Jan 6, 2013 at 9:43 AM,  wrote:

> **
> Hi Pankaj
>
> Why don't you use user form for the same with better features.
>
> Regards,
> Lalit Mohan
> Sent from BlackBerry® on Airtel
> --
> *From: * Prince 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Sat, 5 Jan 2013 20:03:55 -0800 (PST)
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Re: Mandatory Cell Entry
>
> yes it is possible, pleas follow the following steps.
>
> 1:DATA Tab->Data validation->Data validation->Select *Custom *in allow
> section-> In formula box Write *=A1<>"" *->Select *Error alert tab* on
> same popup
> ->in Style select *stop*->in error message option give your message-> And
> at last* OK*
>
>
> That's All
>
> Regards
> Prince
>
> On Saturday, January 5, 2013 9:10:29 AM UTC+5:30, Pankaj wrote:
>>
>> Dear Gurus
>>
>> I want to make a excel data entry form in which i want some cells to be
>> mandatory and some can be left out. But with sequence
>>
>> Like
>>
>> Name (Mandatory)
>> Address (Mandatory)
>> Phone ( not mandatory)
>>
>> *first field entry should be name, he cannot move to phone directly
>> until name is filled. is it possible in Excel?
>> *--
>>
>> Thanks
>> Pankaj Kumar
>> 9910075248
>>
>  --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Thanks
Pankaj Kumar
9910075248

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To

$$Excel-Macros$$ Mandatory Cell Entry

[pankaj gmail account]

Dear Gurus

I want to make a excel data entry form in which i want some cells to be
mandatory and some can be left out. But with sequence

Like

Name (Mandatory)
Address (Mandatory)
Phone ( not mandatory)

*first field entry should be name, he cannot move to phone directly until
name is filled. is it possible in Excel?
*--

Thanks
Pankaj Kumar
9910075248

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Quiz results

[pankaj gmail account]

Good Quiz Keep it up.

Hope more quizes.

Pankaj Michel

On Tue, Nov 13, 2012 at 11:59 PM, Ayush Jain  wrote:

> Dear group,
>
> Thanks for your participation in the quiz. There was very good response to
> the quiz from the members of this forum.
>
> Excel quiz : 250 responses
> VBA quiz : 228 responses
>
> I am enclosing the results along with summary and answers in this email.
> If you have any doubts on the question or their options of quiz feel free
> to write back to me, I am happy to clarify.
>
> Looking at the good response, I think I can create more such quiz in
> future but I need your suggestions and inputs to make these quiz better.
> This is just a start.
>
> I hope this quiz will increase some knowledge and engagement in the group.
> If you have better ideas, please share with the forum.
> Let me know if you have any feedback.
>
> Regards
> Ayush Jain
>
> --
> 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.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>
>
>



-- 

Thanks
Pankaj Kumar
9910075248

-- 
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.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Combo [ Formula + Macro Bible] - [Prince 9953872217]

[pankaj gmail account]

Thanks
On Sun, Oct 14, 2012 at 7:19 PM, SUDHIR VERMA  wrote:

> thankx for sharing
>
>
>
> On 14 October 2012 10:23, Nikhil Shah  wrote:
>
>> Hi
>>
>> Thanks for sending excellent file,
>>
>> (1). Prince Formula Bible (Updated Version)
>> (2). Updated Lets Learn Together ( Macro Bible )
>> Can you send all files in excel 2003..
>>
>> Nikhil
>>
>>
>>
>> On Sat, Oct 13, 2012 at 10:02 PM, Prince Sethi 
>> wrote:
>>
>>>
>>>
>>> --
>>>
>>>
>>> Regards
>>>
>>> [image: Description: cid:image003.png@01CBFC21.609970A0]
>>>
>>>
>>>
>>>  --
>>> 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.
>
>
>



-- 
Pankaj Kumar

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

$$Excel-Macros$$ Debuging VBA Programs

[pankaj gmail account]

Dear All,

Please guide hw to Debug VBA Programs


Regards
-- 
Pankaj Kumar

-- 
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 Book Closed Macros

[pankaj gmail account]

Any Suggestions

outlook is open but excel 2007 is closed.

Regards
Pankaj

On Fri, Jul 27, 2012 at 4:28 PM, Pankaj  wrote:

> Dear Gurus,
>
> Can we create a macro or how can we send mails if my excel book is closed.
>
> like i have data:--
>
> Name Email IDDate   Difference
> Days
> A a...@mail.com 12-12-2011 1
> B  b@*mail.com* 
> 15-12-2011 2
>
>
> if before difference day is 1 that means 11-12-2011 is Sunday actual date
> is 12-12-2011
> mail should be send to mail id on 11-12-2011 with subject as name.
>
> is it possible.
>
> Regards,
> Pankaj Michael
>
>
>
>
>
> --
> --
> 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
>
>
>



-- 
Pankaj Kumar

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

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

[pankaj gmail account]

Dear Moderator,

i appreciate if any one gets award.

Four types of mails are filling my mailbox

*1. MVP Award*
*2. Introduce Yourself*
*3. Five Year Completion*
*4. Help ful Member*

Then why *Not Job posting* also this will help forum members too.

Regards,
Pankaj
On Thu, Jul 5, 2012 at 10:04 AM,  wrote:

> **
> Hi Pankaj,
>
> Its an appreciation given to group members for helping.
>
> Correct me Ayush if I am wrong.
>
> Thanks,
> Joseph
> Sent on my BlackBerry® from Vodafone
> ----------
> *From: * pankaj gmail account 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Thu, 5 Jul 2012 09:37:17 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul
> and Dilip Pandey !!--Add
>
> These kind of Congratulating etc
>
> Regards
> Pankaj
>
> On Wed, Jul 4, 2012 at 10:20 PM, Bé Trần Văn wrote:
>
>> I just want to congratulate Ashish and Dilip.
>> and contributions that you want two more forums.
>>
>> 2012/7/4 Ayush Jain 
>>
>>> Pankaj,
>>>
>>> Please let me know which advertisements you are referring to.
>>>
>>> Thanks,
>>>
>>>
>>> On Tuesday, 3 July 2012 11:25:02 UTC+5:30, panky wrote:
>>>
>>>> Dear Moderator,
>>>>
>>>> Please also Ban these kinds of Promotional/Advertisements in this forum.
>>>>
>>>> They are not related to Excel Help.
>>>>
>>>> Please advice
>>>>
>>>>
>>>> Thanks and Regads,
>>>> Pankaj Michael
>>>>
>>>> On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote:
>>>>
>>>>> Dear members,
>>>>>
>>>>> I am extremely happy to inform you that two members of the group are
>>>>> awarded Microsoft Most Valuable Professional Award.
>>>>> My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
>>>>> thanks for their big support to this forum.
>>>>>
>>>>> Keep posting !
>>>>>
>>>>> Best 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+unsubscribe@**
>>>>> googlegroups.com 
>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Pankaj Kumar
>>>>
>>> --
>>> 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 o

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

[pankaj gmail account]

These kind of Congratulating etc

Regards
Pankaj

On Wed, Jul 4, 2012 at 10:20 PM, Bé Trần Văn wrote:

> I just want to congratulate Ashish and Dilip.
> and contributions that you want two more forums.
>
> 2012/7/4 Ayush Jain 
>
>> Pankaj,
>>
>> Please let me know which advertisements you are referring to.
>>
>> Thanks,
>>
>>
>> On Tuesday, 3 July 2012 11:25:02 UTC+5:30, panky wrote:
>>
>>> Dear Moderator,
>>>
>>> Please also Ban these kinds of Promotional/Advertisements in this forum.
>>>
>>> They are not related to Excel Help.
>>>
>>> Please advice
>>>
>>>
>>> Thanks and Regads,
>>> Pankaj Michael
>>>
>>> On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote:
>>>
 Dear members,

 I am extremely happy to inform you that two members of the group are
 awarded Microsoft Most Valuable Professional Award.
 My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
 thanks for their big support to this forum.

 Keep posting !

 Best 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+unsubscribe@**
 googlegroups.com 
>>>
>>>
>>>
>>>
>>> --
>>> Pankaj Kumar
>>>
>> --
>> 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
>



-- 
Pankaj Kumar

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

Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!--Add

[pankaj gmail account]

Dear Moderator,

Please also Ban these kinds of Promotional/Advertisements in this forum.

They are not related to Excel Help.

Please advice


Thanks and Regads,
Pankaj Michael

On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain  wrote:

> Dear members,
>
> I am extremely happy to inform you that two members of the group are
> awarded Microsoft Most Valuable Professional Award.
> My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
> thanks for their big support to this forum.
>
> Keep posting !
>
> Best 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




-- 
Pankaj Kumar

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

Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW

[pankaj gmail account]

It is very Helpful -- Thank you for sharing  Please upload more examples of
Dashboards.


Regards,
Pankaj Michael

On Fri, Feb 10, 2012 at 12:46 AM,  wrote:

> Its just historical stock market information for the Ghana stock exchange
> and major mkt indicators. But its the idea behind in tht u can picture any
> report you want to generate and design it along side
> Sent from my BlackBerry® smartphone from Airtel Ghana
>
> -Original Message-
> From: Liyakath Khan 
> Sender: excel-macros@googlegroups.com
> Date: Thu, 9 Feb 2012 21:14:26
> To: 
> Reply-To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ DASHBOARD FOR STOCK MARKET REVIEW
>
> Hi bro,
>
> It was very superb, Could you please explain me basic information about
> same.
>
>
> Thanks
> Liyakath Ali Khan
> Mob:09844577212
>
> On 2/9/12, hilary lomotey  wrote:
> > DA
> >
> > I just completed a dashboard for stock market review and wanted to share
> it
> > to the group,( i got a lot of inputs from this group), i have hidden the
> > all the working sheets except for the dashboard. U can unhide to see how
> it
> > was prepared. i hope you like it. i would be glad to also get other
> > dashboard from anyone who has similar. thanks
> >
> > --
> > 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
> >
>
> --
> 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
>
> --
> 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
>



--

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

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

[pankaj gmail account]

Thanks Noorain,


Please provide VBA password.

Regards
Pankaj

On Thu, Jun 21, 2012 at 3:07 PM, Indrajit $nai wrote:

> @Noorain, thanks for your help, its working. :D
>
> Thanks & Regards,
> Indrajit
>
>
> On Thu, Jun 21, 2012 at 1:16 PM, Maries  wrote:
>
>> Hi,
>>
>> Find the attached file of Construction Projects Dashboard which is
>> designed by me.
>>
>>
>>
>>
>> On Wed, Jun 20, 2012 at 8:22 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Indrajit,
>>>
>>> First of all this is not my dashboard, it's designed by one of our group
>>> member Hilary.
>>> Brother..you goto Excel Option-Advance and check Show Sheet Tab Option.
>>> After this all hide sheet will show.
>>>
>>> Hope it will help to you.
>>>
>>>
>>>
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>> On Thu, Jun 21, 2012 at 12:44 AM, Indrajit $nai >> > wrote:
>>>
>>>> @Dear Noorain,
>>>> In one of your Dashboard sample file (DASHBOARD REPORT-BROKERAGE-V2.5)
>>>> all the sheets are hidden but links are working, can you please explain how
>>>> to create this kind of file.
>>>> Thanks in advance.
>>>>
>>>> Thanks & Regards,
>>>> Indrajit
>>>>
>>>>
>>>> On Tue, Jun 19, 2012 at 10:15 PM, pankaj gmail account <
>>>> pankaji...@gmail.com> wrote:
>>>>
>>>>> Thanks You both Really they are great.
>>>>>
>>>>> We should share more sample Dashboards in Excel
>>>>>
>>>>>
>>>>> Regards
>>>>> Pankaj Michael
>>>>>
>>>>> On Tue, Jun 19, 2012 at 8:37 PM, Mangesh Vimay <
>>>>> mangesh.da...@gmail.com> wrote:
>>>>>
>>>>>> Thanks Noorain for sharing such nice examples..!!!
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI <
>>>>>> noorain.ans...@gmail.com> wrote:
>>>>>>
>>>>>>> PFA
>>>>>>>
>>>>>>>
>>>>>>> On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay <
>>>>>>> mangesh.da...@gmail.com> wrote:
>>>>>>>
>>>>>>>> Many many thanks for this
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Jun 19, 2012 at 6:39 PM, CoRe wrote:
>>>>>>>>
>>>>>>>>> Hello Pankaj,
>>>>>>>>>
>>>>>>>>> As far as i know chandoo has greate dashboard templates for free ,
>>>>>>>>>
>>>>>>>>> Attached you can find out a few chandoo dashboards , maybe they
>>>>>>>>> skipped your eyes.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote:
>>>>>>>>>
>>>>>>>>>> Dear All,
>>>>>>>>>>
>>>>>>>>>> Please share Dashboard Examples/Templates
>>>>>>>>>>
>>>>>>>>>> I already viewed Chandoo's Site so no reference to that site.
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Pankaj Kumar
>>>>>>>>>>
>>>>>>>>>  --
>>>>>>>>> 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.
>>>>>>>>>
>>>>>

Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates

[pankaj gmail account]

Thanks You both Really they are great.

We should share more sample Dashboards in Excel


Regards
Pankaj Michael

On Tue, Jun 19, 2012 at 8:37 PM, Mangesh Vimay wrote:

> Thanks Noorain for sharing such nice examples..!!!
>
>
>
> On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI 
> wrote:
>
>> PFA
>>
>>
>> On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay 
>> wrote:
>>
>>> Many many thanks for this
>>>
>>>
>>>
>>>
>>> On Tue, Jun 19, 2012 at 6:39 PM, CoRe  wrote:
>>>
 Hello Pankaj,

 As far as i know chandoo has greate dashboard templates for free ,

 Attached you can find out a few chandoo dashboards , maybe they skipped
 your eyes.






 On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote:

> Dear All,
>
> Please share Dashboard Examples/Templates
>
> I already viewed Chandoo's Site so no reference to that site.
>
> --
> Pankaj Kumar
>
  --
 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,
>>>
>>> MaNgEsH
>>>
>>>  --
>>> 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,
>> Noorain Ansari
>> www.noorainansari.com
>> www.excelmacroworld.blogspot.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
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> 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.
>
>
> 

$$Excel-Macros$$ share Dashboard Examples/Templates

[pankaj gmail account]

Dear All,

Please share Dashboard Examples/Templates

I already viewed Chandoo's Site so no reference to that site.

-- 
Pankaj Kumar

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

Re: $$Excel-Macros$$ Re: MIS executive

[pankaj gmail account]

Hi To All,

I also agree that we should also think about Job Posting in this forum.
If a Needy gets Job with our help that's the best result of the forum.

OK I also agree that this is not a Job Forum but instead of joining other
Job forums we should think some alternative like we can use some Mandatory
Subject Line etc JOB:- Posting :-- Job Details-


Dear Moderator Please think Excel do not pay much and now a days we are
facing lots of competition with other BI tools and i think excel should be
promoted more by sharing knowledge/jobs.


Thanks and Regards,
Pankaj




On Mon, Jun 18, 2012 at 4:08 PM, Mangesh Vimay wrote:

> Hi Friends,
>
> I am agree with Yogananda because many people are spending their time
> here to learn excel concepts with the intention to get the job and hence if
> someone is providing such nice opportunities then I think it is good.
> Moreover, only related job posting should be there (with excel, access
> only).
>
> Thanks.
>
>
>
> On Sun, Jun 17, 2012 at 8:04 AM, Prince Ever Increasing Abundance King of
> Exceeding Overflowing Prosperity  wrote:
>
>>  I have no intent of doing a job posting.  Asking for others.
>>  Where should job postings be done.  I am in British Colulmbia Canada.
>> What should I do if I want to change to change my email receiving address
>> for this group?
>>
>> Thank you.
>> David
>>
>> --
>> Date: Sat, 16 Jun 2012 08:14:00 -0700
>> From: jainayus...@gmail.com
>> To: excel-macros@googlegroups.com
>> Subject: $$Excel-Macros$$ Re: MIS executive
>>
>>
>> Hi Yogananda,
>>
>> Please note that Job posting is allowed in this forum. Please do not post
>> any jobs going forward.
>>
>> Thanks.
>>
>>
>> On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote:
>>
>> Hi,
>>
>> We have a opening for MIS - Executive in Bangalore location.  Do call my
>> below number on next coming monday.  Its Urgent requirement
>>
>>
>>
>> Regards
>> Yogananda Muthaiah
>> Ph : 973 123 7267
>>
>>
>> --
>> 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
>>
>
>
>
> --
> With regards,
>
> MaNgEsH
>
>  --
> 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
>



-

Re: $$Excel-Macros$$ Double click Bar Charts

[pankaj gmail account]

Thanks for quick response.

Please find attached data.

I donot want to use pivot table for this.
this is just a new imagination can we do this in excel. Linked Drill down
Charts.


Thanks and regards,
Pankaj Michael

On Tue, May 22, 2012 at 7:42 AM, ashish koul  wrote:

> can you share the sample data
>
>
> On Tue, May 22, 2012 at 7:40 AM, pankaj gmail account <
> pankaji...@gmail.com> wrote:
>
>> Dear Gurus,
>>
>> I want to create a chart with click event or any other option.
>>
>> Please suggest :-
>>
>> like if i have a bar/pie chart with five products with some sale so i
>> gets five product bars.
>> what i wants is when i click on product 2 bar i should get/open product 2
>> sales charts linked to it go on further levels also.
>>
>>  when i click on product 3 bar i should get/open product 3 sales charts
>> linked to it go on further levels also.
>>
>> Thanks and Regards,
>>
>> --
>> Pankaj Kumar
>>
>> --
>> 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*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/* <http://www.accessvbamacros.com/>
>
>
> P Before printing, think about the environment.
>
>
>  --
> 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
>



-- 
Pankaj Kumar

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

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

$$Excel-Macros$$ Double click Bar Charts

[pankaj gmail account]

Dear Gurus,

I want to create a chart with click event or any other option.

Please suggest :-

like if i have a bar/pie chart with five products with some sale so i gets
five product bars.
what i wants is when i click on product 2 bar i should get/open product 2
sales charts linked to it go on further levels also.

 when i click on product 3 bar i should get/open product 3 sales charts
linked to it go on further levels also.

Thanks and Regards,

-- 
Pankaj Kumar

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

Re: $$Excel-Macros$$ Download Word Macro Tutorial

[pankaj gmail account]

This link is also not working.

Pankaj

On Sun, Oct 23, 2011 at 8:01 PM, ashish koul  wrote:

> http://www.susandoreydesigns.com/software/WordVBATechniques.pdf
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Pankaj Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Download Access Tutorial

[pankaj gmail account]

link is not working

Pankaj

On Sun, Oct 23, 2011 at 9:24 PM, ashish koul  wrote:

>
> http://www.susandoreydesigns.com/software/AccessTechniques.pdf
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Pankaj Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Automatic Birth Day Outlook Mail Message

[pankaj gmail account]

Thanks ashish for reply

but this is through pressing button i want whenever birth date matches
system date it automatically forward the mail.

image is a Outlook Template Data will be inserted between that.

Thanks Again
Pankaj

On Mon, Aug 22, 2011 at 9:22 PM, ashish koul  wrote:

> http://akoul.blogspot.com/2011/07/sending-birthday-images-messages-to.html
>
> try the attachment
>
>
> On Mon, Aug 22, 2011 at 8:21 PM, dguillett1  wrote:
>
>>   Sounds a bit like “homework”
>>
>>  *From:* pankaj gmail account 
>> *Sent:* Sunday, August 21, 2011 11:01 PM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Automatic Birth Day Outlook Mail Message
>>
>>  Dear Group,
>>
>>
>> Can you people help me I want to create a Excel based Birthday Mail which
>> will automatically forward to the User whose birthday is and CC to his
>> upervisor with his name and OFT template image or a image.
>>
>> in Excel :- Name --- Date of Birth-- Supervisor mail id --- User mail Id
>>
>> when date of birth matches todays date it automatically send Image and his
>> name saying Happy Birthday through Outlook. Version 2007.
>>
>> Thanks to Group in Advance for Helping.
>> --
>> Pankaj Kumar
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> http://akoul.posterous.com/
>  *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
> P Before printing, think about the environment.
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Pankaj Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Re: The Most Accurate PDF-to-Excel Converter

[pankaj gmail account]

Please forward same to me also

Thanks Pankaj

2011/8/20 Venkat CV 

> You are welcome
>
> *Best Regards,*
> *Venkat *
> *Chennai*
> *
> *
> On Sat, Aug 20, 2011 at 3:52 PM, bé trần văn wrote:
>
>> Thank venkat1@gmail.com has provided me the software conversion from
>> PDF to Excel, very useful information.
>>
>> Thank you very much.
>>
>
>
>
> --
> *
> *
> *
> *
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Pankaj Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Automatic Birth Day Outlook Mail Message

[pankaj gmail account]

Dear Group,


Can you people help me I want to create a Excel based Birthday Mail which
will automatically forward to the User whose birthday is and CC to his
upervisor with his name and OFT template image or a image.

in Excel :- Name --- Date of Birth-- Supervisor mail id --- User mail Id

when date of birth matches todays date it automatically send Image and his
name saying Happy Birthday through Outlook. Version 2007.

Thanks to Group in Advance for Helping.
-- 
Pankaj Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ pipe (|) delimited text file filtered country wise

[pankaj gmail account]

Please help

Pankaj

On Sun, Sep 19, 2010 at 5:25 PM, pankaj gmail account
wrote:

>
> Hi to the forum,
>
> Please help me it is  very urgent for me
> i have a text file which is (|) delimited in which it contains all
> countries files, what i want to do is to create country wise files in
> .TXT same format.
> so  there will be
> singapore.txt
> india.txt
> etc.
>
> i tried but i was not able to complete what i did i imported this file in
> excel sheet after then was able to export but i was not able to create
> country wise multiple text files
>
>
> file is attached please view it and give response
> --
> Pankaj Kumar
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Pankaj Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ pipe (|) delimited text file filtered country wise

[pankaj gmail account]

Hi to the forum,

Please help me it is  very urgent for me
i have a text file which is (|) delimited in which it contains all countries
files, what i want to do is to create country wise files in .TXT same
format.
so  there will be
singapore.txt
india.txt
etc.

i tried but i was not able to complete what i did i imported this file in
excel sheet after then was able to export but i was not able to create
country wise multiple text files


file is attached please view it and give response
-- 
Pankaj Kumar

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
DETAIL|3|2010-08-31|1|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support 
Team|GT0A20|Company|Company/Employee
 Pseudo Payment Code|Employee|Company/Employee Pseudo Payment 
Code|CACODE|DR|+500.500.|SGD|702|1.|SGD|702|2010-08-26|Cash|1|2010-08-26|5|
DETAIL|3|2010-08-31|2|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support 
Team|GT0A20|Company|Company/Employee
 Pseudo Payment Code|Employee|Company/Employee Pseudo Payment 
Code|CACODE|DR|+500.500.|SGD|702|1.|SGD|702|2010-08-26|Cash|1|2010-08-26|6|
DETAIL|3|2010-08-31|3|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support 
Team|GT0A20|8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC
 - Report 1 with cash advance|N|N|N|3630.|3630.|Carrier Singapore 
Expense Policy||Asia|Singapore|CSL|Support 
Team|GT0A20||Yes60|REG|Airfare|2010-08-13|SGD|1.|M|N|AGM
 London||British Airways|N|RAsia|Singapore|CSL|Support 
Team|GT0A20|||SG&A|SG0.|1800.|1800.|1800.|1800.|COPD|Company
 Paid|||SG||HOME|||Company|Company/Employee Pseudo 
Payment Code|Company Paid|Company 
Paid|50500010|DR|+1800.|502|||60|100.|Asia|Singapore|CSL|Support
 Team|GT0A20|
DETAIL|3|2010-08-31|4|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support 
Team|GT0A20|8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC
 - Report 1 with cash advance|N|N|N|3630.|3630.|Carrier Singapore 
Expense Policy||Asia|Singapore|CSL|Support 
Team|GT0A20||Yes62|CHD|Hotel|2010-08-15|GBP|2.2000|M|N|AGM 
in London||Hilton London|N|RAsia|Singapore|CSL|Support 
Team|GT0A20|||SG&A|GB0.|440.|200.|440.|440.|CASH|Cash|||GB|GB-GTL|FRGN|||Company|Company/Employee
 Pseudo Payment Code|Employee|Company/Employee Pseudo Payment 
Code|50500010|DR|+440.|497|||62|100.|Asia|Singapore|CSL|Support
 Team|GT0A20|
DETAIL|3|2010-08-31|5|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support 
Team|GT0A20|8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC
 - Report 1 with cash advance|N|N|N|3630.|3630.|Carrier Singapore 
Expense Policy||Asia|Singapore|CSL|Support 
Team|GT0A20||Yes62|CHD|Hotel|2010-08-15|GBP|2.2000|M|N|AGM 
in London||Hilton London|N|RAsia|Singapore|CSL|Support 
Team|GT0A20|||SG&A|GB0.|440.|200.|440.|440.|CASH|Cash|||GB|GB-GTL|FRGN|||Employee|Company/Employee
 Pseudo Payment Code|Company|Company/Employee Pseudo Payment 
Code|CACODE|CR|-390.|503|||500.|SGD|702|1.|SGD|702|2010-08-26|Cash|2|2010-08-26|5|
DETAIL|3|2010-08-31|6|12314|LOKE|CHEE YONG| ||Asia|Singapore|CSL|Support 
Team|GT0A20|8D0303E9F7E7461197BC|21|SINGAPORE|SGD|SINGAPORE|2010-08-26|2010-08-26|2010-08-26|LYC