from:"jmothilal"

On Fri, Jun 29, 2012 at 9:19 PM, ashish koul koul.ash...@gmail.com wrote:

 can you attach the sample file


 On Fri, Jun 29, 2012 at 9:18 PM, jmothilal gjmothi...@gmail.com wrote:

 Dear any one

 I want 3 cell values in 1 cell line by line

 Thanks in advance

 like

  MOTHILAL
 NAVEEN
 RAJA MOTHILAL NAVEEN RAJA

 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

MERGE 1 CELL.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

i am using office 2003,  are u send sample worksheet
Thanks
Mothilal

On Fri, Jun 29, 2012 at 9:46 PM, Aditya Tyagi ymca.adi...@gmail.com wrote:

 =B1CHAR(10)C1 CHAR(10)D1 try this


 On Sat, Jun 30, 2012 at 5:00 AM, ashish koul koul.ash...@gmail.comwrote:

 Sub breaktext()
 For i = 1 To Sheets(1).Range(a65356).End(xlUp).Row
 splitdata = Split(Sheets(1).Range(a  i).Value, Chr(10))
 Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value =
 splitdata
 Next
 End Sub


 On Fri, Jun 29, 2012 at 9:21 PM, jmothilal gjmothi...@gmail.com wrote:



 On Fri, Jun 29, 2012 at 9:19 PM, ashish koul koul.ash...@gmail.comwrote:

 can you attach the sample file


 On Fri, Jun 29, 2012 at 9:18 PM, jmothilal gjmothi...@gmail.comwrote:

 Dear any one

 I want 3 cell values in 1 cell line by line

 Thanks in advance

 like

  MOTHILAL
 NAVEEN
 RAJA MOTHILAL NAVEEN RAJA

 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


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




 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


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

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

Thanks so much its working .

Thanks with Mothilal.J


On Fri, Jun 29, 2012 at 9:55 PM, Aditya Tyagi ymca.adi...@gmail.com wrote:



 On Sat, Jun 30, 2012 at 5:21 AM, jmothilal gjmothi...@gmail.com wrote:

 i am using office 2003,  are u send sample worksheet
 Thanks
 Mothilal


 On Fri, Jun 29, 2012 at 9:46 PM, Aditya Tyagi ymca.adi...@gmail.comwrote:

 =B1CHAR(10)C1 CHAR(10)D1 try this


 On Sat, Jun 30, 2012 at 5:00 AM, ashish koul koul.ash...@gmail.comwrote:

 Sub breaktext()
 For i = 1 To Sheets(1).Range(a65356).End(xlUp).Row
 splitdata = Split(Sheets(1).Range(a  i).Value, Chr(10))
 Sheets(1).Range(Cells(i, 2), Cells(i, 2 + UBound(splitdata))).Value =
 splitdata
 Next
 End Sub


 On Fri, Jun 29, 2012 at 9:21 PM, jmothilal gjmothi...@gmail.comwrote:



 On Fri, Jun 29, 2012 at 9:19 PM, ashish koul koul.ash...@gmail.comwrote:

 can you attach the sample file


 On Fri, Jun 29, 2012 at 9:18 PM, jmothilal gjmothi...@gmail.comwrote:

 Dear any one

 I want 3 cell values in 1 cell line by line

 Thanks in advance

 like

  MOTHILAL
 NAVEEN
 RAJA MOTHILAL NAVEEN RAJA

 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan
 Complex :Otteri, Vellore-2*


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




 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


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

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

Dear NOORAIN ANSARI sir

Thanks for sending function coding.

Mothilal.J

On Sat, Jun 30, 2012 at 8:35 AM, ╰» ℓαℓιт мσαнη mohan.pande...@gmail.comwrote:

Hi,

Try this also

=A1 B1 C1

Regards,
Lalit Mohan

On Fri, Jun 29, 2012 at 11:29 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:

Dear Moti Lal,

You can use below UDF for dynamically

Function combine_cells(rng As Excel.Range) As String
Dim cell As Excel.Range
For Each cell In rng.Cells
combine_cells = combine_cells + CStr(cell.Value) Chr(10)
Next cell
End Function

see attached sheet
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

On Fri, Jun 29, 2012 at 9:18 PM, jmothilal gjmothi...@gmail.com wrote:

Dear any one

I want 3 cell values in 1 cell line by line

Thanks in advance

MOTHILAL
NAVEEN
RAJA MOTHILAL NAVEEN RAJA

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

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

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

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

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

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security
measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.

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

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

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

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

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don'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

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

--
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: Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

2012-06-27 Thread jmothilal

use Text(a1,d)

Mothilal

On Wed, Jun 27, 2012 at 12:52 PM, Lalit_Mohan mohan.pande...@gmail.comwrote:

 Hi,

 Try this revised formula as my last post contain some error
 Evaluate(=Text(Day(  Sheets(Sheet1).Cells(count, BarDate).Text 
 ), ))

 Hope it helps you

 Regards,
 Lalit Mohan

 On Wednesday, 27 June 2012 11:59:36 UTC+5:30, Lalit_Mohan wrote:

 Hi,

 Try this.

 Evaluate(=Text(Day(Sheets(**Sheet1).Cells(count, BarDate).value),
 ))

 Regards,
 Lalit Mohan

 On Wednesday, 27 June 2012 10:13:06 UTC+5:30, tangledweb wrote:

 I believe this is the equivalent of your second new solution?
 Evaluate(=Text(Day(Sheets(**RawData).Cells(count, BarDate).Text),
 ))
 I tried it with and without the .text part.   Both cases returned error
 2015 though I have a 4 digit year and the form is month/day/year which is
 supposed to be what it wants.

 On Tuesday, June 26, 2012 9:30:29 PM UTC-7, Lalit_Mohan wrote:

  Hi,

 You can try this
 Evaluate(=TEXT(DAY(A1),**))

 Hope it helps you

  Regards,
 Lalit Mohan

 On Wednesday, 27 June 2012 09:45:46 UTC+5:30, tangledweb wrote:

 This seems to be designed to work directly in excel instead of a VB
 program.  I tried to use it without the = but it said the function TEXT 
 was
 not defined.
 I need a method that works in a VB program with the value 6/26/2012
 stored in the array previously listed.

 On Tuesday, June 26, 2012 9:01:08 PM UTC-7, Lalit_Mohan wrote:

 Hi,

 You can try this
 =TEXT(DAY(A1),)

 Hope it helps you

 Regards,
 Lalit Mohan

 On Wednesday, 27 June 2012 09:17:02 UTC+5:30, tangledweb wrote:

 If I already have Sheets(RawData).Cells(count, BarDate).Text having
 a value like 6/26/2012 is there a way to get the day of the week as a
 number or string for that date that does not require splitting it into 
 its
 parts and feeding them to some function?  If the latter the .net 
 examples I
 found for that did not make sense to me so how is it done?

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






-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

-- 
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$$ age month days calculations - Reg

2012-06-24 Thread jmothilal

Thanks noorain babu..!!  sir

this command is very useful for me, Thanks so much for u.



On Sat, Jun 23, 2012 at 12:08 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:

 Dear Mothilal,

 If you don't want in Text Format Please use

 =DATEDIF(D2,E2,d) select formula cell, press ctrl+1 and type in
 custom yy mm dd

 See attached sheet
 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.com

 On Fri, Jun 22, 2012 at 12:55 PM, jmothilal gjmothi...@gmail.com wrote:
 
 
  Dear any one
 
  i want find age month days calculations in between two days. pls help me
 
 
 
  thanks with
 
  --
 
  J.Mothilal : Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2
 
 
  --
  -- 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





-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

-- 
-- 
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$$ age month days calculations - Reg

2012-06-22 Thread jmothilal

Thanks

On Fri, Jun 22, 2012 at 1:04 PM, Excel Vba excelvba.lear...@gmail.comwrote:

 Hi J. Mothilal**,

 Try datedif funtions.

 =datedif(A1,B1,Y) for years
 =datedif(A1,B1,ym) for months
 =datedif(A1,B1,md) for days

 whereas in cell A1, type oldest date or date from which you want to
 calculate,
 and in cell B1, type the newest date or date till which you want to
 calculate.



 On Fri, Jun 22, 2012 at 12:55 PM, jmothilal gjmothi...@gmail.com wrote:


 Dear any one

 i want find age month days calculations in between two days. pls help me



 thanks with

 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

2012-05-30 Thread jmothilal

Sir , pls send me  my email id   jmothi...@yahoo.com


Thanks with
Mothilal.J



On Wed, May 30, 2012 at 8:25 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Hi Joseph,aruna,lupinskip and anjali,

 I have send VBA Ebook 2007(O'Rellay) on your email ID.

 Pls check and confirm.

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


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








 --
 Thanks  regards,
 Noorain Ansari
 www.noorainansari.com
 www.excelmacroworld.blogspot.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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

-- 
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: $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for accounting entries

2012-04-27 Thread jmothilal

file not attached

On Fri, Apr 27, 2012 at 11:09 PM, who dlanm...@att.net wrote:



 =SUMIF($G$7:$G$135,$G$142,I7:I135) - can copy this across. Will have to
 change to copy down =SUMIF($G$7:$G$135,G142,$I$7:$I$135)


 On Friday, April 27, 2012 7:43:04 AM UTC-7, Vijayendra wrote:

 Dear All,

 I need one formula which will using for accounting entries, I tried
 sumproduct but it doesnt work. I have attached is the same file.

 Regards,
 Vijayendra
 94491 67631


 On Friday, April 27, 2012 7:43:04 AM UTC-7, Vijayendra wrote:

 Dear All,

 I need one formula which will using for accounting entries, I tried
 sumproduct but it doesnt work. I have attached is the same file.

 Regards,
 Vijayendra
 94491 67631

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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

Re: $$Excel-Macros$$ Stock position - Reg

I want to find different items sums

   PURCHASE / SALES ITEM QTY STOCK  P LG DVD WRITER 4 4  P LG DVD WRITER 5 9
S LG DVD WRITER 1 8  P LG DVD WRITER 1 9  P LG DVD WRITER 10 19  S LG DVD
WRITER 4 15  p 512 MB DDR RAM 1 1  p 18.5 Monitor 1 1  p 500 GB Hard disk 1
1  S 512 MB DDR RAM 1 0  S 18.5 Monitor 1 0  S 500 GB Hard disk 1 0

Thanks with

On Sun, Apr 15, 2012 at 12:11 PM, Maries talk2mar...@gmail.com wrote:

 Hi,

 Find the attachment...



 On Sun, Apr 15, 2012 at 10:27 AM, jmothilal gjmothi...@gmail.com wrote:


 PURCHASE / SALES ITEM QTY STOCK
 P LG DVD WRITER 1 1
 P LG DVD WRITER 5 6
 S LG DVD WRITER 1 5
 P LG DVD WRITER 1 6
 P LG DVD WRITER 10 16
 S LG DVD WRITER 4 12






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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

Re: $$Excel-Macros$$ Stock position - Reg

Thanks it working . also i find this formula

=SUMPRODUCT(--(($A$2:A2=P)*($B$2:$B2=B2))*$C$2:C2)-SUMPRODUCT(--(($A$2:A2=S)*($B$2:$B2=B2))*$C$2:C2)



On Sun, Apr 15, 2012 at 2:16 PM, Haseeb A haseeb.avarak...@gmail.comwrote:

 Hello Mothilal,

 See the attached. if you are on XL 2007 or later use SUMIFS

 ___
 HTH, Haseeb

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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

Re: $$Excel-Macros$$ Stock position - Reg

Thanks i am updating

Mothilal

On Sun, Apr 15, 2012 at 2:24 PM, Haseeb A haseeb.avarak...@gmail.comwrote:

 You can get this with just one SUMPRODUCT,

 =SUMPRODUCT((B$2:B2=B2)*(A$2:A2={P,S}),C$2:C2*{1,-1})

 Which is on the file in the last reply.


 ___
 HTH, Haseeb

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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

Re: $$Excel-Macros$$ Stock position - Reg

Difference items  need one more conditions

Mothilal

On Sun, Apr 15, 2012 at 4:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote:

 ** **

 Stock = Opening Stock + Purchase – Sales , and there is no opening stock.
 So P-S

 =SUMIF(A2:D7,P,C2:C7)-SUMIF(A2:D7,S,C2:C7)

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *jmothilal
 *Sent:* Apr/Sun/2012 02:31
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Stock position - Reg

 ** **

 Thanks i am updating

 Mothilal

 On Sun, Apr 15, 2012 at 2:24 PM, Haseeb A haseeb.avarak...@gmail.com
 wrote:

 You can get this with just one SUMPRODUCT,

 =SUMPRODUCT((B$2:B2=B2)*(A$2:A2={P,S}),C$2:C2*{1,-1})

 Which is on the file in the last reply.



 ___
 HTH, Haseeb

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




 -- 

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*

 ** **

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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

Re: $$Excel-Macros$$ printing doubt

2012-03-28 Thread jmothilal

Thanks to Noorain Ansari, , Abhishek Jain


Mothilal

On Wed, Mar 28, 2012 at 11:09 AM, Abhishek Jain abhishek@gmail.comwrote:

 Use below code for printing all sheets in a workbook -

 Option Explicit

 Sub PrintallSheets()
 Dim ws As Worksheet
 For Each ws In ActiveWorkbook.Worksheets
 ws.PrintOut
 Next ws
 End Sub


 On Wed, Mar 28, 2012 at 9:28 AM, jmothilal gjmothi...@gmail.com wrote:

 Dear Sir,

 How can i print all sheets ?



 Thanks with



 Mothilal.J


 On Tue, Mar 27, 2012 at 12:54 PM, NOORAIN ANSARI 
 noorain.ans...@gmail.com wrote:

 Dear Shankar,

 You can also use..

 Sub Print_setup()
 Application.Dialogs(xlDialogPrint).Show
 End Sub


 On Tue, Mar 27, 2012 at 12:23 PM, Shankar Bheema shankar.n...@gmail.com
  wrote:

 Dear experts

 for a command button of an userform for Printing of sheets purpose I am
 using code as

 sheets(sheet1).printout

 whereas, i need to print  3rd page of sheet1 everytime, so what change
 is required in the above code to get only 3rd page.

 regards
 shankar sb

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




 --
 Thanks  regards,
 Noorain Ansari
  ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/*
 *http://excelmacroworld.blogspot.com/*http://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




 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

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

1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-15 Thread jmothilal

Congratulation Noorain.


Mothilal.J
Universal Computer\
Vellore -2





On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey dilipan...@gmail.com wrote:

 Congratulations Noorain

 Keep up the good work and keep helping :)

 Regards,
 DILIPandey


 On Thu, Mar 15, 2012 at 11:31 AM, Abhishek Jain abhishek@gmail.comwrote:

 Many congratulations Noorain bro!

 Keep up the good work and keep helping us mere mortals in excelling our
 lives. :)

 God bless


 On Thu, Mar 15, 2012 at 11:23 AM, Maries talk2mar...@gmail.com wrote:

 Congrats Brother..


 On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee 
 chatterjee.kolk...@gmail.com wrote:

 Congratulation for you achievement. Hoping for a good luck.

 sanjib

 On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.comwrote:

  Hello Everyone,

 Noorain Ansari has been selected as 'Most Helpful Member' for the
 month of Feb'12
 He has posted 156 posts in Feb'12 and helped many people through his
 expertise. He has been consistent contributor to this excel forum but has
 acheived this recognition for third time.

 *About Noorain Ansari :*
 [image: noorain.jpg]

 Noorain is a great poet and keep sharing his thoughts on different
 topics throgh cool poems. Professionally, he is a Excel aficionado and
 presently working as senior business analyst in One97 Communication Ltd. 
 He
 is a MS excel - vba expert and keep sharing his thoughts with this forum.
 You can follow his blogs for Excel knowledge and cool poems :
 www.excel-macro.blogspot.com  www.noorain-ansari.blogspot.com

 *Noorain, Many thanks for all your great support to group. Keep it up*

 *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it
 up !!
 **
 *Keep posting.

 Regards
 Ayush Jain
 Group Manager
 Microsoft MVP

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

 1) Use concise, accurate thread titles. Poor thread titles, like
 Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
 Advice will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum
 in signatures are prohibited.

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


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




 --
 -

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

Re: $$Excel-Macros$$ Help me with a macro

2011-11-27 Thread jmothilal

Dear son


Here with i attached excel file using sumif command.


Mothilal

On Sat, Nov 26, 2011 at 8:23 PM, son nguyen sonnguye...@gmail.com wrote:

 Dear all,


 I have problem of calculating sheet.Detail as sheet attached.
 I want to have a macro to sum value within qty, and downtime column then
 delete products are duplicated within each machine.

 I look foward to hear your help asap


 Best Regards
 Son

  --
 FORUM RULES (934+ 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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

-- 
FORUM RULES (934+ 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


Copy of Xl042.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ exls

Thanks for sending shortcut keys.

Mothilal

On Thu, Nov 24, 2011 at 2:17 PM, mangesh bavalekar bavalek...@gmail.comwrote:


  --
 FORUM RULES (934+ 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




-- 

*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*

-- 
FORUM RULES (934+ 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

Re: $$Excel-Macros$$ Excel learning Institute

Pls send the that training material for me.

Thanks sir.



On Fri, Nov 25, 2011 at 11:02 AM, krishnanm2...@gmail.com wrote:

 Hi Noorian- appreciate if you can send it to the entire group... It will
 be very helpful..

 Thanks in advance

 Warm Regards!
 Sent on my BlackBerry® from Vodafone
 --
 *From: * smitha.kumari smitha.kum...@speridian.com
 *Sender: * excel-macros@googlegroups.com
 *Date: *Fri, 25 Nov 2011 10:58:29 +0530
 *To: *excel-macros@googlegroups.com
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *RE: $$Excel-Macros$$ Excel learning Institute

  Hi Noorain,

 ** **

 Expecting the Training material at the earliest.

 ** **

 Regards

 Smitha

 *From:* smitha.kumari [mailto:smitha.kum...@speridian.com]
 *Sent:* Thursday, November 24, 2011 1:32 PM
 *To:* 'NOORAIN ANSARI'
 *Subject:* RE: $$Excel-Macros$$ Excel learning Institute

 ** **

 Thanks a lot Noorain.

 ** **

 My mail ID is smitha...@gmail.com or smitha.kum...@speridian.com

 ** **

 Regards

 Smitha/ Senior Finance Executive

 [image: Speridian%20Logo]

 World Class Solutions to Power Global Businesses

 Office: 0471-2527525/2700526

 smitha.kum...@speridian.com

 ** **

 *From:* NOORAIN ANSARI [mailto:noorain.ans...@gmail.com]
 *Sent:* Thursday, November 24, 2011 1:25 PM
 *To:* smitha.kumari
 *Subject:* Re: $$Excel-Macros$$ Excel learning Institute

 ** **

 Sorry, Smitha,

 I am not giving training online.
 but I will send you some training material thourgh Email.
 It will help you to learn Advance excel..

 -- 

 Thanks  regards,

 Noorain Ansari

 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 

 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
 

 On Thu, Nov 24, 2011 at 1:15 PM, smitha.kumari 
 smitha.kum...@speridian.com wrote:

 I am in Trivandrum. Me too in search of the same. 

 Please suggest me one possible way?

  

 Is Noorain giving any online training?

  

 Regards

 Smitha/ Senior Finance Executive

 [image: Speridian%20Logo]

 World Class Solutions to Power Global Businesses

 Office: 0471-2527525/2700526

 smitha.kum...@speridian.com

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *seraj.ala...@gmail.com
 *Sent:* Thursday, November 24, 2011 12:39 PM


 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Excel learning Institute

  

 Hey buddy u can contact to Noorain Ansari the member of this group he is
 giving training of Excel, VBA, Access on saturdy n sunday in Noida sec- 2
 Contact no - 9911176564
 Thanks - seraj 

 Sent from BlackBerry® on Airtel
  --

 *From: *garwads...@gmail.com 

 *Sender: *excel-macros@googlegroups.com 

 *Date: *Thu, 24 Nov 2011 07:00:14 +

 *To: *excel-macros@googlegroups.com

 *ReplyTo: *excel-macros@googlegroups.com 

 *Subject: *Re: $$Excel-Macros$$ Excel learning Institute

  

 Guys,
 Any info in Bangalore ?
 Cheers
 Rahul.

 Sent from BlackBerry® on Airtel
  --

 *From: *krishnanm2...@gmail.com 

 *Sender: *excel-macros@googlegroups.com 

 *Date: *Thu, 24 Nov 2011 06:59:28 +

 *To: *excel-macros@googlegroups.com

 *ReplyTo: *excel-macros@googlegroups.com 

 *Subject: *Re: $$Excel-Macros$$ Excel learning Institute

  

 Sorry buddy... I know tutors in Mumbai..

 Sent on my BlackBerry® from Vodafone
  --

 *From: *Ankit Agrawal ankit.agrawal...@gmail.com 

 *Sender: *excel-macros@googlegroups.com 

 *Date: *Thu, 24 Nov 2011 12:20:15 +0530

 *To: *excel-macros@googlegroups.com

 *ReplyTo: *excel-macros@googlegroups.com 

 *Subject: *Re: $$Excel-Macros$$ Excel learning Institute

  

 I am in Delhi(Near Laxmi Nagar  Noida)

 On Thu, Nov 24, 2011 at 12:22 PM, krishnanm2...@gmail.com wrote:

 Where are you located??

 Sent on my BlackBerry® from Vodafone
  --

 *From: *Ankit Agrawal ankit.agrawal...@gmail.com 

 *Sender: *excel-macros@googlegroups.com 

 *Date: *Thu, 24 Nov 2011 12:16:11 +0530

 *To: *excel-macrosexcel-macros@googlegroups.com

 *ReplyTo: *excel-macros@googlegroups.com 

 *Subject: *$$Excel-Macros$$ Excel learning Institute

  

 Dear All,

 Plz tell me any good institute for excel where I can learn advance excel.

 Regards,
 Ankit

 --
 FORUM RULES (934+ 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

Re: $$Excel-Macros$$ Excel learning Institute

Sir , if possible send me also, Thanks in advance.

Mothilal.j

On Fri, Nov 25, 2011 at 10:58 AM, smitha.kumari smitha.kum...@speridian.com
 wrote:

  Hi Noorain,

 ** **

 Expecting the Training material at the earliest.

 ** **

 Regards

 Smitha

 *From:* smitha.kumari [mailto:smitha.kum...@speridian.com]
 *Sent:* Thursday, November 24, 2011 1:32 PM
 *To:* 'NOORAIN ANSARI'
 *Subject:* RE: $$Excel-Macros$$ Excel learning Institute

 ** **

 Thanks a lot Noorain.

 ** **

 My mail ID is smitha...@gmail.com or smitha.kum...@speridian.com

 ** **

 Regards

 Smitha/ Senior Finance Executive

 [image: Speridian%20Logo]

 World Class Solutions to Power Global Businesses

 Office: 0471-2527525/2700526

 smitha.kum...@speridian.com

 ** **

 *From:* NOORAIN ANSARI [mailto:noorain.ans...@gmail.com]
 *Sent:* Thursday, November 24, 2011 1:25 PM
 *To:* smitha.kumari

 *Subject:* Re: $$Excel-Macros$$ Excel learning Institute

  ** **

 Sorry, Smitha,

 I am not giving training online.
 but I will send you some training material thourgh Email.
 It will help you to learn Advance excel..

 -- 

 Thanks  regards,

 Noorain Ansari

 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 

 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
 

 On Thu, Nov 24, 2011 at 1:15 PM, smitha.kumari 
 smitha.kum...@speridian.com wrote:

 I am in Trivandrum. Me too in search of the same. 

 Please suggest me one possible way?

  

 Is Noorain giving any online training?

  

 Regards

 Smitha/ Senior Finance Executive

 [image: Speridian%20Logo]

 World Class Solutions to Power Global Businesses

 Office: 0471-2527525/2700526

 smitha.kum...@speridian.com

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *seraj.ala...@gmail.com
 *Sent:* Thursday, November 24, 2011 12:39 PM


 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Excel learning Institute

  

 Hey buddy u can contact to Noorain Ansari the member of this group he is
 giving training of Excel, VBA, Access on saturdy n sunday in Noida sec- 2
 Contact no - 9911176564
 Thanks - seraj 

 Sent from BlackBerry® on Airtel
  --

 *From: *garwads...@gmail.com 

 *Sender: *excel-macros@googlegroups.com 

 *Date: *Thu, 24 Nov 2011 07:00:14 +

 *To: *excel-macros@googlegroups.com

 *ReplyTo: *excel-macros@googlegroups.com 

 *Subject: *Re: $$Excel-Macros$$ Excel learning Institute

  

 Guys,
 Any info in Bangalore ?
 Cheers
 Rahul.

 Sent from BlackBerry® on Airtel
  --

 *From: *krishnanm2...@gmail.com 

 *Sender: *excel-macros@googlegroups.com 

 *Date: *Thu, 24 Nov 2011 06:59:28 +

 *To: *excel-macros@googlegroups.com

 *ReplyTo: *excel-macros@googlegroups.com 

 *Subject: *Re: $$Excel-Macros$$ Excel learning Institute

  

 Sorry buddy... I know tutors in Mumbai..

 Sent on my BlackBerry® from Vodafone
  --

 *From: *Ankit Agrawal ankit.agrawal...@gmail.com 

 *Sender: *excel-macros@googlegroups.com 

 *Date: *Thu, 24 Nov 2011 12:20:15 +0530

 *To: *excel-macros@googlegroups.com

 *ReplyTo: *excel-macros@googlegroups.com 

 *Subject: *Re: $$Excel-Macros$$ Excel learning Institute

  

 I am in Delhi(Near Laxmi Nagar  Noida)

 On Thu, Nov 24, 2011 at 12:22 PM, krishnanm2...@gmail.com wrote:

 Where are you located??

 Sent on my BlackBerry® from Vodafone
  --

 *From: *Ankit Agrawal ankit.agrawal...@gmail.com 

 *Sender: *excel-macros@googlegroups.com 

 *Date: *Thu, 24 Nov 2011 12:16:11 +0530

 *To: *excel-macrosexcel-macros@googlegroups.com

 *ReplyTo: *excel-macros@googlegroups.com 

 *Subject: *$$Excel-Macros$$ Excel learning Institute

  

 Dear All,

 Plz tell me any good institute for excel where I can learn advance excel.

 Regards,
 Ankit

 --
 FORUM RULES (934+ 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,

Re: $$Excel-Macros$$ Excel learning Institute

sir  , select read only , see the files

On Thu, Nov 24, 2011 at 9:39 PM, SAGAR KASANGOTTUWAR 
sagarkasangottu...@gmail.com wrote:

 Dear,

 I need password for those files.

 Thanks.
 Sagar


 On Thu, Nov 24, 2011 at 4:50 PM, Surbhi Agarwal 
 surbhi.agarwal0...@gmail.com wrote:

 Hi,

 These files need password. Please tell me the password.

 Thanx
 Surbhi

 On Thu, Nov 24, 2011 at 4:18 PM, jmothilal gjmothi...@gmail.com wrote:

 Herewith i attache 42 excel files. its for beginners.

 Thanks with

 Mothilal.J


 On Thu, Nov 24, 2011 at 2:37 PM, krishnanm2...@gmail.com wrote:

 **
 Andheri east


 Sent on my BlackBerry® from Vodafone
 --
 *From: * mangesh bavalekar bavalek...@gmail.com
 *Sender: * excel-macros@googlegroups.com
 *Date: *Thu, 24 Nov 2011 14:16:44 +0530
 *To: *excel-macros@googlegroups.com
 *ReplyTo: * excel-macros@googlegroups.com
 *Subject: *Re: $$Excel-Macros$$ Excel learning Institute

  where I can learn advance excel.im mumbai ?




 Mangesh V. B.


  --
 FORUM RULES (934+ 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 (934+ 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




 --

 *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
 :Otteri, Vellore-2*


  --
 FORUM RULES (934+ 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 (934+ 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 (934+ 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

Re: $$Excel-Macros$$ Excel learning Institute