date:20111129

Hi,

 

PFA the expense sheet and suggest a formula to solve the problem as
mentioned in the attachment.

 

Regards

Smitha 

 

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


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

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread Manish Pandey

An easy solution would be Sumif Function. See attached.


Regards,
Manish

On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari
smitha.kum...@speridian.comwrote:

  Hi,

 ** **

 PFA the expense sheet and suggest a formula to solve the problem as
 mentioned in the attachment.

 ** **

 Regards

 Smitha 

 ** **

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


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

RE: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

2011-11-29 Thread smitha

Thanks Manish

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manish Pandey
Sent: Tuesday, November 29, 2011 2:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a
particular criteria

An easy solution would be Sumif Function. See attached. 

Regards,

Manish

On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari smitha.kum...@speridian.com
wrote:

Hi,

PFA the expense sheet and suggest a formula to solve the problem as
mentioned in the attachment.

Regards

Smitha 

-- 
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) 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$$ Formula to sum a range of cells satisfying a particular criteria

Hi samitha,
Pls find attached file espenses.

On Tue, Nov 29, 2011 at 3:03 PM, smitha smitha.kum...@speridian.com wrote:

  Thanks Manish

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Manish Pandey
 *Sent:* Tuesday, November 29, 2011 2:55 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Formula to sum a range of cells
 satisfying a particular criteria

 ** **

 An easy solution would be Sumif Function. See attached. 

  

  

 Regards,

 Manish

 On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari 
 smitha.kum...@speridian.com wrote:

 Hi,

  

 PFA the expense sheet and suggest a formula to solve the problem as
 mentioned in the attachment.

  

 Regards

 Smitha 

  

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


Aivran kumar
Mob:8130906102,E-mail:- aivran...@gmail.com aivran...@gmial.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


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

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

2011-11-29 Thread son nguyen

Hello Mr Sam,

Thank you very much of your help.


Regards
Son

2011/11/28 Sam Mathai Chacko samde...@gmail.com

 Great, so no modifications required for Excel 2010

 The code below works for both 2003 and 2010


 Sub Consolidator()

 Dim rngStart As Range
 Dim varArray As Range


 Application.ScreenUpdating = 0
 Range(F1).CurrentRegion.Clear
 With Cells.Find(What:=Machine, Lookat:=xlWhole,
 searchDirection:=xlNext, After:=Cells(1))
 Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(, -1))
 End With
 On Error Resume Next
 rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = =r[-1]c
 Err.Clear: On Error GoTo -1: On Error GoTo 0
 With Range(F1)
 .Resize(rngStart.Rows.Count + 1, 2).Value =
 rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
 If Val(Application.Version) = 11 Then
 .CurrentRegion.AdvancedFilter Action:=xlFilterInPlace,
 Unique:=True
 .CurrentRegion.SpecialCells(xlCellTypeVisible).Copy
 rngStart.Offset(rngStart.Rows.Count + 1)(1)
 .AutoFilter: .Parent.AutoFilterMode = 0
 .CurrentRegion.Clear
 With rngStart.Offset(rngStart.Rows.Count + 1)(1).CurrentRegion
 .Copy Range(F1): .ClearContents
 End With
 Else

 .CurrentRegion.RemoveDuplicates Columns:=Array(1, 2),
 Header:=xlYes
 End If

 .Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(,
 2).Resize(1, 2).Value
 With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
 .Formula = =SUMPRODUCT(--(  rngStart.Address  =$F2),--(
  rngStart.Offset(, 1).Address  =$G2),  rngStart.Offset(, 2).Address(1,
 0)  )
 .Value = .Value
 End With
 End With
 On Error Resume Next
 rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
 Err.Clear: On Error GoTo -1: On Error GoTo 0
 Application.ScreenUpdating = 1

 End Sub

 Regards,
 Sam Mathai Chacko

   On Mon, Nov 28, 2011 at 6:33 PM, Bé Trần Văn 
 betnmtdongna...@gmail.comwrote:



  2011/11/28 Sam Mathai Chacko samde...@gmail.com

 Son, the macro is written for 2007-10. Will send a modified version,
 but before that, can you confirm the result is correct in 2007-10? If
 not, what is the issue?

 Sam

 On 28/11/2011, son nguyen sonnguye...@gmail.com wrote:
  Hi Mr Sam.
  I wonder this code used for which office as 2003,2007,2010.Because my
  office is 2003 and result  is not to like my desirement.
 
  Hope that you can feed back more to me
 
  Regards
  son
 
  2011/11/27 Sam Mathai Chacko samde...@gmail.com
 
  Here's a macro to get this done
 
  Sub Consolidator()
 
  Dim rngStart As Range
 
  Application.ScreenUpdating = 0
  Range(F1).CurrentRegion.Clear
  With Cells.Find(What:=Machine, Lookat:=xlWhole,
  searchDirection:=xlNext, After:=Cells(1))
  Set rngStart = Range(.Offset(1), .Offset(, 1).End(xlDown).Offset(,
  -1))
  End With
  On Error Resume Next
  rngStart.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = =r[-1]c
  Err.Clear: On Error GoTo -1: On Error GoTo 0
  With Range(F1)
  .Resize(rngStart.Rows.Count + 1, 2).Value =
  rngStart(0).Resize(rngStart.Rows.Count + 1, 2).Value
  .CurrentRegion.RemoveDuplicates Columns:=Array(1, 2),
  Header:=xlYes
  .Offset(, 2).Resize(1, 2).Value = rngStart(0).Offset(,
  2).Resize(1, 2).Value
  With .Offset(1, 2).Resize(.CurrentRegion.Rows.Count - 1, 2)
  .Formula = =SUMPRODUCT(--(  rngStart.Address 
 =$F2),--(
   rngStart.Offset(, 1).Address  =$G2),  rngStart.Offset(,
  2).Address(1,
  0)  )
  .Value = .Value
  End With
  End With
  On Error Resume Next
  rngStart.SpecialCells(xlCellTypeFormulas).ClearContents
  Err.Clear: On Error GoTo -1: On Error GoTo 0
  Application.ScreenUpdating = 1
 
  End Sub
 
  Regards,
 
  Sam Mathai Chacko
 
 
  On Sun, Nov 27, 2011 at 6:40 PM, rajan verma
  rajanverma1...@gmail.comwrote:
 
   Hi
  Please see the attached file.. Pivot table can be used for this ..
 
  Regards
  Rajan
 
   On Sat, Nov 26, 2011 at 8:23 PM, son nguyen
  sonnguye...@gmail.comwrote:
 
  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

$$Excel-Macros$$ PO highest amt

I want to find threee highest amt against 1 po no , while po no enter
dublicate

-- 
Thanks  Regards


Aivran kumar
,E-mail:- aivran...@gmail.com aivran...@gmial.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


po'amt.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Help for stock file

2011-11-29 Thread manhar prajapati

Dear All HI

Please Find attach file for my quary.

it is for stck matter please halp and provide the proper formula so i can
calculate the stock

for more details please refer the stock file.

--

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


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

Re: $$Excel-Macros$$ PO highest amt

Dear Aivi,

Please use this and see attached sheet.

=LARGE(IF($A$2:$A$33=$F$3,$B$2:$B$33,),1)
Press ctrl+shift+Enter

=SUMPRODUCT(LARGE(($A$2:$A$33=$F$3)*($B$2:$B$33),1))
Press ctrl+shift+enter

-
Thanks  regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/


On Tue, Nov 29, 2011 at 3:41 PM, Aivi aivran...@gmail.com wrote:

 I want to find threee highest amt against 1 po no , while po no enter
 dublicate

 --
 Thanks  Regards


 Aivran kumar
 ,E-mail:- aivran...@gmail.com aivran...@gmial.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) 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 po'amt(solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

RE: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

Hi Aivi,

 

Thanks.

 

May I ask you, why + symbol is inserted before sumif ?

 

Regards

Smitha 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aivi
Sent: Tuesday, November 29, 2011 3:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a
particular criteria

 

Hi samitha,

Pls find attached file espenses.

On Tue, Nov 29, 2011 at 3:03 PM, smitha smitha.kum...@speridian.com wrote:

Thanks Manish

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manish Pandey
Sent: Tuesday, November 29, 2011 2:55 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a
particular criteria

 

An easy solution would be Sumif Function. See attached. 

 

 

Regards,

Manish

On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari smitha.kum...@speridian.com
wrote:

Hi,

 

PFA the expense sheet and suggest a formula to solve the problem as
mentioned in the attachment.

 

Regards

Smitha 

 

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


Aivran kumar 
Mob:8130906102,E-mail:- aivran...@gmail.com aivran...@gmial.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

$$Excel-Macros$$ convert row to column or vice versa

Hi,

 

Is there a quick way to convert row to column or vice versa

 

Regards

Smitha 

 

-- 
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$$ PO highest amt

A Lot Thanks Norain.

On Tue, Nov 29, 2011 at 3:54 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Aivi,

 Please use this and see attached sheet.

 =LARGE(IF($A$2:$A$33=$F$3,$B$2:$B$33,),1)
 Press ctrl+shift+Enter

 =SUMPRODUCT(LARGE(($A$2:$A$33=$F$3)*($B$2:$B$33),1))
 Press ctrl+shift+enter

 -
 Thanks  regards,
 Noorain Ansari
  *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
 *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/


 On Tue, Nov 29, 2011 at 3:41 PM, Aivi aivran...@gmail.com wrote:

 I want to find threee highest amt against 1 po no , while po no enter
 dublicate

 --
 Thanks  Regards


 Aivran kumar
 ,E-mail:- aivran...@gmail.com aivran...@gmial.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) 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


Aivran kumar
Mob:8130906102,E-mail:- aivran...@gmail.com aivran...@gmial.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

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

+ symbol is inserted for useing formulas whether u can use = sing

On Tue, Nov 29, 2011 at 4:04 PM, smitha.kumari
smitha.kum...@speridian.comwrote:

  Hi Aivi,

 ** **

 Thanks.

 ** **

 May I ask you, why + symbol is inserted before sumif ?

 ** **

 Regards

 Smitha 

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Aivi
 *Sent:* Tuesday, November 29, 2011 3:24 PM

 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Formula to sum a range of cells
 satisfying a particular criteria

  ** **

 Hi samitha,

 Pls find attached file espenses.

 On Tue, Nov 29, 2011 at 3:03 PM, smitha smitha.kum...@speridian.com
 wrote:

 Thanks Manish

  

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Manish Pandey
 *Sent:* Tuesday, November 29, 2011 2:55 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Formula to sum a range of cells
 satisfying a particular criteria

  

 An easy solution would be Sumif Function. See attached. 

  

  

 Regards,

 Manish

 On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari 
 smitha.kum...@speridian.com wrote:

 Hi,

  

 PFA the expense sheet and suggest a formula to solve the problem as
 mentioned in the attachment.

  

 Regards

 Smitha 

  

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


 Aivran kumar
 Mob:8130906102,E-mail:- aivran...@gmail.com aivran...@gmial.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,

Re: $$Excel-Macros$$ Formula to sum a range of cells satisfying a particular criteria

Hi Samitha,

Please find attached sheet with *DSUM  SUMPRODUCT.*

-
Thanks  regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/

On Tue, Nov 29, 2011 at 2:53 PM, smitha.kumari
smitha.kum...@speridian.comwrote:

  Hi,

 ** **

 PFA the expense sheet and suggest a formula to solve the problem as
 mentioned in the attachment.

 ** **

 Regards

 Smitha 

 ** **

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


Copy of Expenses(With DSUM and SUMPRODUCT).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ convert row to column or vice versa

You can use Transpose function..

On Tue, Nov 29, 2011 at 4:05 PM, smitha.kumari
smitha.kum...@speridian.comwrote:

  Hi,

 ** **

 Is there a quick way to convert row to column or vice versa

 ** **

 Regards

 Smitha 

 ** **

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




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

Re: $$Excel-Macros$$ #value in formula

Hi Smitha,

This is array Function
Press ctrl+shift+enter after F2


-- 
Thanks  regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/

On Tue, Nov 29, 2011 at 5:52 PM, smitha.kumari
smitha.kum...@speridian.comwrote:

  Hi,

 ** **

 Attached is the solved copy of a query by one member of this group.

 ** **

 I tried to understand the formula. But when I place a cursor in the
 formula and releases it, it shows #value?

 ** **

 Why it is like this?

 ** **

 Regards

 Smitha 

 ** **

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

RE: $$Excel-Macros$$ #value in formula

thanks

 

Regards

Smitha/ Senior Finance Executive

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 NOORAIN ANSARI
Sent: Tuesday, November 29, 2011 6:03 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ #value in formula

 

Hi Smitha,

This is array Function
Press ctrl+shift+enter after F2


-- 

Thanks  regards,

Noorain Ansari

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

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

 

On Tue, Nov 29, 2011 at 5:52 PM, smitha.kumari smitha.kum...@speridian.com
wrote:

Hi,

 

Attached is the solved copy of a query by one member of this group.

 

I tried to understand the formula. But when I place a cursor in the formula
and releases it, it shows #value?

 

Why it is like this?

 

Regards

Smitha 

 

-- 
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) 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
image001.jpg

Re: Re: $$Excel-Macros$$ Almost all calculator in one sheet

2011-11-29 Thread nehal sejpal


Dear Ankit,

I not found attachment can you send me the same.

Thanks In Advance,

Nehal A.Sejpal
On Tue, 29 Nov 2011 17:31:43 +0530  wrote



2011/11/28 vijayajith VA 

Thanks ankit.



On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal  wrote:




Hello All,

In our daily life we calculate so many thing  use different calculator. Here 
is one excel file which contain almost all calculator.



Calculate  enjoy !!!


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


�
Thanks for sharing, sheet very useful . 




-- 

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



With Regards,
Nehal A.Sejpal

-- 
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$$ how to open a 2007 excel file in previous version of excel

Save the file to your desktop and right mouse click and select open with. 
This should give you an option to open it with xlm converter. Try that first to 
see if it converts the file. If this opens the file and converts it for you, 
you will need to select the open with and select choose program. This will 
allow you to check the box to always open with after you select xml converter. 
Hope this works... 



Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sanjib Chatterjee 
Sent: Tuesday, November 29, 2011 12:51 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version 
of excel

Thank you experts,

But would the Convert run in Windows 2000?

Thanking you in Advance

Sanjib 



On Mon, Nov 28, 2011 at 9:02 PM, Sam Mathai Chacko samde...@gmail.com wrote:

  For the sake of readers, and for posterity, you CANNOT just change the file 
extension (xlsx to xls) and make it compatible with Excel 2003.

  Regards,
  Sam 



  On Mon, Nov 28, 2011 at 6:58 PM, Bé Trần Văn betnmtdongna...@gmail.com 
wrote:




2011/11/28 Kenil Gala keni...@yahoo.com

Rename the file.
2003 format :  .xls
2007 format :   .xlsx

--- On Mon, 11/28/11, Sanjib Chatterjee 
chatterjee.kolk...@gmail.com wrote:


  From: Sanjib Chatterjee chatterjee.kolk...@gmail.com
  Subject: $$Excel-Macros$$ how to open a 2007 excel file in 
previous version of excel
  To: excel-macros excel-macros@googlegroups.com
  Date: Monday, November 28, 2011, 11:23 AM 



  Dear Members,

  Would you please help regarding How to open a excel file saved on 
2007 format in 2003 format


  Thanking you in Advance

  Sanjib


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


You unzip it and run it FileFormatConverters open File 2007
You

 download the File under the followingLink: 
http://www.mediafire.com/?xatxj4f59m4754y

-- 
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: Re: $$Excel-Macros$$ Almost all calculator in one sheet

Neha, I have already attached the file. Please check my previous post.

Sam

On Tue, Nov 29, 2011 at 5:38 PM, nehal sejpal nehal_c...@rediffmail.comwrote:

Dear Ankit,

I not found attachment can you send me the same.

Thanks In Advance,

Nehal A.Sejpal
On Tue, 29 Nov 2011 17:31:43 +0530 wrote

2011/11/28 vijayajith VA **

Thanks ankit.

On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal ** wrote:

Hello All,

In our daily life we calculate so many thing use different calculator.
Here is one excel file which contain almost all calculator.

Calculate enjoy !!!

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

�
Thanks for sharing, sheet very useful .

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

With Regards,
Nehal A.Sejpal

http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline.htm@Middle?
Follow *Rediff Deal ho
jaye!http://track.rediff.com/click?url=___http://dealhojaye.rediff.com?sc_cid=rediffmailsignature___cmp=signaturelnk=rediffmailsignaturenewservice=deals
* to get exciting offers in your city everyday.

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

--
Sam Mathai Chacko

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

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

Go to ToolsMacroSecurityProgrammatic AccessNever Warn

Sam

On Tue, Nov 29, 2011 at 8:28 AM, maulik desai mauliksde...@gmail.comwrote:

 Thanks you so much deepak for your great support lastly i just want to ask
 you 1 thing that when ever i clicked on

 Macro for mail send microsoft gives me pop up for stating that whould you
 like to send this mail (with allow or dinied option ) so every time i have
 to click allow buttion is there any why to remove this pop uo windlow rest
 everytrhing working fine

 pls revert with solution  thanks once again..
 On Wed, Nov 23, 2011 at 10:14 AM, Deepak Pal Singh 
 deepaktheind...@gmail.com wrote:

 Attached is the updated file, now you won't need to prepare a separate
 table to get channel wise unique email id's...




 On Mon, Nov 21, 2011 at 10:09 PM, maulik desai mauliksde...@gmail.comwrote:

 Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids
 are not common  it is also not based on channel name.its is based on
 location wise  its always get change so i suggest you to kindly add the
 new column after G or After M

 Actaully My Database is from A to G  if u add the new col then From A
 To H , actually there is no summry sheet (From K to M ,if u want u can
 remove the column L(person name ) from summary sheet  can add in main
 database after col F so while macro prepares summry sheet it will be easy
 for me to get data) i have just shown to u for ref

 actaully i want it like once i update the database in column A to H ,
 Macro can create the summry sheet based on unique list  then send the mail
 to mail ids (from To  in CC fields)
 Thanks
  On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh 
 deepaktheind...@gmail.com wrote:

 Sure Maulik... I just want to know those email ids (which you want to
 add in CC  BCC) are common or they'll be changed with every channel
 name...??

 Regards
 Deepak


 On Sun, Nov 20, 2011 at 2:43 PM, maulik desai 
 mauliksde...@gmail.comwrote:

 Thanks you so much deepak for your effort  sorry for late reply
 becasue i can not able to use Gmail from my office pc  i check your file
 it is working very well just one thing i want to ask u that i want to add
 some email id on CC  BCC can u please help in this that how can i do
 that. while data pasted to mail body , bottom line of table is not
 reflected .

 Request you to please look in small chnages  revert

 Thnaks in Advance..

  On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh 
 deepaktheind...@gmail.com wrote:

 Here it is I developed this code on 2007 platform..I hope it'll
 work in 2003 as well...

 Sorry.. I couldn't attached the excel file with my previous post
 because I's in office at that time  can't access to gmail over
 there...

 Regards
 Deepak


 On Tue, Nov 15, 2011 at 11:32 PM, maulik desai 
 mauliksde...@gmail.com wrote:

 Hi deepu,

 Thanks you so much for your reply

 I have tried to paste the code in module but it not work properly
 request you to kindly provide me the excel sheet with your macro code 
 but
 before you send me the file required small changes do not use K  M 
 column
 for Chennel name  email address that is given just for information my
 actual database is from A to G request you to kindly change the macro 
 code
 accordingly  send it back for the other checks also if you want u can
 create the summary sheet with the help of macro  paste it on sheet 2 
 also for name u can use Column H for the proper output.1 more thing i 
 want
 to tell you that a have to send mail with our official signature so if u
 can apply macro logic for the same also it would be very great ful to u.

 Request you to kindly make the changes  resend it for the final
 check

 Thanks in Advance  thanks for your time  support.

 On Mon, Nov 14, 2011 at 4:10 PM, deepu deepaktheind...@gmail.comwrote:

 Hi Maulik,

 Below is the code that you're looking for...
 Insert a module in your workbook and paste the following code and
 run
 it...


 ---
 Dim MyArray() As Variant, ListArray() As Variant
 Dim R As Long, C As Integer, LastRow As Long, i As Long
 Dim OutObj As Object, EmailObj As Object, EmailBody As String,
 RecAdd
 As String
 Sub PrepareData()
 'Assigning values to MyArray
 LastRow = Sheet1.Range(A6).End(xlUp).Row
 MyArray = Sheet1.Range(A7:G  LastRow).Value

 'Assigning values to ListArray
 LastRow = Sheet1.Range(K6).End(xlUp).Row
 ListArray = Sheet1.Range(K7:M  LastRow).Value

 For i = LBound(ListArray) To UBound(ListArray)
RecAdd = ListArray(i, 3)
EmailBody = Hi  
 Application.WorksheetFunction.Proper(ListArray(i, 2))  ,BRP
 Align=centerFYI...BRBR  _
TABLE Border=1, Cellspacing=0, Bgcolor=#EEECE1TR 
 _
TD Bgcolor=#14498A, Align=CenterFont
 Color=#FFCustomer Name/Font/TD  _
TD Bgcolor=#14498A, Align=CenterFont
 Color=#FFLocation/Font/TD  _
TD

Re: $$Excel-Macros$$ Re: Grant chart.......

Here's a very good Gantt chart template from Chandoo

http://chandoo.org/wp/2009/06/16/gantt-charts-project-management/

Regards,

Sam Mathai Chacko

On Tue, Nov 29, 2011 at 10:17 AM, Brajesh Kumar Porwal 
brajeshkumarpor...@gmail.com wrote:

 Hi,

 Gantt charts can be used to show current schedule status using
 percent-complete shadings and a vertical today line as shown here.
 Regads,
 Brajesh


 On Mon, Nov 28, 2011 at 8:57 PM, larry laurence.tha...@navy.mil wrote:

 Do you mean gannt chart?

 On Nov 28, 1:50 am, Brajesh Kumar Porwal
 brajeshkumarpor...@gmail.com wrote:
  Hi Expert,
 
  I have some activity. i want to create grant chart on this activity.
  How's make it. for help see enclose file.
  give me best solution.
 
  Regards,
  Brajesh
 
   Activity.xlsx
  15KViewDownload

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




-- 
Sam Mathai Chacko

-- 
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$$ Fwd:

Abhidha, this doesn't look like an Excel problem/question/query.

Ayush, probably something you want to add on the rules and regulations
section?

Regards,

Sam Mathai Chacko

On Tue, Nov 29, 2011 at 1:05 AM, Abhidha Dixit abhidha.di...@gmail.comwrote:


 Hi Friends

 Please help me in sloving these problems

 Regards
 Abhidha
 -- Forwarded message --
 From: Abhidha Dixit abhidha.di...@gmail.com
 Date: Tue, Nov 22, 2011 at 7:22 PM
 Subject:
 To: Ashish Batra batra.ash...@gmail.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




-- 
Sam Mathai Chacko

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

$$Excel-Macros$$ Excel and VBA Developer Required in Gurgaon

Dear Group Members,

This requirement is for the team that I lead in the KPO research and
analytics vertical of WNS Global Services, Gurgaon.

We are looking for two Excel Specialists, well versed in Excel formula
and it's application in various situations (should be well versed with
text functions, lookup functions, and array formulas), at least
intermediate level VBA skills (able to develop generic independent
modules that can be plugged in to a report with minimal modifications
+ clear understanding of manipulating charts and other objects in
Excel, able to design and develop user friendly
userforms). Intermediate to basic level SQL skills and basic VBA
skills in MS-Access (should be able to optimize table relationships
and to create the joins for quick execution of queries) would be an
added advantage. The designation will be that of Analyst, however, if
inducted, you will be part of the Business Transformation team
consisting of 20+ Excel, VBA, Access specialists with 4-8 years of
core experience providing dedicated technical support, creation of
marquee projects, integration of Excel, Access. Automation knowledge
of Powerpoint and Word and Outlook will be considered as added
advantage.

If you feel your skills exceed the above criteria, you will be
screened for a possible higher role. Salary will be comparable to
market rates.

For a heads up on the company, you can check www.wns.com. The company
does not provide cabs anymore in the regular shift, however, the
building is very close to the metro station. Commutation is not going
to be a problem. Since this is a group of technical experts, and we
will be investing in your development, there will be a time bound
diminishing bond of 1.5 years. You should have relevant experience of
at least 2 years. The shift will be normal office hours (8-5). Please
send your CV only if your fundamental knowledge of the Excel object
model is clear. If you feel your skill matches the above requirements,
feel free to send your resume to me.
 The job will be based out of Gurgaon.

Members who can join at the earliest will be given preference, and
members who have a valid passport will be given preference.

Regards,
Sam Mathai Chacko

-- 
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: Re: $$Excel-Macros$$ Almost all calculator in one sheet

2011-11-29 Thread sujitd9

Same here Mr.Ankit. If you can please resend the worksheet.

Thanks  Regards,
Sujit Mazumdar
Sent on my BlackBerry® from Vodafone

-Original Message-
From: nehal sejpal nehal_c...@rediffmail.com
Sender: excel-macros@googlegroups.com
Date: 29 Nov 2011 12:08:55 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: Re: $$Excel-Macros$$ Almost all calculator in one sheet

Dear Ankit,

I not found attachment can you send me the same.

Thanks In Advance,

Nehal A.Sejpal
On Tue, 29 Nov 2011 17:31:43 +0530  wrote

2011/11/28 vijayajith VA 

Thanks ankit.

On Mon, Nov 28, 2011 at 12:06 PM, Ankit Agrawal  wrote:

Hello All,

In our daily life we calculate so many thing  use different calculator. Here 
is one excel file which contain almost all calculator.

Calculate  enjoy !!!

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

�
Thanks for sharing, sheet very useful . 

-- 

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

With Regards,
Nehal A.Sejpal

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

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

2011-11-29 Thread Ayush Jain

Please make sure that you are sharing only free material in the forum and
not the paid one.
As per rules, you will be banned on violation.

Thanks !

Keep Posting !

Regards
Ayush Jain
On Sat, Nov 26, 2011 at 1:35 AM, kJo contactkkjo...@gmail.com wrote:

 What address or contact number pls?

 Any where in Borivli ?

 On Nov 24, 2:07 pm, krishnanm2...@gmail.com wrote:
  Andheri east
 
  Sent on my BlackBerry® from Vodafone
 
 
 
 
 
 
 
  -Original Message-
  From: mangesh bavalekar bavalek...@gmail.com
 
  Sender:excel-macros@googlegroups.com
  Date: Thu, 24 Nov 2011 14:16:44To: excel-macros@googlegroups.com
 Reply-To: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 toexcel-mac...@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




-- 
Best regards,
Ayush Jain

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

$$Excel-Macros$$

2011-11-29 Thread Ayoub Kakande

i have a simple formula like =(a2+b2)/2 it returns zero for empty
cells yet I want it to leave empty cells blank please help

-- 
*If u wanna dream dream BIG
*You`ve got to do your own growing, no matter how tall your grandfather was


Kayoub K
0772656158 / 0703516660
PMTCT Data Manager
Mujhu Research Collaboration
Mulago Hosp

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

2011-11-29 Thread Ayush Jain

=if((a2+b2)/2=0,,(a2+b2)/2)

I hope it helps.

Thanks.

On Tue, Nov 29, 2011 at 10:57 PM, Ayoub Kakande akaka...@gmail.com wrote:

 i have a simple formula like =(a2+b2)/2 it returns zero for empty
 cells yet I want it to leave empty cells blank please help

 --
 *If u wanna dream dream BIG
 *You`ve got to do your own growing, no matter how tall your grandfather was


 Kayoub K
 0772656158 / 0703516660
 PMTCT Data Manager
 Mujhu Research Collaboration
 Mulago Hosp

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




-- 
Best regards,
Ayush Jain

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

For cases where |B1| = A1 or vice versa, use *
=IF(COUNTA(A1:B1),(A1+B1)/2,)*

Regards,

Sam Mathai Chacko

On Tue, Nov 29, 2011 at 11:04 PM, Ayush Jain jainayus...@gmail.com wrote:

 =if((a2+b2)/2=0,,(a2+b2)/2)

 I hope it helps.

 Thanks.

 On Tue, Nov 29, 2011 at 10:57 PM, Ayoub Kakande akaka...@gmail.comwrote:

 i have a simple formula like =(a2+b2)/2 it returns zero for empty
 cells yet I want it to leave empty cells blank please help

 --
 *If u wanna dream dream BIG
 *You`ve got to do your own growing, no matter how tall your grandfather
 was


 Kayoub K
 0772656158 / 0703516660
 PMTCT Data Manager
 Mujhu Research Collaboration
 Mulago Hosp

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




 --
 Best regards,
 Ayush Jain


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




-- 
Sam Mathai Chacko

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


Sum Empty Cells.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

2011-11-29 Thread RK

Thx Sam, I will try this tomorrow and if it works in office 2K3, it will solve 
an year old problem for me.

Dear developers,

Just to extend this conversation and make it more wholesome. I am using MS 
office 2011 on a mac machine. How do I link excel to mail app on Mac instead of 
outlook. Assuming that everything in the code below remains the same except 
that I will be using mail instead of outlook.


Rgds,
Roopesh Kapur
E:roopesh.ka...@gmail.com

-Original Message-
From: Sam Mathai Chacko samde...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 29 Nov 2011 19:22:52 
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

Go to ToolsMacroSecurityProgrammatic AccessNever Warn

Sam

On Tue, Nov 29, 2011 at 8:28 AM, maulik desai mauliksde...@gmail.comwrote:

 Thanks you so much deepak for your great support lastly i just want to ask
 you 1 thing that when ever i clicked on

 Macro for mail send microsoft gives me pop up for stating that whould you
 like to send this mail (with allow or dinied option ) so every time i have
 to click allow buttion is there any why to remove this pop uo windlow rest
 everytrhing working fine

 pls revert with solution  thanks once again..
 On Wed, Nov 23, 2011 at 10:14 AM, Deepak Pal Singh 
 deepaktheind...@gmail.com wrote:

 Attached is the updated file, now you won't need to prepare a separate
 table to get channel wise unique email id's...




 On Mon, Nov 21, 2011 at 10:09 PM, maulik desai mauliksde...@gmail.comwrote:

 Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids
 are not common  it is also not based on channel name.its is based on
 location wise  its always get change so i suggest you to kindly add the
 new column after G or After M

 Actaully My Database is from A to G  if u add the new col then From A
 To H , actually there is no summry sheet (From K to M ,if u want u can
 remove the column L(person name ) from summary sheet  can add in main
 database after col F so while macro prepares summry sheet it will be easy
 for me to get data) i have just shown to u for ref

 actaully i want it like once i update the database in column A to H ,
 Macro can create the summry sheet based on unique list  then send the mail
 to mail ids (from To  in CC fields)
 Thanks
  On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh 
 deepaktheind...@gmail.com wrote:

 Sure Maulik... I just want to know those email ids (which you want to
 add in CC  BCC) are common or they'll be changed with every channel
 name...??

 Regards
 Deepak


 On Sun, Nov 20, 2011 at 2:43 PM, maulik desai 
 mauliksde...@gmail.comwrote:

 Thanks you so much deepak for your effort  sorry for late reply
 becasue i can not able to use Gmail from my office pc  i check your file
 it is working very well just one thing i want to ask u that i want to add
 some email id on CC  BCC can u please help in this that how can i do
 that. while data pasted to mail body , bottom line of table is not
 reflected .

 Request you to please look in small chnages  revert

 Thnaks in Advance..

  On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh 
 deepaktheind...@gmail.com wrote:

 Here it is I developed this code on 2007 platform..I hope it'll
 work in 2003 as well...

 Sorry.. I couldn't attached the excel file with my previous post
 because I's in office at that time  can't access to gmail over
 there...

 Regards
 Deepak


 On Tue, Nov 15, 2011 at 11:32 PM, maulik desai 
 mauliksde...@gmail.com wrote:

 Hi deepu,

 Thanks you so much for your reply

 I have tried to paste the code in module but it not work properly
 request you to kindly provide me the excel sheet with your macro code 
 but
 before you send me the file required small changes do not use K  M 
 column
 for Chennel name  email address that is given just for information my
 actual database is from A to G request you to kindly change the macro 
 code
 accordingly  send it back for the other checks also if you want u can
 create the summary sheet with the help of macro  paste it on sheet 2 
 also for name u can use Column H for the proper output.1 more thing i 
 want
 to tell you that a have to send mail with our official signature so if u
 can apply macro logic for the same also it would be very great ful to u.

 Request you to kindly make the changes  resend it for the final
 check

 Thanks in Advance  thanks for your time  support.

 On Mon, Nov 14, 2011 at 4:10 PM, deepu deepaktheind...@gmail.comwrote:

 Hi Maulik,

 Below is the code that you're looking for...
 Insert a module in your workbook and paste the following code and
 run
 it...


 ---
 Dim MyArray() As Variant, ListArray() As Variant
 Dim R As Long, C As Integer, LastRow As Long, i As Long
 Dim OutObj As Object,

$$Excel-Macros$$ macro to translate from one languague to another

2011-11-29 Thread RK

Dear Developers,

I am looking for an excel macro to translate a sentence in a cell from one 
language to another and paste the result in another cell next to it.

Thx in advance. 
Rgds,
Roopesh Kapur
E:roopesh.ka...@gmail.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

Re: $$Excel-Macros$$ macro to translate from one languague to another

You could possibly use the Google Translation API, but I am not sure if
they have one for VB or VBA. If they do, probably have to pay some money
for that. But search for the text Google Translation API for VB/VBA, and
you might get something. If you reach a dead end, post back. Maybe we could
help.

Sam Mathai Chacko

On Wed, Nov 30, 2011 at 12:25 AM, RK roopesh.ka...@gmail.com wrote:

 Dear Developers,

 I am looking for an excel macro to translate a sentence in a cell from one
 language to another and paste the result in another cell next to it.

 Thx in advance.
 Rgds,
 Roopesh Kapur
 E:roopesh.ka...@gmail.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




-- 
Sam Mathai Chacko

-- 
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$$ macro to translate from one languague to another

Another feature that Excel 2007-10 provides in terms of Translation can be
found in the Review tab. If you have a cell selected, and use this
translation feature, it will most likely translate it for you
automatically. The manual part is that you will have to click on the insert
button or copy button. This doesn't use Google Translation by the way. It
uses Bing translation. Not sure if you can change that setting though.

Regards,
Sam

On Wed, Nov 30, 2011 at 12:32 AM, Sam Mathai Chacko samde...@gmail.comwrote:

 You could possibly use the Google Translation API, but I am not sure if
 they have one for VB or VBA. If they do, probably have to pay some money
 for that. But search for the text Google Translation API for VB/VBA, and
 you might get something. If you reach a dead end, post back. Maybe we could
 help.

 Sam Mathai Chacko


 On Wed, Nov 30, 2011 at 12:25 AM, RK roopesh.ka...@gmail.com wrote:

 Dear Developers,

 I am looking for an excel macro to translate a sentence in a cell from
 one language to another and paste the result in another cell next to it.

 Thx in advance.
 Rgds,
 Roopesh Kapur
 E:roopesh.ka...@gmail.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




 --
 Sam Mathai Chacko




-- 
Sam Mathai Chacko

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

$$Excel-Macros$$ Excel to Word

2011-11-29 Thread hanumant shinde

Hi,

i want to copy paste data from Excel to specific location in microsoft word 
using Excel macro.

i am able to copy paste it at the beginning of word document but not on 
specific location.

below is my requirement.
1. i need to find specific word in microsoft word doc --- Done
2. just 1 place above that word i want to paste some data from Excel.

can somebody pls tell me how can do it?

Thanks,

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

$$Excel-Macros$$ Returning a Value Based on a String Containing Specific Characters

2011-11-29 Thread John A. Smith

Excel Teachers,

I need to look at a cell and if it contains specific characters (for
example the three characters “410”), return a specific value and if not
return a blank.  The string can be quite long or short and the “410” may or
may not be in it and its location when it is in it could be at the
beginning, in the middle or at the end.

Please review the attached sample.  Thank you for your help and
consideration.

John

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


Return A Value Based on Specific Text in the String.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Returning a Value Based on a String Containing Specific Characters

Don Guillett
SalesAid Software
dguille...@gmail.com

From: John A. Smith 
Sent: Tuesday, November 29, 2011 3:08 PM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Returning a Value Based on a String Containing 
Specific Characters

Excel Teachers,

I need to look at a cell and if it contains specific characters (for example 
the three characters “410”), return a specific value and if not return a blank. 
 The string can be quite long or short and the “410” may or may not be in it 
and its location when it is in it could be at the beginning, in the middle or 
at the end.

Please review the attached sample.  Thank you for your help and consideration.

John

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

SMITH_Return A Value Based on Specific Text in the String.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Help for stock file

You need to explain a bit more with examples

Don Guillett
SalesAid Software
dguille...@gmail.com

From: manhar prajapati 
Sent: Tuesday, November 29, 2011 4:14 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Help for stock file

Dear All HI

Please Find attach file for my quary.

it is for stck matter please halp and provide the proper formula so i can 
calculate the stock

for more details please refer the stock file.

-- 

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

Re: $$Excel-Macros$$ Returning a Value Based on a String Containing Specific Characters

2011-11-29 Thread John A. Smith

Thank you Don, I appreciate the help.

John

On Tue, Nov 29, 2011 at 5:04 PM, dguillett1 dguille...@gmail.com wrote:



 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* John A. Smith johnasmit...@gmail.com
 *Sent:* Tuesday, November 29, 2011 3:08 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Returning a Value Based on a String
 Containing Specific Characters


 Excel Teachers,

 I need to look at a cell and if it contains specific characters (for
 example the three characters “410”), return a specific value and if not
 return a blank.  The string can be quite long or short and the “410” may
 or may not be in it and its location when it is in it could be at the
 beginning, in the middle or at the end.

 Please review the attached sample.  Thank you for your help and
 consideration.

 John
 --
 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) 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$$ Need Help

2011-11-29 Thread B.N.Chethan Kumar

Hi,

Thanks these help.

But need some additional input. these work only PST or OST file...can u
help with any file pattern..like .DOC, XLS,.XL.PPT ,etc

Regards
Chethan Kumar BN
On Wed, Nov 30, 2011 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:

   Here is a file that should help

 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* B.N.Chethan Kumar chetankumar1...@gmail.com
 *Sent:* Tuesday, November 29, 2011 4:04 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Need Help

   Hi All,

 I got these Macro template from one guys of these group some time back. I
 need some additional infortmation to be added in the macro.

 Currently these macro help with list of folder and files based on locaton.
 Kindly let me know how to add some additioanl information like Size of file
 and Last modified date of the file.

 As i have maintain these data to help Archieve the Server on regular basis.

 Expect a solution ASAP.

 --
 B.N Chetan kumar
 --
 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




-- 
B.N Chetan kumar

-- 
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$$ Need Help

I didn’t create the file but the macro appears to get ALL file extensions.

  Denon_AVR786_1.pdf 
  Denon_DVD556_DFU.pdf 
  desktop.ini 
  Double click symbol in Symbols to get chart.gif 
  DSC_0001 [800x600].JPG 



Don Guillett
SalesAid Software
dguille...@gmail.com

From: B.N.Chethan Kumar 
Sent: Tuesday, November 29, 2011 5:03 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need Help

Hi,

Thanks these help. 

But need some additional input. these work only PST or OST file...can u help 
with any file pattern..like .DOC, XLS,.XL.PPT ,etc


Regards
Chethan Kumar BN

On Wed, Nov 30, 2011 at 4:16 AM, dguillett1 dguille...@gmail.com wrote:

  Here is a file that should help

  Don Guillett
  SalesAid Software
  dguille...@gmail.com

  From: B.N.Chethan Kumar 
  Sent: Tuesday, November 29, 2011 4:04 PM
  To: excel-macros@googlegroups.com 
  Subject: $$Excel-Macros$$ Need Help

  Hi All,

  I got these Macro template from one guys of these group some time back. I 
need some additional infortmation to be added in the macro. 

  Currently these macro help with list of folder and files based on locaton. 
Kindly let me know how to add some additioanl information like Size of file and 
Last modified date of the file. 

  As i have maintain these data to help Archieve the Server on regular basis.

  Expect a solution ASAP.

  -- 
  B.N Chetan kumar

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




-- 
B.N Chetan kumar
-- 
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

Re: $$Excel-Macros$$ re: conversion of numbers

2011-11-29 Thread harsh shah

thanks.

On 29 November 2011 11:05, Ankit Agrawal ankit.agrawal...@gmail.com wrote:

Hi Aamir,

1. Click the *Microsoft Office Button* [image: Button image], click *Excel
Options*, and then click *Add-Ins*.
2. View the add-ins and application extensions that are categorized as
follows:
- *Active Application Add-ins* Lists the extensions that are
registered and currently running in your Office program.
- *Inactive Application Add-ins* Lists the add-ins that are
present on your computer but are not currently loaded. For example,
smart
tags or XML Schemas are active only when the document that references
them
is open. Another example is the COM add-ins that are listed in the *COM
Add-ins* dialog box. If the check box for a COM add-in is selected,
the add-in is active. If the check box for a COM add-in is cleared, the
add-in is inactive. To learn how to open the *COM Add-in* dialog
box, see the section called Turn off or manage the installed
add-inshttp://office.microsoft.com/en-us/help/enable-or-disable-add-ins-in-office-programs-HA010034127.aspx#BM2
.
- *Document Related Add-ins* Lists template files that are
referenced by currently open documents.
- *Disabled Application Add-ins* Lists add-ins that were
automatically disabled because they are causing Office programs to
crash.

how to use SureshAddin.xla

syntax:-

=rswords(cell no.)

Example:
suppose we have a num value in cell 'B2'
we will write

=rswords(b2)

Regards,
Ankit

On Tue, Nov 29, 2011 at 12:56 AM, Aamir Shahzad
aamirshahza...@gmail.comwrote:

how to recall this add-inn in working sheet.

Regards,

Aamir Shahzad

On Mon, Nov 28, 2011 at 11:41 AM, Ankit Agrawal
ankit.agrawal...@gmail.com wrote:

Hi Harsh,

Use attached add-inn.

Regards,
Ankit

On Mon, Nov 28, 2011 at 1:22 AM, Vinod Narayanan nvino...@gmail.comwrote:

Hi Harsh,

Select the cells which requires the formatting to be done and in Format
Cells -- Custom, Please type *#,* to convert numbers in thousands
and so on

Option 1 = If base data is 10 - type *#,* in Format Cells --
Custom.. The result will be 100
Option 2 = If base data is 10 - type *#,,* in Format Cells --
Custom.. The result will be 1000
Option 3 = If base data is 10 - type *#,#,* in Format Cells
-- Custom.. The result will be 1,000,000
Option 4 = If base data is 10 - type *#,#,,* in Format Cells
-- Custom.. The result will be 1,000
Option 5 = If base data is 10 - type *#,#,,,* in Format Cells
-- Custom.. The result will be 1

Please have an eye on the number of commas(,) added after hash(#)

Thanks for the query
Vinod

On Sun, Nov 27, 2011 at 10:00 AM, harsh shah harshsha...@gmail.com
wrote:
dear all,

i have a data sheet with numbers in it.

i want to convert them into thousands or in lacs.

is there a way to format the selected data cells so as to convert the
same
in thousands or in lacs ?

harsh.

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

Re: $$Excel-Macros$$ Help for stock file

2011-11-29 Thread manhar prajapati

Dear Sir

I require a formula which can deducted raw material and packing material
when i enter the procution.

Example:

If i enter production of protozyme II of 5000 kg and use blank granule
4950kg and seaweed 50ltr so when i enter Protozyme II 5000kg it is deducted
form raw material and and packing material.

Regards
Manhar Prajapati

On Wed, Nov 30, 2011 at 3:35 AM, dguillett1 dguille...@gmail.com wrote:

   You need to explain a bit more with examples


 Don Guillett
 SalesAid Software
 dguille...@gmail.com

  *From:* manhar prajapati prajapati.man...@gmail.com
 *Sent:* Tuesday, November 29, 2011 4:14 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Help for stock file

 Dear All HI

 Please Find attach file for my quary.

 it is for stck matter please halp and provide the proper formula so i can
 calculate the stock

 for more details please refer the stock file.

 --



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

$$Excel-Macros$$ Link for complex excel 2007 puzzles

2011-11-29 Thread krishnanm2006

Dear Excel Gurus,
Does any one have  links for sites/blogs which have challenging puzzles/ quiz 
related to excel 2007... I searched google, all the existing sites have simple 
excel puzzles..

Appreciate if you can provide the link at your earliest..

Thanks in advance.

Krishnan


Sent on my BlackBerry® from Vodafone

-- 
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$$ Fwd:

2011-11-29 Thread Abhidha Dixit

Thanks Sam !!

On Tue, Nov 29, 2011 at 7:46 PM, Sam Mathai Chacko samde...@gmail.comwrote:

 Abhidha, this doesn't look like an Excel problem/question/query.

 Ayush, probably something you want to add on the rules and regulations
 section?

 Regards,

 Sam Mathai Chacko


 On Tue, Nov 29, 2011 at 1:05 AM, Abhidha Dixit abhidha.di...@gmail.comwrote:


 Hi Friends

 Please help me in sloving these problems

 Regards
 Abhidha
 -- Forwarded message --
 From: Abhidha Dixit abhidha.di...@gmail.com
 Date: Tue, Nov 22, 2011 at 7:22 PM
 Subject:
 To: Ashish Batra batra.ash...@gmail.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




 --
 Sam Mathai Chacko

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

Re: $$Excel-Macros$$ Help for If nesting formula