$$Excel-Macros$$ Color base conditional formatting problem

[Sanjib Chatterjee]

Dear Sir / Madam,

I have a problem while doing the color base conditional formatting

please see the attachment

suppose some of the criteria rows B4 become yellow.  I want if b4 become
yellow automatically the row of column d where c is written become yellow

please help me.

Regards

thanking you in advance


Sanjib Chatterje

mobile 9830311680




-- 
-

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

FORUM RULES

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

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/excel-macros/CA%2BRktJZepPM_wNhgq5UXo2QrYYySAeGqYtQ%3DBjw%2Bt%2BMEEbCoMg%40mail.gmail.com.


conditional color formatting.xlsx
Description: MS-Excel 2007 spreadsheet

Re: Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

[Sanjib Chatterjee]

Many Many thank you Maul Schreiner

I is really what i am looking for



On Mon, Jul 10, 2017 at 6:38 PM, Paul Schreiner 
wrote:

> I'm not sure I COMPLETELY understand, but at least I can give it a start.
>
> first: your description keeps saying "BD = ..."
> But your workbook has a column heading "DB", so I'm assuming one or the
> other is transposed.
>
> also, .06% is .0006  do you really mean
> "B Value" * .06  (formula: =B2 * .06)
> or
> "B Value" * .06% (formula: =B2 * .06% is the same as =B2 * .0006)
> The difference for row 2 is 134274 or 1342.74
>
>
> I think the easiest for you to read and follow would be a nested "if"
> statement:
>
> in cell N2:
> =IF(AND(A2="NS",H2="C/F"),F2*0.06,
>  IF(AND(A2="NS",C2="C/F"),K2*0.06,
>  IF(AND(A2="NS",C2<>"C/F"),(F2+K2)*0.06,
> IF(AND(A2="BNIST",H2="C/F"),F2*0.05,
>  IF(AND(A2="BNIST",C2="C/F"),K2*0.05,
>  IF(AND(A2="BNIST",C2<>"C/F"),(F2+K2)*0.05,
> "other"))
>
> I'm not sure what you mean by:
> "FOR THE OTHER PERSONS IT TAKES OTHER CALCULATION AL WELL"
>
> do you mean "AS WELL", meaning that other combinations have alternate
> calculations?
>
> If so, you can add the appropriate alternatives to the above formula
>
>
> BTW: in case you are unaware, Alt-Enter allows you to move part of the
> formula to the next line,
> allowing a long formula such as this to be easier to read!
>
> hope this helps.
>
> *Paul*
> -----
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Monday, July 10, 2017 2:31 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>
> please help
>
>
> -- Forwarded message --
> From: *Sanjib Chatterjee* 
> Date: Sat, Jul 8, 2017 at 1:22 PM
> Subject: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE
> RESULT
> To: excel-macros 
>
>
> Dear Sir / Madam,
>
> Please see the attachment and
>
>
>
> Please help me how to solve the problem,
>
> I want to calculate "BD"
>
>
> if person says "NS"  IF SELL DATE " C/F" , BD = B Value * .06%
> if person says "NS"  IF Buy DATE " C/F" , BD = S Value * .06%
> if person says "NS"  IF Buy DATE " not equal to C/F" , BD = (B Value + S
> value) * .06%
>
>
> if person says "BNIST"  IF SELL DATE " C/F" , BD = B Value * .05%
> if person says "BNIS"  IF Buy DATE " C/F" , BD = S Value * .05%
> if person says "BNIS"  IF Buy DATE " not equal to C/F" , BD = (B Value + S
> value) * .05%
>
>
> FOR THE OTHER PERSONS IT TAKES OTHER CALCULATION AL WELL
>
> I HOPE I MAKE YOU UNDERSTAND WHAT I WANT
>
> PLEASE HELP ME
>
>
> Thanking you in advance
>
>
>
>
> Sanjib Chatterjee
>
>
>
>
> --
> -
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/
> discussexcel <https://www.facebook.com/discussexcel>
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscribe@ googlegroups.com
> .
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/ group/excel-macros
> <https://groups.google.com/group/excel-macros>.
> For more options, visit https://groups.google.com

Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

[Sanjib Chatterjee]

please help


-- Forwarded message --
From: Sanjib Chatterjee 
Date: Sat, Jul 8, 2017 at 1:22 PM
Subject: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE
RESULT
To: excel-macros 


Dear Sir / Madam,

Please see the attachment and



Please help me how to solve the problem,

I want to calculate "BD"


if person says "NS"  IF SELL DATE " C/F" , BD = B Value * .06%
if person says "NS"  IF Buy DATE " C/F" , BD = S Value * .06%
if person says "NS"  IF Buy DATE " not equal to C/F" , BD = (B Value + S
value) * .06%


if person says "BNIST"  IF SELL DATE " C/F" , BD = B Value * .05%
if person says "BNIS"  IF Buy DATE " C/F" , BD = S Value * .05%
if person says "BNIS"  IF Buy DATE " not equal to C/F" , BD = (B Value + S
value) * .05%


FOR THE OTHER PERSONS IT TAKES OTHER CALCULATION AL WELL

I HOPE I MAKE YOU UNDERSTAND WHAT I WANT

PLEASE HELP ME


Thanking you in advance




Sanjib Chatterjee




-- 
-

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

FORUM RULES

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

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



-- 
-

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

FORUM RULES

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

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


FOR MULTIPLE CONDITION.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Fwd: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

[Sanjib Chatterjee]

Sir / Madam,

Please go through the mail and help

Sanjib




-- Forwarded message --
From: Sanjib Chatterjee 
Date: Sat, 8 Jul 2017 13:22:20 +0530
Subject: $$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT
To: excel-macros 

Dear Sir / Madam,

Please see the attachment and



Please help me how to solve the problem,

I want to calculate "BD"


if person says "NS"  IF SELL DATE " C/F" , BD = B Value * .06%
if person says "NS"  IF Buy DATE " C/F" , BD = S Value * .06%
if person says "NS"  IF Buy DATE " not equal to C/F" , BD = (B Value + S
value) * .06%


if person says "BNIST"  IF SELL DATE " C/F" , BD = B Value * .05%
if person says "BNIS"  IF Buy DATE " C/F" , BD = S Value * .05%
if person says "BNIS"  IF Buy DATE " not equal to C/F" , BD = (B Value + S
value) * .05%


FOR THE OTHER PERSONS IT TAKES OTHER CALCULATION AL WELL

I HOPE I MAKE YOU UNDERSTAND WHAT I WANT

PLEASE HELP ME


Thanking you in advance




Sanjib Chatterjee




-- 
-

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

FORUM RULES

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

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



-- 
-

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

FORUM RULES

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

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

$$Excel-Macros$$ for multiple condition to calculate A SIMPLE RESULT

[Sanjib Chatterjee]

Dear Sir / Madam,

Please see the attachment and



Please help me how to solve the problem,

I want to calculate "BD"


if person says "NS"  IF SELL DATE " C/F" , BD = B Value * .06%
if person says "NS"  IF Buy DATE " C/F" , BD = S Value * .06%
if person says "NS"  IF Buy DATE " not equal to C/F" , BD = (B Value + S
value) * .06%


if person says "BNIST"  IF SELL DATE " C/F" , BD = B Value * .05%
if person says "BNIS"  IF Buy DATE " C/F" , BD = S Value * .05%
if person says "BNIS"  IF Buy DATE " not equal to C/F" , BD = (B Value + S
value) * .05%


FOR THE OTHER PERSONS IT TAKES OTHER CALCULATION AL WELL

I HOPE I MAKE YOU UNDERSTAND WHAT I WANT

PLEASE HELP ME


Thanking you in advance




Sanjib Chatterjee




-- 
-

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

FORUM RULES

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

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


FOR MULTIPLE CONDITION.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Fwd: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

[Sanjib Chatterjee]

Thank you everyone I got the solution

Many Many thank you for supporting me

Sanjib Chatterjee


-- Forwarded message --
From: 'Carmelita Cronin' via MS EXCEL AND VBA MACROS <
excel-macros@googlegroups.com>
Date: Fri, May 19, 2017 at 9:32 PM
Subject: Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other
based on condition
To: excel-macros@googlegroups.com




On Fri, 5/19/17, Sanjib Chatterjee  wrote:

 Subject: Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other
based on condition
 To: "excel-macros" 
 Cc: "Paul Schreiner" 
 Date: Friday, May 19, 2017, 1:56 PM

 Thanking
 you Mr Jitendra Singh, and Mr, Paul and other expert

 On Fri, May 19, 2017 at
 3:12 PM, Jitendra Singh 
 wrote:
 Plz use 2nd
 attachment.


 https://vbatutorial.blogspot.
 in/2017/05/problem-1-filter-
 data-and-paste-to.html?m=1


 Sent from BlueMail

 On 19 May 2017, at
 1:19 PM, Sanjib Chatterjee 
 wrote:




   -- Forwarded message --

 From:
   Sanjib
 Chatterjee
   

 Date: Fri, May 19, 2017 at 1:18 PM

 Subject: Re: Fwd: $$Excel-Macros$$ copy
 data from one sheet to other based on condition

 To: excel-macros <
   excel-macros@googlegroups.com>
 ,
   schreiner_p...@att.net







Dear Paul
Schreiner,





 Here
 find the attachment,




   I have a problem I want to copy data base on the
 Person name which i highlighted with yellow colour.


   suppose if the person name "JKM" a sheet
 will created with the name "JKM" and the entire
 rows data relating to Jkm WILL copy to the new sheets of
 JKM.  if the person name is HM the the same rule will be
 follow.








  thouth
  Preeti
 Tomar, help me a lot of doing the project.  But I got an
 error while


  running
 the vba code.







   Please help






   Thanking you






   SANJIB CHATTERJEE

























   On Thu, May 18, 2017 at 5:28 PM, Paul Schreiner
   
 wrote:










   Your error seems to indicate that you're
 trying to create a sheet and change the name to one
 that already exists.






   without seeing a sample of your file and macros,
 it will be difficult to determine what is going on.



Paul


--
---


“Do
 all the good you can,
 By all the means you
 can,
 In all the ways you can,
 In all the places you can,
 At
 all the times you can,
 To all the people you
 can,
 As long as ever you can.” - John
 Wesley
 --
---















     On Thursday, May
 18, 2017 1:37 AM, Sanjib Chatterjee 
 wrote:














   Sir / Madam,





Please help I am having a of copying data
 from one sheet to another sheets based on some criteria






regards








  Sanjib Chatterjee






  ------ Forwarded message --

 From:
  Sanjib
 Chatterjee
  

 Date: Wed, May 17,
 2017 at 9:56 AM

 Subject: Re:
 $$Excel-Macros$$ copy data from one sheet to other based on
 condition

 To: excel-macros <
  excel-macros@googlegroups.com
  >











   Dear Preeti Tomar





Many Many thank you for your prompt
 help.






This is what exactly I am looking
 for.  But I am getting an error while trying the execute
 the command for the next time.






for your reference I am attaching the
 error snap short






Please help






Once again many many thank you in
 advance







Sanjib Chatterjee



















On Tue, May 16, 2017 at 10:48 PM,
 Preeti Tomar

 wrote:




  https://jeetexltips.blogspot.i
 n/2017/05/Filterinvba.html













     On Tue, May 16, 2017 at 2:00
 PM, Sanjib Chatterjee
 
 wrote:







Dear Sir / madam,






Please see the
 attachment.






I have a problem I want
 to copy data base on the Person name which i highlighted
 with yellow colour.


suppose if the person
 name "JKM" a sheet will created with the name
 "JKM" and the entire rows data relating to Jkm
 WILL copy to the new sheets of JKM.  if the person name is
 HM the the same rule will be follow.








Please help






   

Re: Fwd: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

[Sanjib Chatterjee]

Thanking you Mr Jitendra Singh, and Mr, Paul and other expert


On Fri, May 19, 2017 at 3:12 PM, Jitendra Singh 
wrote:

> Plz use 2nd attachment.
>
> https://vbatutorial.blogspot.in/2017/05/problem-1-filter-
> data-and-paste-to.html?m=1
>
> Sent from BlueMail <http://www.bluemail.me/r?b=9660>
> On 19 May 2017, at 1:19 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>>
>>
>> -- Forwarded message --
>> From: Sanjib Chatterjee 
>> Date: Fri, May 19, 2017 at 1:18 PM
>> Subject: Re: Fwd: $$Excel-Macros$$ copy data from one sheet to other
>> based on condition
>> To: excel-macros < excel-macros@googlegroups.com>, schreiner_p...@att.net
>>
>>
>> Dear Paul  Schreiner,
>>
>> Here find the attachment,
>> I have a problem I want to copy data base on the Person name which i
>> highlighted with yellow colour.
>> suppose if the person name "JKM" a sheet will created with the name "JKM"
>> and the entire rows data relating to Jkm WILL copy to the new sheets of
>> JKM.  if the person name is HM the the same rule will be follow.
>>
>> thouth  Preeti Tomar, help me a lot of doing the project.  But I got an
>> error while
>> running the vba code.
>>
>> Please help
>>
>> Thanking you
>>
>> SANJIB CHATTERJEE
>>
>>
>>
>>
>>
>> On Thu, May 18, 2017 at 5:28 PM, Paul Schreiner 
>> wrote:
>>
>>> Your error seems to indicate that you're trying to create a sheet and
>>> change the name to one that already exists.
>>>
>>> without seeing a sample of your file and macros, it will be difficult to
>>> determine what is going on.
>>> *Paul*
>>> -- -------
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *“Do all the good you can,By all the means you can,In all the ways you
>>> can,In all the places you can,At all the times you can,To all the people
>>> you can,As long as ever you can.” - John 
>>> Wesley*--
>>> ---
>>>
>>>
>>> On Thursday, May 18, 2017 1:37 AM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>
>>> Sir / Madam,
>>>
>>> Please help I am having a of copying data from one sheet to another
>>> sheets based on some criteria
>>>
>>> regards
>>>
>>> Sanjib Chatterjee
>>> -- Forwarded message --
>>> From: *Sanjib Chatterjee* 
>>> Date: Wed, May 17, 2017 at 9:56 AM
>>> Subject: Re: $$Excel-Macros$$ copy data from one sheet to other based on
>>> condition
>>> To: excel-macros < excel-macros@googlegroups.com >
>>>
>>>
>>> Dear Preeti Tomar
>>>
>>> Many Many thank you for your prompt help.
>>>
>>> This is what exactly I am looking for.  But I am getting an error while
>>> trying the execute the command for the next time.
>>>
>>> for your reference I am attaching the error snap short
>>>
>>> Please help
>>>
>>> Once again many many thank you in advance
>>>
>>> Sanjib Chatterjee
>>>
>>>
>>>
>>> On Tue, May 16, 2017 at 10:48 PM, Preeti Tomar 
>>> wrote:
>>>
>>> https://jeetexltips.blogspot.i n/2017/05/Filterinvba.html
>>> <https://jeetexltips.blogspot.in/2017/05/Filterinvba.html>
>>>
>>>
>>> On Tue, May 16, 2017 at 2:00 PM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>
>>> Dear Sir / madam,
>>>
>>> Please see the attachment.
>>>
>>> I have a problem I want to copy data base on the Person name which i
>>> highlighted with yellow colour.
>>> suppose if the person name "JKM" a sheet will created with the name
>>> "JKM" and the entire rows data relating to Jkm WILL copy to the new sheets
>>> of JKM.  if the person name is HM the the same rule will be follow.
>>>
>>> Please help
>>>
>>> Thanking you
>>>
>>> SANJIB CHATTERJEE
>>>
>>>
>>>
>>> --
>>> -
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>> https://www.facebook.com/discu
>>> ssexcel &l

Re: Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

[Sanjib Chatterjee]

Dear Paul Schreiner,

Here find the attachment,
I have a problem I want to copy data base on the Person name which i
highlighted with yellow colour.
suppose if the person name "JKM" a sheet will created with the name "JKM"
and the entire rows data relating to Jkm WILL copy to the new sheets of
JKM.  if the person name is HM the the same rule will be follow.

thouth Preeti Tomar, help me a lot of doing the project.  But I got an
error while
running the vba code.

Please help

Thanking you

SANJIB CHATTERJEE





On Thu, May 18, 2017 at 5:28 PM, Paul Schreiner 
wrote:

> Your error seems to indicate that you're trying to create a sheet and
> change the name to one that already exists.
>
> without seeing a sample of your file and macros, it will be difficult to
> determine what is going on.
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -----
>
>
> On Thursday, May 18, 2017 1:37 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>
> Sir / Madam,
>
> Please help I am having a of copying data from one sheet to another sheets
> based on some criteria
>
> regards
>
> Sanjib Chatterjee
> -- Forwarded message --
> From: *Sanjib Chatterjee* 
> Date: Wed, May 17, 2017 at 9:56 AM
> Subject: Re: $$Excel-Macros$$ copy data from one sheet to other based on
> condition
> To: excel-macros 
>
>
> Dear Preeti Tomar
>
> Many Many thank you for your prompt help.
>
> This is what exactly I am looking for.  But I am getting an error while
> trying the execute the command for the next time.
>
> for your reference I am attaching the error snap short
>
> Please help
>
> Once again many many thank you in advance
>
> Sanjib Chatterjee
>
>
>
> On Tue, May 16, 2017 at 10:48 PM, Preeti Tomar 
> wrote:
>
> https://jeetexltips.blogspot.i n/2017/05/Filterinvba.html
> <https://jeetexltips.blogspot.in/2017/05/Filterinvba.html>
>
>
> On Tue, May 16, 2017 at 2:00 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>
> Dear Sir / madam,
>
> Please see the attachment.
>
> I have a problem I want to copy data base on the Person name which i
> highlighted with yellow colour.
> suppose if the person name "JKM" a sheet will created with the name "JKM"
> and the entire rows data relating to Jkm WILL copy to the new sheets of
> JKM.  if the person name is HM the the same rule will be follow.
>
> Please help
>
> Thanking you
>
> SANJIB CHATTERJEE
>
>
>
> --
> -
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discu
> ssexcel <https://www.facebook.com/discussexcel>
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscribe@googl egroups.com
> .
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/grou p/excel-macros
> <https://groups.google.com/group/excel-macros>.
> For more options, visit https://groups.google.com/d/op tout
> <https://groups.google.com/d/optout>.
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discu
> ssexcel <https://www.facebook.com/discussexcel>
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not g

Fwd: $$Excel-Macros$$ Introduce Yourself !!

[Sanjib Chatterjee]

I am Sanjib Chatterjee, working in a stock broking firm, name Sunidhi
securities and finance ltd,Kolkata, sa Bank office Mis executive.  I get
lot of support from the excel community whenever I need any help. I have a
great passion of Excel.
Hope You will continue supporting us.

Thanking you

Sanjib Chatterjee



-- Forwarded message --
From: Michael Vinoth 
Date: Fri, May 19, 2017 at 3:06 AM
Subject: $$Excel-Macros$$ Introduce Yourself !!
To: MS EXCEL AND VBA MACROS 


Hi Friends..

I am Michael Vinoth.. I have 5 years experience in developing the excel vba
macros.. I love what I am doing.. Excel is my passion.. I hope I will learn
many things from you all and I will share what I know..

Thanks
MV
VBA Developer

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

FORUM RULES

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

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



-- 
-

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

[Sanjib Chatterjee]

Dear Mr Jitendra Singh,

I want whenever I am doing entry in the master sheets it will  copy the
data to correspondence sheets.   So, why do I need to delete the sheets
every time.

Hope Your will understand my problem.  I need your help

Thanking you in advance


Sanjib Chatterjee

On Wed, May 17, 2017 at 10:03 AM, Jitendra Singh 
wrote:

> Hi Mr. chatterjee,
>
> Before executing please delete all sheets.
>
> Thanks
> http://vbatutorial.blogspot.in/
>
> Sent from BlueMail <http://www.bluemail.me/r?b=9660>
> On 17 May 2017, at 9:56 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>>
>> Dear Preeti Tomar
>>
>> Many Many thank you for your prompt help.
>>
>> This is what exactly I am looking for.  But I am getting an error while
>> trying the execute the command for the next time.
>>
>> for your reference I am attaching the error snap short
>>
>> Please help
>>
>> Once again many many thank you in advance
>>
>> Sanjib Chatterjee
>>
>>
>>
>> On Tue, May 16, 2017 at 10:48 PM, Preeti Tomar 
>> wrote:
>>
>>> https://jeetexltips.blogspot.in/2017/05/Filterinvba.html
>>>
>>>
>>> On Tue, May 16, 2017 at 2:00 PM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>>
>>>> Dear Sir / madam,
>>>>
>>>> Please see the attachment.
>>>>
>>>> I have a problem I want to copy data base on the Person name which i
>>>> highlighted with yellow colour.
>>>> suppose if the person name "JKM" a sheet will created with the name
>>>> "JKM" and the entire rows data relating to Jkm WILL copy to the new sheets
>>>> of JKM.  if the person name is HM the the same rule will be follow.
>>>>
>>>> Please help
>>>>
>>>> Thanking you
>>>>
>>>> SANJIB CHATTERJEE
>>>>
>>>>
>>>>
>>>> --
>>>> -
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not resp

Fwd: $$Excel-Macros$$ copy data from one sheet to other based on condition

[Sanjib Chatterjee]

-- Forwarded message --
From: Sanjib Chatterjee 
Date: Tue, May 16, 2017 at 3:14 PM
Subject: Re: $$Excel-Macros$$ copy data from one sheet to other based on
condition
To: excel-macros , jitendra kumar <
jitendr...@gmail.com>, jeetexcelt...@gmail.com


Dear Jitendra Singh,

I want automatically doing the task if match it will automatically copy
data to other sheets.

any help will be appreciated

Sanjib Chatterjee

On Tue, May 16, 2017 at 3:08 PM, Jitendra Singh 
wrote:

> Use advance filter ||
>
> Sent from BlueMail <http://www.bluemail.me/r?b=9660>
> On 16 May 2017, at 2:00 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>>
>>
>> Dear Sir / madam,
>>
>> Please see the attachment.
>>
>> I have a problem I want to copy data base on the Person name which i
>> highlighted with yellow colour.
>> suppose if the person name "JKM" a sheet will created with the name "JKM"
>> and the entire rows data relating to Jkm WILL copy to the new sheets of
>> JKM.  if the person name is HM the the same rule will be follow.
>>
>> Please help
>>
>> Thanking you
>>
>> SANJIB CHATTERJEE
>>
>>
>>
>> --
>> -
>>
>> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
-



-- 
-

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ copy data from one sheet to other based on condition

[Sanjib Chatterjee]

Dear Jitendra Singh,

I want automatically doing the task if match it will automatically copy
data to other sheets.

any help will be appreciated

Sanjib Chatterjee

On Tue, May 16, 2017 at 3:08 PM, Jitendra Singh 
wrote:

> Use advance filter ||
>
> Sent from BlueMail <http://www.bluemail.me/r?b=9660>
> On 16 May 2017, at 2:00 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>>
>>
>> Dear Sir / madam,
>>
>> Please see the attachment.
>>
>> I have a problem I want to copy data base on the Person name which i
>> highlighted with yellow colour.
>> suppose if the person name "JKM" a sheet will created with the name "JKM"
>> and the entire rows data relating to Jkm WILL copy to the new sheets of
>> JKM.  if the person name is HM the the same rule will be follow.
>>
>> Please help
>>
>> Thanking you
>>
>> SANJIB CHATTERJEE
>>
>>
>>
>> --
>> -
>>
>> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
-

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA

[Sanjib Chatterjee]

thak you very much

On Sat, Jul 30, 2016 at 1:55 PM, Abhishek Jain 
wrote:

> Under Condition Formatting Tab, I have put 2 conditions. Please see under
> Conditional Format > Manage Rules
>
> Screenshot attached.
>
>
>
> On Sat, Jul 30, 2016 at 12:55 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Abhishek Jain,
>>
>> Many Many thank you for solving the problem.  But will great pleasure if
>> you show me the step
>>
>> Regards,
>>
>> Sanjib
>>
>> On Fri, Jul 29, 2016 at 5:34 PM, Abhishek Jain 
>> wrote:
>>
>>>
>>>
>>> On Fri, Jul 29, 2016 at 4:13 PM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>>
>>>> Dear All
>>>>
>>>> Please see the attachment and solve the problem .
>>>>
>>>> Sanjib
>>>>
>>>>
>>>>
>>>> --
>>>> -
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> -
>>
>
>


-- 
-

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA

[Sanjib Chatterjee]

Abhishek Jain,

Many Many thank you for solving the problem.  But will great pleasure if
you show me the step

Regards,

Sanjib

On Fri, Jul 29, 2016 at 5:34 PM, Abhishek Jain 
wrote:

>
>
> On Fri, Jul 29, 2016 at 4:13 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear All
>>
>> Please see the attachment and solve the problem .
>>
>> Sanjib
>>
>>
>>
>> --
>> -
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
-

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

FORUM RULES

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

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

$$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA

[Sanjib Chatterjee]

Dear All

Please see the attachment and solve the problem .

Sanjib



-- 
-

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

FORUM RULES

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

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


please solve.xlsx
Description: MS-Excel 2007 spreadsheet

$$Excel-Macros$$ Conditional format base on two criteria

[Sanjib Chatterjee]

Dear Sir / Madam,

Please solve the attached excel sheet and please solve the problem

Thanking you

Sanjib Chatterjee



-- 
-

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

FORUM RULES

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

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


please solve.docx
Description: MS-Word 2007 document

Fwd: $$Excel-Macros$$ cut option is disable in excel 2003

[Sanjib Chatterjee]

Dear Sir / madam,

Please help
-- Forwarded message --
From: Sanjib Chatterjee 
Date: Mon, Jul 20, 2015 at 10:44 AM
Subject: $$Excel-Macros$$ cut option is disable in excel 2003
To: excel-macros ,
excelvbacli...@googlegroups.com


Dear Sir / Madam,

I am using Ms Office 2003, When I trying to use cut option in excel it
shows disable in excel while in the other application in ms office 2003 it
is working fine.  But if i use keyboard it is working fine even in excel
 Please help how to enable the option.

Thanking you in advance

Sanjib Chatterjee





-- 
-

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

FORUM RULES

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

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



-- 
-

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

FORUM RULES

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

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

$$Excel-Macros$$ cut option is disable in excel 2003

[Sanjib Chatterjee]

Dear Sir / Madam,

I am using Ms Office 2003, When I trying to use cut option in excel it
shows disable in excel while in the other application in ms office 2003 it
is working fine.  But if i use keyboard it is working fine even in excel
 Please help how to enable the option.

Thanking you in advance

Sanjib Chatterjee





-- 
-

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Formula Needed Please

[Sanjib Chatterjee]

please check the attachment


On Fri, Mar 13, 2015 at 11:58 AM, Will Sob  wrote:

>
> Hi,
> Please I need help with the attached file. I want a that calculates how
> many times 10, 13, 17 has appeared within the range D5:I32
>
>
>
>
>
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
-

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

FORUM RULES

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

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


Paks.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Fwd: Delivery Status Notification (Delay)

[Sanjib Chatterjee]

Dear

Please go through the mail.  I need a solution without vba.  Is there any
solution to solve the problem ?

Thanking you in advance

sanjib
-- Forwarded message --
From: Mail Delivery Subsystem 
Date: Wed, Mar 4, 2015 at 3:16 PM
Subject: Delivery Status Notification (Delay)
To: chatterjee.kolk...@gmail.com


This is an automatically generated Delivery Status Notification

THIS IS A WARNING MESSAGE ONLY.

YOU DO NOT NEED TO RESEND YOUR MESSAGE.

Delivery to the following recipient has been delayed:

 noorain.ans...@gmail.co

Message will be retried for 2 more day(s)

Technical details of temporary failure:
The recipient server did not accept our requests to connect. Learn more at
http://support.google.com/mail/bin/answer.py?answer=7720
[(0) gmail.co. [2a00:1450:4010:c04::12]:25: socket error]
[(0) gmail.co. [74.125.143.18]:25: socket error]
[(0) gmail.co. [74.125.143.83]:25: socket error]
[(0) gmail.co. [74.125.143.19]:25: socket error]
[(0) gmail.co. [74.125.143.17]:25: socket error]

- Original message -

DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20120113;
h=mime-version:date:message-id:subject:from:to:content-type;
bh=VUrW0EQ667JPmmGpJ9EBZoLcm0ELZWpXCt/77gSCJ24=;
b=WZtOmkBIsttWI12EuzNet1MMr7mfHDgDksFxfb2h5HpxXObI4xA3lUeUB8MLxfLLuA

 NCdlmxQyrH/CUHkS96F/YqCgkqt0nFP9LglShuJhQg/sX864qXLLirqqTiUJrx5PTZyq

 9YwVIvkYNFM74Y/RNgs4jhzVnC+6+lZjMi9OhP+MgnjR1ZrppX98VSuNRrYG7CHEyTU0

 YSNX7TLoBroIohYot6au3Pur/Gt4hCn0ZFUWdlSgJpALtK4DkWPBBnBcQ+LzILvKLk++

 BucbLB5XWBXyza7t/GI3N7DNfRF1q3Exg3evEKlbcwRTVXceI+TtDtFa3LOzlEUHx9wD
 O5pg==
MIME-Version: 1.0
X-Received: by 10.152.45.1 with SMTP id i1mr27971126lam.61.1425374490724;
Tue,
 03 Mar 2015 01:21:30 -0800 (PST)
Received: by 10.112.132.5 with HTTP; Tue, 3 Mar 2015 01:21:30 -0800 (PST)
Date: Tue, 3 Mar 2015 14:51:30 +0530
Message-ID: <
ca+rktjy5eehdfdj3cmz0fj9pgave7jyv2vj2jlq_2l5hqed...@mail.gmail.com>
Subject: need solution without vba function
From: Sanjib Chatterjee 
To: excel-macros , NOORAIN ANSARI <
noorain.ans...@gmail.co>,
NOORAIN ANSARI 
Content-Type: multipart/mixed; boundary=001a11c27c84312dcd05105edc8e

Dear Sir / Madam,

Please see the attachment and give a solution.  is there any option without
the vba function

--
-



-- 
-

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

FORUM RULES

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

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

Fwd: $$Excel-Macros$$ need solution without vba function

[Sanjib Chatterjee]

-- Forwarded message --
From: Sanjib Chatterjee 
Date: Tue, Mar 3, 2015 at 2:51 PM
Subject: $$Excel-Macros$$ need solution without vba function
To: excel-macros , NOORAIN ANSARI <
noorain.ans...@gmail.co>, NOORAIN ANSARI 


Dear Sir / Madam,

Please see the attachment and give a solution.  is there any option without
the vba function

-- 
-

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

FORUM RULES

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

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



-- 
-

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

FORUM RULES

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

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


Book1.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ need solution without vba function

[Sanjib Chatterjee]

Dear Sir / Madam,

Please see the attachment and give a solution.  is there any option without
the vba function

-- 
-

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

FORUM RULES

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

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


Book1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

[Sanjib Chatterjee]

Dear All,

I am Sanjib Chatterjee from Kolkata, West Bengal.  I am Working in

On Thu, Nov 13, 2014 at 3:19 PM, Vaibhav Joshi  wrote:

> Cheers Mandeep !!
> On Nov 13, 2014 2:29 PM, "Mandeep Baluja"  wrote:
>
>> Hello All,
>>
>> My name is Mandeep , I have been working as a MIS Executive since 1 year.
>> I have keen interest in excel and love the power of VBA. Hope I will help
>> you in some of your issues.
>>
>> Regards,
>> Mandeep Baluja
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
-

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

FORUM RULES

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

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

$$Excel-Macros$$ Fwd: [EXCEL-VBA CLINIC] Fwd: !! Happy New Year 2015 !!

[Sanjib Chatterjee]

happy new year and wish you all the best in life in 2015
-- Forwarded message --
From: pankaj soni 
Date: Thu, Jan 1, 2015 at 11:10 AM
Subject: Re: [EXCEL-VBA CLINIC] Fwd: !! Happy New Year 2015 !!
To: "Mr. YADAV" 
Cc: Suraj kumar bharti , xlvbaclinic <
xlvbacli...@googlegroups.com>, NOORAIN ANSARI ,
neel negi , accesssqlcli...@googlegroups.com


On 01-Jan-2015 10:49 AM, "Mr. YADAV"  wrote:

> Wishing to all of you happy new year t
> On 31 Dec 2014 23:54, "Suraj kumar bharti" 
> wrote:
>
>> Happy new Year 2015
>>
>> 2014-12-31 22:07 GMT+05:30 neel negi :
>>
>>> mast poem hai noorain sir
>>>
>>> Wish u a happy new year 2015
>>>
>>> Aside to group- happy new year 2015
>>>
>>> thanx
>>> vijender negi
>>>
>>> On 12/31/14, NOORAIN ANSARI  wrote:
>>> > छोडो यारों Tension.
>>> > बहूत हुआ Attention.
>>> >   मस्ती  का गाओ Song
>>> >क्या Right क्या Wrong .
>>> > मन के Folder से कर दो Lazypan को Clean
>>> >Wish  You a Happy  New  Year **2015 **
>>> >
>>> >जाने या अंजाने, ढूंढो हसने के नए बहाने.
>>> >बीत गया सो OLD, बनाओ फ्यूचर को तुम gold
>>> >क्या अपना क्या बेगाना,लूटावो प्यार का खज़ाना.
>>> > ताकि हर रात बने दिवाली,ईद बने हर दिन.
>>> > Wish You a Happy  New  Year **2015 **
>>> >
>>> >
>>> >
>>> >माना की बेदर्द है महंगाई,पर जीवन जीना है सच्चाई.
>>> >  अपनाओ कोई भी हथकंडा,पर उत्साह को मत होने दो ठंडा.
>>> >मिटे न होंठो से मुस्कान, पूरा हो हर दिल का अरमान.
>>> > Life के हर जंग में, सदा आपका, हो Win .
>>> > Wish  You a Happy  New  Year **2015 **
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > [image:
>>> >
>>> http://4.bp.blogspot.com/--e3Fz6mofe8/VE6IlQjkAMI/E7g/213GVrlH0hA/s1600/happy%2Bnew%2Byear%2B2015.jpg
>>> ]
>>> > <
>>> http://www.google.co.in/url?sa=i&source=images&cd=&cad=rja&uact=8&ved=0CAgQjRw&url=http%3A%2F%2Fwww.happynewyear2015pictures.net%2F&ei=6L2jVNryL9aIuASP64GIDw&psig=AFQjCNFemhD_cDVpM53jsFZm8RcmEMK1Jg&ust=1420103528897549
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > [image:
>>> >
>>> http://ts1.mm.bing.net/th?&id=HN.607986972312603591&w=300&h=300&c=0&pid=1.9&rs=0&p=0&url=https%3A%2F%2Fwww.facebook.com%2FMISTrainingInstitute
>>> ]
>>> >
>>> > [image: cid:image007.jpg@01CF42D6.7A3E6DE0]
>>> >
>>> >
>>> > Noorain Ansari
>>> > www.noorainansari.com | www.excelvbaclinic.com
>>> > P: +91 9911176564 | M:+91 9711866045
>>> >
>>> > --
>>> > You received this message because you are subscribed to the Google
>>> Groups
>>> > "[EXCEL-VBA CLINIC]" group.
>>> > To unsubscribe from this group and stop receiving emails from it, send
>>> an
>>> > email to xlvbaclinic+unsubscr...@googlegroups.com.
>>> > To post to this group, send an email to xlvbacli...@googlegroups.com.
>>> > Visit this group at http://groups.google.com/group/xlvbaclinic.
>>> > To view this discussion on the web, visit
>>> >
>>> https://groups.google.com/d/msgid/xlvbaclinic/CAHbGxS%3DrkzogkK55pa_5DuHvxYe_oNtZ2RQA6iQWno_O8UVjBA%40mail.gmail.com
>>> .
>>> > For more options, visit https://groups.google.com/d/optout.
>>> >
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "[EXCEL-VBA CLINIC]" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to xlvbaclinic+unsubscr...@googlegroups.com.
>>> To post to this group, send an email to xlvbacli...@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/xlvbaclinic.
>>> To view this discussion on the web, visit
>>> https://groups.google.com/d/msgid/xlvbaclinic/CADj1exDhHUeSqXfJY%3D8-XjUy-2eN%2B3hiDMJ_R8MRSNoO93rcwg%40mail.gmail.com
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Thanks
>> Suraj Kumar Bharti
>> Email  :surajkumarbhart...@gmail.com 
>> Mobile : +91-9313766190
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "[EXCEL-VBA CLINIC]" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to xlvbaclinic+unsubscr...@googlegroups.com.
>> To post to this group, send email to xlvbacli...@googlegroups.com.
>> Visit this group at http://groups.google.com/group/xlvbaclinic.
>> To view this discussion on the web, visit
>> https://groups.google.com/d/msgid/xlvbaclinic/CAAkD%2BC6a%3DJzFTdHb-sAER6mks3C8A53_aueTsKa92WQ5HorrSw%40mail.gmail.com
>> 
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>  --
> You received this message because you are subscribed to the Google Groups
> "[EXCEL-VBA CLINIC]" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to xlvbaclinic+unsubscr...@googlegroups.com.
> To post to this group, send email to xlvbacli...@googlegroups.com.
> Visit this group at http://groups.google.com/group/xlvbaclinic.
> To view this discussion on the web, visit
> h

$$Excel-Macros$$ regarding international process

[Sanjib Chatterjee]

Dear Sir / Madam,

Can anybody explain what is International Process and What kind of Jobs
they are doing?

-- 
-

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ client wise dropdownlist in column b

[Sanjib Chatterjee]

Dear Waseem Saifi,

Thank you for your quick reply.  But if the client name is more than 1000
then how to solve the problem?  Am i need to write client name thousand
time.  It will be time consuming.  Please help me to solve the problem .
 But after all your solution is very much appreciable.

Many many thank you.  Please give another solution


Thanking you in advance

Sanjib





On Mon, Jun 30, 2014 at 11:53 PM, Waseem Saifi 
wrote:

> PFA
> It might help you.
>
>
> On Mon, Jun 30, 2014 at 4:17 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Sir / Madam,
>>
>> Please see the attachment. There could be thousand clients with their
>> banks.  I want wnen I put the client name in the column a, there will be
>> dropdown list in the column B.  All the bank name  will be shown in the
>> dropdown list of correspondence client name
>>
>> Thanking you in Advance
>>
>> Sanjib
>>
>>
>>
>> --
>> -
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
-

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

FORUM RULES

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

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

$$Excel-Macros$$ client wise dropdownlist in column b

[Sanjib Chatterjee]

Dear Sir / Madam,

Please see the attachment. There could be thousand clients with their
banks.  I want wnen I put the client name in the column a, there will be
dropdown list in the column B.  All the bank name  will be shown in the
dropdown list of correspondence client name

Thanking you in Advance

Sanjib



-- 
-

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

FORUM RULES

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

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


dropdown list.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ need some help from two tables

[Sanjib Chatterjee]

Dear Sir / Madam,

Please see the attachment.  There is two table marked with yellow and blue.

Both tables has one common field that is Account Code.  All the field is
present in table yellow.  But some field may or may have not present in
table blue.  I want  If table blue Account code is matched with Table
yellow's Account Code then their will be adjustment in the field called
"Net" which is market with green. That is Table yellow's Amount - Table
blue's Amount.



Thanking you in Advance

Regds,

Sanjib





-- 
-

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

FORUM RULES

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

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


sample file.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ regarding vlookup and wildcard function

[Sanjib Chatterjee]

thank you


On Fri, May 9, 2014 at 6:46 PM, Vaibhav Joshi  wrote:

> Hi
>
> It is because you have not referred correct row, when you are in row 4,
> you should refer to row 4 in column A, but in your case you are referring
> to one row above.
>
> See attached file.
>
> HTH//Cheers
>
>
> On Fri, May 9, 2014 at 2:02 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Sir / Madam,
>>
>> Here find the attachment, for your quick search i just hide the correct
>> portion in the excel sheet
>> otherwise it it working fine i have highlighted only the incorrect
>> portion.  Please see and help.
>>
>> Thanking you in advance
>>
>>
>> Regds,
>>
>> Sanjib
>>
>>
>>
>> --
>> -
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
-

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

FORUM RULES

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

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

$$Excel-Macros$$ regarding not send any mail to Dinesh Kumar

[Sanjib Chatterjee]

It is jut a reply to your mail Mr Dinesh Kumar.  why not sent any mail?  My
intention was not sent you any mail, as you are registered with the excel
group the mail I sent the group automatically sent to you.  As I am a
member of the excel group I will send to group whenever I required, but If
you not want to received my mail please keep me block.

Any inconvenience caused is sincerely regret.


Thanking you

Sanjib







-- 
-

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

FORUM RULES

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

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

$$Excel-Macros$$ Re: [XL-VBA Clinic] regarding vlookup and wildcard function

[Sanjib Chatterjee]

Dear Sir / Madam,

Thank you for your quick reply.

Regds,

Sanjib






On Fri, May 9, 2014 at 1:30 PM, Rajeev Kumar
wrote:

> Dear Sanjib,
>
>
>
> Please use below formula
>
>
>
>
>
> =VLOOKUP("*"&LEFT(E1,4)&"*",LIST,2,0)
>
>
>
>
>
> Thanks & Regards
>
> Rajeev Kumar
>
>
>
> *Gurgaon*
>
> A 10 Infocity, Sector 34
>
> Gurgaon, Haryana 122001
>
> * M +91 8512896744 *|*T* +91 124 4149339
>
>
>
>  [image: Description: Description: cid:image001.jpg@01CDBB33.DA2E0E30]
>
>
>
>
>
> *Bangalore | Delhi | **Gurgaon** | Hyderabad | Mumbai*
>
>
>
> *Awarded Runners up Asia Pacific Customer Relationship of the Year 2012-13
> by HROA*
>
>
>
> *From:* excelvbacli...@googlegroups.com [mailto:
> excelvbacli...@googlegroups.com] *On Behalf Of *Sanjib Chatterjee
> *Sent:* Friday, May 09, 2014 1:16 PM
> *To:* excel-macros; excelvbacli...@googlegroups.com; RANJAN VERMA;
> NOORAIN ANSARI
> *Subject:* [XL-VBA Clinic] regarding vlookup and wildcard function
>
>
>
>
> Dear Sir / Madam,
>
>
>
> Please see the attachment and help me to solve the problem
>
>
>
> Thank you in advance
>
>
>
> Regards
>
>
>
> Sanjib
>
>
>
>
>
> --
> -
>
> --
>
> --
> To post to this group, send email:
> excelvbacli...@googlegroups.com
> To unsubscribe from this group, send email
> excelvbaclinic+unsubscr...@googlegroups.com
>
> For more options, visit this group at
> http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
> ---
> You received this message because you are subscribed to the Google Groups
> "Excelvbaclinic" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excelvbaclinic+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
>  --
>
> --
> To post to this group, send email:
> excelvbacli...@googlegroups.com
> To unsubscribe from this group, send email
> excelvbaclinic+unsubscr...@googlegroups.com
>
> For more options, visit this group at
> http://groups.google.com/group/excelvbaclinic?hl=en?hl=en
> ---
> You received this message because you are subscribed to the Google Groups
> "Excelvbaclinic" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excelvbaclinic+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
-

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

FORUM RULES

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

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

$$Excel-Macros$$ regarding vlookup and wildcard function

[Sanjib Chatterjee]

Dear Sir / Madam,

Please see the attachment and help me to solve the problem

Thank you in advance

Regards

Sanjib


-- 
-

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

FORUM RULES

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

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


REMISERFIND.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ HAPPY NEW YEAR 2014

[Sanjib Chatterjee]

Wish you a happy a glorious new year 2014 and all the best for the coming
year

-- 
-

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ regarding use of double minus

[Sanjib Chatterjee]

Thank you sir

Regards,

Sanjib



On Sat, Oct 6, 2012 at 8:46 PM, ashish koul  wrote:

> visit
> http://www.excelbanter.com/showthread.php?t=182549
>
>
>
> On Sat, Oct 6, 2012 at 2:22 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Noorain Ansari,
>>
>> Would you please tell why have you used the -- sing in the formula.  for
>> you reference i have highlighted
>> the portion..
>>
>> *=SUMPRODUCT(**--**(B4:B14="Karthik")*($C$4:$C$14="Collected"))*
>>
>>
>> Thanking you
>>
>>
>> Regards,
>>
>> Sanjib
>>
>>
>> --
>> -
>>
>> --
>> Join official facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES (1120+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> 6) Jobs posting is not allowed.
>>
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
>  --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
-

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ regarding use of double minus

[Sanjib Chatterjee]

Dear Noorain Ansari,

Would you please tell why have you used the -- sing in the formula.  for
you reference i have highlighted
the portion..

*=SUMPRODUCT(**--**(B4:B14="Karthik")*($C$4:$C$14="Collected"))*


Thanking you


Regards,

Sanjib


-- 
-

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

Fwd: $$Excel-Macros$$ Excel Dashboard with example

[Sanjib Chatterjee]

Dear Sirs,

I show the *Chandoo.Org.  *There is nice example but I can not understand
how to prepare it.
Would u Please explain me the steps with a single example.

Thanking you

Regards,

Sanjib






-- Forwarded message --
From: Kuldeep Singh 
Date: Fri, Sep 21, 2012 at 9:36 AM
Subject: Re: $$Excel-Macros$$ Excel Dashboard with example
To: excel-macros@googlegroups.com



Hi see below link:

http://chandoo.org/wp/excel-dashboards/

Regards,
Kuldeep Singh


On Thu, Sep 20, 2012 at 7:03 PM, Rajan_Verma wrote:

> * *
>
> *Visit Chandoo.Org*
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU)
> *Sent:* 20 September 2012 9:05
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Excel Dashboard with example
>
> ** **
>
> Dear All,
>
> ** **
>
> Please share Excel dashboard macro with example.
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> ** **
> --
>
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>  
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
 --
Join official facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

5) Cross-promotion of, or links

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

[Sanjib Chatterjee]

Dear Noorain Ansari

Congratulation for your achievement.  As I stated early that you are the
God of Excel.  Please keep it going so that many excel lovers are get help.

Thanking you

Regards,

Sanjib Chatterjee


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

> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum members
> through his excel expertise.
>
> I truly appreciate his consistency and commitment to the group. He is
> really doing great job.
>
> Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince,
> Sunita and other folks for helping excel enthusiasts voluntarily !!
> Keep posting.
>
> Regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
>
>



-- 
-

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Mails IDs from Outlook

[Sanjib Chatterjee]

Just follow follow the link

http://support.microsoft.com/kb/295664

On Thu, Jul 5, 2012 at 3:52 PM, Rohan Young  wrote:

> Dear Group,
>
> how can i get all mail IDs  from my outlook to excel to make a list of
> all IDs and Co., please help me out
>
> Thanks & Regds
>
> ROHAN
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
-

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

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

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

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

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

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

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

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

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

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

[Sanjib Chatterjee]

cong both of you

Regards,

Sanjib


On Wed, Jul 4, 2012 at 8:45 PM, Divaker Pandey  wrote:

> *Congrats..Ashish & Dilip, for your gr8 Achievement.*
>
> But it will be awesome.if you explore with group member, your journey to
> plan, execution and finally getting award.
>
> Hope another group member can get this award.
>
> Divaker
>
> On Wed, Jul 4, 2012 at 2:02 PM, NRao Mynampati 
> wrote:
>
>> Congaratulation Ashish and Dilip
>>
>>
>> On Tue, Jul 3, 2012 at 12:17 PM, Excel Vba wrote:
>>
>>> Congrats both of them. God bless..
>>>
>>>
>>>
>>> On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote:
>>>
 Dear members,

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

 Keep posting !

 Best regards,
 Ayush Jain
 Group Manager
 Microsoft MVP




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

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

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

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

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

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

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


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

 To unsubscribe, send a blank email to
 excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June '12)

[Sanjib Chatterjee]

Cong Mr. Ranjan Verma.  Hoping for the est of life.

Regds,

Sanjib


On Wed, Jul 4, 2012 at 10:18 PM, Born to Win  wrote:

> Congrats Ranjan...j
>
> have seen really great commitment towards group.
>
> and helping us with your expertise.
>
>
> Cheer's,
> CS
>
>
>
> On Wed, Jul 4, 2012 at 9:50 PM, Hilary Lomotey  wrote:
>
>> Congrats Raj, keep it up
>>
>>
>> On Wed, Jul 4, 2012 at 4:16 PM, Ayush Jain  wrote:
>>
>>> Hello Everyone,
>>>
>>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>>> June'2012. This is third time in row. :)
>>> He has posted 149 posts in June 2012 and helped many people through his
>>> expertise.
>>>
>>> I truly appreciate his consistency and commitment to group. He is really
>>> doing great job.
>>>
>>> Thanks to Noorain, Deba Ranjan, Don, David, Lalit, Lokesh, Hilary, Asa
>>> and other folks for helping excel enthusiasts voluntarily !! Keep it up !!
>>>
>>> Keep posting.
>>>
>>> Regards
>>> Ayush Jain
>>> Group Manager , Microsoft MVP
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
-

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

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

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

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

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

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

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

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

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

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

[Sanjib Chatterjee]

congratulation both of you

Regards,

Sanjib

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

> Dear members,
>
> I am extremely happy to inform you that two members of the group are
> awarded Microsoft Most Valuable Professional Award.
> My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and
> thanks for their big support to this forum.
>
> Keep posting !
>
> Best regards,
> Ayush Jain
> Group Manager
> Microsoft MVP
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
-

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Re: Regarding control tab in the scroll bar

[Sanjib Chatterjee]

Many many thank you

Regards,

Sanjib


On Tue, Jun 26, 2012 at 2:37 PM, Rajan_Verma wrote:

> Hi
> In Developer Tab
> Goto Insert -> More Controll ( Bottom Right) then Find Microsoft ScrollBar
>
> Rajan.
>
>
> On Tuesday, 26 June 2012 14:09:19 UTC+5:30, friend wrote:
>
>>
>> Dear Sir/ Madam,
>>
>> Please see the attachment, I can not find the control tab in the format
>> control
>> of the scroll bar.
>>
>> Please help
>>
>> Thanking you
>>
>> Regard
>>
>> Sanjib
>>
>>
>> --
>> -
>>
>  --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
-

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Run Macro at OPEN of an Excel file

[Sanjib Chatterjee]

Dear Amit,

pest the code in the in vba

Private Sub Workbook_Open()

your code()

End Sub


On Mon, Jun 25, 2012 at 1:26 PM, Amit Gandhi  wrote:

> Hi Experts
>
> Pls help me with a way, so that a Macro runs whenever I open a particular
> excel file. (Macro is in that excel file only).
>
>
> Regards
>
> Amit
>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> --
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com




-- 
-

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ regarding font color based condition

[Sanjib Chatterjee]

Dear Sir,

I have go through the below mentioned link.  but i  can not understand.
Would you
please explain why we need to use the *=Get.cell(24,indirect("RC[-1]",))

function?  Another how to use the formula in other sheet.

regds,

sanjib


*
On Tue, May 29, 2012 at 3:26 PM, NOORAIN ANSARI wrote:

> Dear Sanjib,
>
> Please check below link..*
> *Hope it will help you to use Get.Cell Function.
> *
> http://www.sulprobil.com/html/get_cell.html*
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, May 29, 2012 at 3:23 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Nooranin Ansari,
>>
>> This is working fine.  But would you explain the below  mentioned
>> formula.
>>
>> You have mentioned the formula outside the date zone even.  If i want to
>> use the formula
>> in another sheets how to use it?
>>
>> Waiting for you reply.
>>
>> Regards,
>>
>> Sanjib
>>
>>
>> On Tue, May 29, 2012 at 3:08 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Sanjib,
>>>
>>> Please use below formula through define Name
>>>
>>> *=Get.cell(24,indirect("RC[-1]",))*
>>>
>>> See attached sheet.
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>> www.noorainansari.com
>>> www.excelmacroworld.blogspot.com
>>>
>>>
>>> On Tue, May 29, 2012 at 1:54 PM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>> Dear Sir / Madam,
>>>>
>>>> Please see the attachment.  I have given you only 10 or 12 data.  But
>>>> there could have been more
>>>> than 5000 rows of data.  I want if cell color is red in column A then
>>>> automatically it  will be indicating
>>>> no is column B.
>>>>
>>>> Thanking you
>>>>
>>>> Regards,
>>>>
>>>> Sanjib
>>>>
>>>>
>>>> --
>>>> -
>>>>
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> --
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> To unsubscribe, send a blank email to
>>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>>
>>>
>>>
>>>
>>>
>>>  --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>>
>>
>> --
>> -
>>
>
>
>
>
>
>
>


-- 
-

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ regarding font color based condition

[Sanjib Chatterjee]

Dear Nooranin Ansari,

This is working fine.  But would you explain the below  mentioned formula.

You have mentioned the formula outside the date zone even.  If i want to
use the formula
in another sheets how to use it?

Waiting for you reply.

Regards,

Sanjib


On Tue, May 29, 2012 at 3:08 PM, NOORAIN ANSARI wrote:

> Dear Sanjib,
>
> Please use below formula through define Name
>
> *=Get.cell(24,indirect("RC[-1]",))*
>
> See attached sheet.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> On Tue, May 29, 2012 at 1:54 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Sir / Madam,
>>
>> Please see the attachment.  I have given you only 10 or 12 data.  But
>> there could have been more
>> than 5000 rows of data.  I want if cell color is red in column A then
>> automatically it  will be indicating
>> no is column B.
>>
>> Thanking you
>>
>> Regards,
>>
>> Sanjib
>>
>>
>> --
>> -
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Row to repeat at the bottom of each page

[Sanjib Chatterjee]

Dear Siraj Momin,

please follow the steps

1. go to file
2. paresetup
3. choose sheets
4 rows to repeat at top
ok

regards,

Sanjib


On Thu, May 17, 2012 at 11:17 AM, Siraj Momin (BTG)  wrote:

> Dear Excel Group Friends
>
> ** **
>
> Is there any way that certain rows of a sheet is repeated at the bottom of
> each page……
>
> ** **
>
> ** **
>
> ** **
>
> Siraj
>
> ** **
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Financial Analysis Dashboard

[Sanjib Chatterjee]

The file is blocking by the antivirous for suspecting virus.

regds,

Sanjib

On Mon, Apr 30, 2012 at 10:07 PM, hilary lomotey  wrote:

> Hi Guys,
>
> i just completed my Financial Analysis Dashboard, pls have a look at it at
> the address below
>
> cheers
>
> http://www.sendspace.com/file/tlim30
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Fwd: $$Excel-Macros$$ Format cells for Number

[Sanjib Chatterjee]

please check the attachment

regards

Sanjib


-- Forwarded message --
From: Ashish Bhalara 
Date: Tue, Apr 17, 2012 at 11:56 AM
Subject: $$Excel-Macros$$ Format cells for Number
To: excel-macros@googlegroups.com


Dear expert,

Is there any formula to written in cells format for the positive value
display as 1234 Dr and for negative value display as 1234 Cr ?

Thanks & regards

Ashish Bhalara
9099098307


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

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

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

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

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

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

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

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



-- 
-

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

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

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

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

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

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

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

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


calculated of dr and cr method 2 using if.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ regarding pivot table problem

[Sanjib Chatterjee]

Dear Shaik Waheed,

I am unable to put any formula in the pivot table.

Please help.

Thanking you in advance

Regards

Sanjib
- Show quoted text -


On Wed, Apr 11, 2012 at 3:13 PM, Shaik Waheed  wrote:

> One more thing, i have observed that the amount total is not matching for
> this u need to enter the "S" amount in positive only...the formula then
> calcuates.
> "
>
> On Wed, Apr 11, 2012 at 3:10 PM, Shaik Waheed wrote:
>
>> Sanjib,
>>
>> Click on the pivot, on the toolbar, click on options --- >Formulas --->
>> list of formulas ---> there u can see i have added a formual "Net Quantity"
>> = B- S.
>>
>> To add a formula u need to click on the items in the pivot
>> -->Toolbar(above) --> formulas--> Calculate Item---> u can enter the
>> required formula..
>>
>> Hope i explained it...
>>
>>
>>
>> On Wed, Apr 11, 2012 at 2:41 PM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>> explain only the highlighted portion
>>>
>>> thanking you in Advance
>>>
>>> Regards,
>>>
>>> Sanjib
>>>
>>>
>>>
>>> On Wed, Apr 11, 2012 at 2:34 PM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>> yes, This is is excetly what I am looking for.
>>>> would you explain please.
>>>>
>>>> regards,
>>>>
>>>> sanjib
>>>>
>>>>
>>>> On Wed, Apr 11, 2012 at 12:45 PM, Shaik Waheed wrote:
>>>>
>>>>> Hi Sanjib,
>>>>>
>>>>> PFA check sheet 2. Hope this helps
>>>>>
>>>>>   On Wed, Apr 11, 2012 at 10:54 AM, Sanjib Chatterjee <
>>>>> chatterjee.kolk...@gmail.com> wrote:
>>>>>
>>>>>>
>>>>>> Dear Sir,
>>>>>>
>>>>>> Your work is really great and appreciable,  But I have given you only
>>>>>> 4 or 5 scripts.  There could have been more than 1500+ scripts.  In that
>>>>>> case pivot table is excellent.  So is there
>>>>>> any option to do the task with the help of pivot table?
>>>>>>
>>>>>> Thanking you in Advance.
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Sanjib
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------ Forwarded message --
>>>>>> From: Shaik Waheed 
>>>>>> Date: Tue, Apr 10, 2012 at 7:06 PM
>>>>>> Subject: Re: $$Excel-Macros$$ regarding pivot table problem
>>>>>> To: excel-macros@googlegroups.com
>>>>>>
>>>>>>
>>>>>> Hi Sanjib,
>>>>>>
>>>>>> PFA, is it this you want? I had just given a try
>>>>>>
>>>>>> On Mon, Apr 9, 2012 at 5:36 PM, Sanjib Chatterjee <
>>>>>> chatterjee.kolk...@gmail.com> wrote:
>>>>>>
>>>>>>> Dear Mr. Sourbh Salgotra,
>>>>>>>
>>>>>>> I am already done it please check my attachment..  But I want rather
>>>>>>> differently which
>>>>>>> I mentioned.
>>>>>>>
>>>>>>> Thanking you
>>>>>>>
>>>>>>> Sanjib
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Mon, Apr 9, 2012 at 5:28 PM, Sourabh Salgotra <
>>>>>>> rhtdmja...@gmail.com> wrote:
>>>>>>>
>>>>>>>> plz check attachement
>>>>>>>>
>>>>>>>> On Mon, Apr 9, 2012 at 4:48 PM, Sanjib Chatterjee <
>>>>>>>> chatterjee.kolk...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>>
>>>>>>>>> Dear Sir,
>>>>>>>>> previously i sent you the mail.  But I got the error message that
>>>>>>>>> the message I am sending
>>>>>>>>> is cross the allocated limit so I am sending you the fresh
>>>>>>>>> message.
>>>>>>>>>
>>>>>>>>> Please see the attachment.  I have created the Pivot table based
>>>>>>>>> on the data of sheet1.  Th

Re: $$Excel-Macros$$ regarding pivot table problem

[Sanjib Chatterjee]

Dear Shaik Waheed,

I am unable to put any formula in the pivot table.

Please help.

Thanking you in advance

Regards

Sanjib



On Wed, Apr 11, 2012 at 3:13 PM, Shaik Waheed  wrote:

> One more thing, i have observed that the amount total is not matching for
> this u need to enter the "S" amount in positive only...the formula then
> calcuates.
> "
>
> On Wed, Apr 11, 2012 at 3:10 PM, Shaik Waheed wrote:
>
>> Sanjib,
>>
>> Click on the pivot, on the toolbar, click on options --- >Formulas --->
>> list of formulas ---> there u can see i have added a formual "Net Quantity"
>> = B- S.
>>
>> To add a formula u need to click on the items in the pivot
>> -->Toolbar(above) --> formulas--> Calculate Item---> u can enter the
>> required formula..
>>
>> Hope i explained it...
>>
>>
>>
>> On Wed, Apr 11, 2012 at 2:41 PM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>> explain only the highlighted portion
>>>
>>> thanking you in Advance
>>>
>>> Regards,
>>>
>>> Sanjib
>>>
>>>
>>>
>>> On Wed, Apr 11, 2012 at 2:34 PM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>> yes, This is is excetly what I am looking for.
>>>> would you explain please.
>>>>
>>>> regards,
>>>>
>>>> sanjib
>>>>
>>>>
>>>> On Wed, Apr 11, 2012 at 12:45 PM, Shaik Waheed wrote:
>>>>
>>>>> Hi Sanjib,
>>>>>
>>>>> PFA check sheet 2. Hope this helps
>>>>>
>>>>>   On Wed, Apr 11, 2012 at 10:54 AM, Sanjib Chatterjee <
>>>>> chatterjee.kolk...@gmail.com> wrote:
>>>>>
>>>>>>
>>>>>> Dear Sir,
>>>>>>
>>>>>> Your work is really great and appreciable,  But I have given you only
>>>>>> 4 or 5 scripts.  There could have been more than 1500+ scripts.  In that
>>>>>> case pivot table is excellent.  So is there
>>>>>> any option to do the task with the help of pivot table?
>>>>>>
>>>>>> Thanking you in Advance.
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Sanjib
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------ Forwarded message --
>>>>>> From: Shaik Waheed 
>>>>>> Date: Tue, Apr 10, 2012 at 7:06 PM
>>>>>> Subject: Re: $$Excel-Macros$$ regarding pivot table problem
>>>>>> To: excel-macros@googlegroups.com
>>>>>>
>>>>>>
>>>>>> Hi Sanjib,
>>>>>>
>>>>>> PFA, is it this you want? I had just given a try
>>>>>>
>>>>>> On Mon, Apr 9, 2012 at 5:36 PM, Sanjib Chatterjee <
>>>>>> chatterjee.kolk...@gmail.com> wrote:
>>>>>>
>>>>>>> Dear Mr. Sourbh Salgotra,
>>>>>>>
>>>>>>> I am already done it please check my attachment..  But I want rather
>>>>>>> differently which
>>>>>>> I mentioned.
>>>>>>>
>>>>>>> Thanking you
>>>>>>>
>>>>>>> Sanjib
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Mon, Apr 9, 2012 at 5:28 PM, Sourabh Salgotra <
>>>>>>> rhtdmja...@gmail.com> wrote:
>>>>>>>
>>>>>>>> plz check attachement
>>>>>>>>
>>>>>>>> On Mon, Apr 9, 2012 at 4:48 PM, Sanjib Chatterjee <
>>>>>>>> chatterjee.kolk...@gmail.com> wrote:
>>>>>>>>
>>>>>>>>>
>>>>>>>>> Dear Sir,
>>>>>>>>> previously i sent you the mail.  But I got the error message that
>>>>>>>>> the message I am sending
>>>>>>>>> is cross the allocated limit so I am sending you the fresh
>>>>>>>>> message.
>>>>>>>>>
>>>>>>>>> Please see the attachment.  I have created the Pivot table based
>>>>>>>>> on the data of sheet1.  Then
>>>>>>>

Re: $$Excel-Macros$$ regarding pivot table problem

[Sanjib Chatterjee]

yes, This is is excetly what I am looking for.
would you explain please.

regards,

sanjib

On Wed, Apr 11, 2012 at 12:45 PM, Shaik Waheed  wrote:

> Hi Sanjib,
>
> PFA check sheet 2. Hope this helps
>
> On Wed, Apr 11, 2012 at 10:54 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Sir,
>>
>> Your work is really great and appreciable,  But I have given you only 4
>> or 5 scripts.  There could have been more than 1500+ scripts.  In that case
>> pivot table is excellent.  So is there
>> any option to do the task with the help of pivot table?
>>
>> Thanking you in Advance.
>>
>> Regards,
>>
>> Sanjib
>>
>>
>>
>>
>> -- Forwarded message --
>> From: Shaik Waheed 
>> Date: Tue, Apr 10, 2012 at 7:06 PM
>> Subject: Re: $$Excel-Macros$$ regarding pivot table problem
>> To: excel-macros@googlegroups.com
>>
>>
>> Hi Sanjib,
>>
>> PFA, is it this you want? I had just given a try
>>
>> On Mon, Apr 9, 2012 at 5:36 PM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>> Dear Mr. Sourbh Salgotra,
>>>
>>> I am already done it please check my attachment..  But I want rather
>>> differently which
>>> I mentioned.
>>>
>>> Thanking you
>>>
>>> Sanjib
>>>
>>>
>>>
>>> On Mon, Apr 9, 2012 at 5:28 PM, Sourabh Salgotra 
>>> wrote:
>>>
>>>> plz check attachement
>>>>
>>>> On Mon, Apr 9, 2012 at 4:48 PM, Sanjib Chatterjee <
>>>> chatterjee.kolk...@gmail.com> wrote:
>>>>
>>>>>
>>>>> Dear Sir,
>>>>> previously i sent you the mail.  But I got the error message that the
>>>>> message I am sending
>>>>> is cross the allocated limit so I am sending you the fresh message.
>>>>>
>>>>> Please see the attachment.  I have created the Pivot table based on
>>>>> the data of sheet1.  Then
>>>>> follow the step for creating pivot table.  But I want in same
>>>>> different format.  In BS column
>>>>> referred to buy and sale of scripts.  If there is B in the column then
>>>>> quantity should be put
>>>>> as buy qty and next buy rate.  If there is S in the column then
>>>>> quantity should be put as
>>>>> sale and next sale rate.  Net qty should be buy - sale quantity.
>>>>>
>>>>> Please help to solve the problem
>>>>>
>>>>> Thanking you in Advance.
>>>>>
>>>>> Sanjib
>>>>>
>>>>>
>>>>> --
>>>>> -
>>>>>
>>>>> --
>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>>
>>>>> 2) Don't post a question in the thread of another member.
>>>>>
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>>
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>
>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>> in signatures are prohibited.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>>
>>>>>
>>>>> --
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> mujhay dukh is baat ka nahin kay meri zaat ko
>>>> muntashir karny walay haath tairy thy
>>>> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
>>>> samaitnay walay haath tairy na thy
>>>>
>>>>
>>>>
>>>> 
>>>>
>>>>
>>>> Thanks & Regards
>>>> Sourabh
>&

Fwd: $$Excel-Macros$$ Fwd: regarding pivot table problem

[Sanjib Chatterjee]

Dear Sir / Madam,

I am facing a problem regarding pivot table.  Please go through the mail .

Waiting for your reply.

Thanking you

Regards,

Sanjib


-- Forwarded message --
From: Sanjib Chatterjee 
Date: Tue, Apr 10, 2012 at 10:24 AM
Subject: $$Excel-Macros$$ Fwd: regarding pivot table problem
To: excel-macros , "noorain.ansari" <
noorain.ans...@gmail.com>


Dear Experts,

Would you please help me regarding the problem.

Thanking you

Sanjib


-- Forwarded message ------
From: Sanjib Chatterjee 
Date: Mon, Apr 9, 2012 at 4:48 PM
Subject: regarding pivot table problem
To: excel-macros 



Dear Sir,
previously i sent you the mail.  But I got the error message that the
message I am sending
is cross the allocated limit so I am sending you the fresh message.

Please see the attachment.  I have created the Pivot table based on the
data of sheet1.  Then
follow the step for creating pivot table.  But I want in same different
format.  In BS column
referred to buy and sale of scripts.  If there is B in the column then
quantity should be put
as buy qty and next buy rate.  If there is S in the column then quantity
should be put as
sale and next sale rate.  Net qty should be buy - sale quantity.

Please help to solve the problem

Thanking you in Advance.

Sanjib


-- 
-



-- 
-

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

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

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

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

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

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

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

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



-- 
-

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

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

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

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

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

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

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

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


Copy of EXAMPLE_VKGOEL.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Fwd: regarding pivot table problem

[Sanjib Chatterjee]

Dear Experts,

Would you please help me regarding the problem.

Thanking you

Sanjib


-- Forwarded message --
From: Sanjib Chatterjee 
Date: Mon, Apr 9, 2012 at 4:48 PM
Subject: regarding pivot table problem
To: excel-macros 



Dear Sir,
previously i sent you the mail.  But I got the error message that the
message I am sending
is cross the allocated limit so I am sending you the fresh message.

Please see the attachment.  I have created the Pivot table based on the
data of sheet1.  Then
follow the step for creating pivot table.  But I want in same different
format.  In BS column
referred to buy and sale of scripts.  If there is B in the column then
quantity should be put
as buy qty and next buy rate.  If there is S in the column then quantity
should be put as
sale and next sale rate.  Net qty should be buy - sale quantity.

Please help to solve the problem

Thanking you in Advance.

Sanjib


-- 
-



-- 
-

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

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

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

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

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

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

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

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


Copy of EXAMPLE_VKGOEL.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ regarding pivot table problem

[Sanjib Chatterjee]

Dear Mr. Sourbh Salgotra,

I am already done it please check my attachment..  But I want rather
differently which
I mentioned.

Thanking you

Sanjib


On Mon, Apr 9, 2012 at 5:28 PM, Sourabh Salgotra wrote:

> plz check attachement
>
> On Mon, Apr 9, 2012 at 4:48 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Sir,
>> previously i sent you the mail.  But I got the error message that the
>> message I am sending
>> is cross the allocated limit so I am sending you the fresh message.
>>
>> Please see the attachment.  I have created the Pivot table based on the
>> data of sheet1.  Then
>> follow the step for creating pivot table.  But I want in same different
>> format.  In BS column
>> referred to buy and sale of scripts.  If there is B in the column then
>> quantity should be put
>> as buy qty and next buy rate.  If there is S in the column then quantity
>> should be put as
>> sale and next sale rate.  Net qty should be buy - sale quantity.
>>
>> Please help to solve the problem
>>
>> Thanking you in Advance.
>>
>> Sanjib
>>
>>
>> --
>> -
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> mujhay dukh is baat ka nahin kay meri zaat ko
> muntashir karny walay haath tairy thy
> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
> samaitnay walay haath tairy na thy
>
>
>
> 
>
>
> Thanks & Regards
> Sourabh
> Contact Numbers: +91-94630-49202
> Website:http://adhurapyaar.co.cc
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

[Sanjib Chatterjee]

you can also assign the macro task

1 select column a
2 press f5
3 press special
4 select blank
5 ok
6 edit menue
7 press delete
8 shift cells up
ok


On Fri, Mar 23, 2012 at 7:04 AM, Jim Schug  wrote:

> Hi,
> I'm nearly brain dead (tired) and can't think straight. I have a simple
> issue. A macro to fill in blank values if found with the value from the
> cell above.
>
> For example
>
> 101
>
>
>
> 1015
>
> Would fill the blank rows with 101 until the next number 1015 is found,
> then it would use 1015 until another number...
>
> A file with sample data is attached. Thanks in advance.
>
>
>
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

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

[Sanjib Chatterjee]

Congratulation for you achievement. Hoping for a good luck.

sanjib

On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain  wrote:

>  Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Feb'12
> He has posted 156 posts in Feb'12 and helped many people through his
> expertise. He has been consistent contributor to this excel forum but has
> acheived this recognition for third time.
>
> *About Noorain Ansari :*
> [image: noorain.jpg]
>
> Noorain is a great poet and keep sharing his thoughts on different topics
> throgh cool poems. Professionally, he is a Excel aficionado and presently
> working as senior business analyst in One97 Communication Ltd. He is a MS
> excel - vba expert and keep sharing his thoughts with this forum. You can
> follow his blogs for Excel knowledge and cool poems :
> www.excel-macro.blogspot.com & www.noorain-ansari.blogspot.com
>
> *Noorain, Many thanks for all your great support to group. Keep it up*
>
> *Thanks everyone for helping excel enthusiasts voluntarily !! Keep it up
> !!
> **
> *Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ how can i convert nomber to test

[Sanjib Chatterjee]

Vic Kumar,

Please see the attachent



On Sat, Feb 25, 2012 at 10:53 PM, Vic Kumar  wrote:

> Hi,
>
> Please advice i need this same macro for converting figures in words
> for Rupees as this macro is working for Dollars only.
>
> Kindly help in this regard.
>
> Regards,
>
> Vikram
>
>
> On 2/23/12, jitendr...@gmail.com  wrote:
> > Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees
> >
> >
> > Mail sent via way2sms.
> >
> > --
> > FORUM RULES (986+ members already BANNED for violation)
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
>
>
> --
> Regards,
>
> Vikram Ahuja
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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


currency to word.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ how can i convert nomber to test

[Sanjib Chatterjee]

On Thu, Feb 23, 2012 at 9:06 AM,  wrote:

> Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees
>
>
> Mail sent via way2sms. 
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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


currency to word.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Rounding Numbers

[Sanjib Chatterjee]

Dear jayaprakash s,

You can use the below mentioned formula

ROUND(A1,-0.2)


sanjib
On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S
wrote:

> Dear Experts,
>
> Good Noon.
>
> Need help on rounding up of numbers based on the decimal through a
> formula...
>
> the criteria for roudning is :
>
> a) Less than or equal to 0.5 should get round down to preceeding
> multiple of Ten (10.1 to 10.5 should be rounded to 10)
>
> b) Greater than or equal to 0.6 should get round up to next multiple
> of Ten (10.6 to 10.9 should rounded to 11).
>
> enclosed excel file for more information.
>
> thank you.
>
> JP.
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ combo box or list box help

[Sanjib Chatterjee]

many many thank you N Ansary for you quick reply

regards,

Sanjib


On Fri, Feb 17, 2012 at 2:02 PM, NOORAIN ANSARI wrote:

> Dear Sanjib,
>
> Please find attachment in 2003 Version.
>
> On Fri, Feb 17, 2012 at 1:16 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear N ANSARI,
>>
>> WOULD YOU PLEASE CREATE THE ATTACH FILE IN 2003 FORMAT.   .
>>
>> THANKING YOU IN ADVANCE.
>>
>> SANJIB
>>
>>
>>
>> On Thu, Feb 16, 2012 at 6:34 PM, NOORAIN ANSARI > > wrote:
>>
>>>
>>> Process
>>>
>>>  1
>>> Drag Combobox From Developer-Insert-Form  2 Select Combobox and goto
>>> Developer-Properties and Select Areal List and select Cell Link Cell  3 
>>> create
>>> formula =ADDRESS(2,8+H1)&":"&ADDRESS(100,8+H1)  4 Create Offset
>>> Function =OFFSET($H$1,0,$H$1,COUNTA(INDIRECT($B$12)),1),Copy it and Paste
>>> in Formula-Define Name and create Name range  5 Again Select Combobox
>>> and goto Developer-propertes and Assign Range Name under Input range
>>>
>>>
>>> Hope my explaination will helpful for you
>>>
>>>
>>> On Thu, Feb 16, 2012 at 5:35 PM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>>
>>>>
>>>> Once again thank you Sir for quick reply.  But would you please show me
>>>> the process.
>>>>
>>>>
>>>> Regards,
>>>>
>>>> Sanjib
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Thu, Feb 16, 2012 at 4:57 PM, Shaik Waheed wrote:
>>>>
>>>>> Hi,
>>>>> Please chek it
>>>>>
>>>>> On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
>>>>> chatterjee.kolk...@gmail.com> wrote:
>>>>>
>>>>>>
>>>>>> Dear Experts,
>>>>>>
>>>>>> Please see the attachment.  I like store AREA1, AREA2 AND AREA3 in a
>>>>>> combo box or in Text Box.
>>>>>>
>>>>>> Base on the value store in the combo Box or list box I like the name
>>>>>> should display in the sheets
>>>>>>
>>>>>> suppose when i select in the combo box AREA1
>>>>>>
>>>>>> It will display the name store in the AREA1 and so on.
>>>>>>
>>>>>> Thanking you in Advance
>>>>>>
>>>>>>
>>>>>> Sanjib
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> -
>>>>>>
>>>>>> --
>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>>
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>
>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>> in signatures are prohibited.
>>>>>>
>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>
>>>>>>
>>>>>> --
>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>
>>>>>
>>>>>  --
>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>>
>>>>>

Re: $$Excel-Macros$$ combo box or list box help

[Sanjib Chatterjee]

Once again thank you Sir for quick reply.  But would you please show me the
process.


Regards,

Sanjib




On Thu, Feb 16, 2012 at 4:57 PM, Shaik Waheed  wrote:

> Hi,
> Please chek it
>
> On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Experts,
>>
>> Please see the attachment.  I like store AREA1, AREA2 AND AREA3 in a
>> combo box or in Text Box.
>>
>> Base on the value store in the combo Box or list box I like the name
>> should display in the sheets
>>
>> suppose when i select in the combo box AREA1
>>
>> It will display the name store in the AREA1 and so on.
>>
>> Thanking you in Advance
>>
>>
>> Sanjib
>>
>>
>>
>>
>>
>>
>> --
>> -
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ seeking help on Date format

[Sanjib Chatterjee]

please see the attachment, may be it can help you

sanjib

2012/2/13 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ <
vadnalaki...@gmail.com>

> Dear Excel Experts
>
> I have a problem in excel date format in column A
> whenever i enter the date dd/mm/ it changes to mm/dd/
>
> I tried to change column A with format cell option
> but does the same
>
> could you pls help me how to resolve the problem
>
> Regards
> V.Kiran Kumar
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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


date_format.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ unable to open file of 2007 in 2003

[Sanjib Chatterjee]

Dear Sir,

The installation completed sucessfully, there is no error during
installation, but while trying to open the file it is showing that the file
is not recognize by excel 2003.

regards,

Sanjib


On Wed, Feb 8, 2012 at 12:04 PM, Asa Rossoff  wrote:

> Hello Sanjib!
>
> Did installation of "the patch" fail, or did opening of an xlsx/xlsm file
> fail?  What error did you get?
>
> ** **
>
> When you say "the patch", do you mean the Compatibility Pack for Office?**
> **
>
> The latest Compatability Pack is at
> http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=3
>
> ** **
>
> Ensure you follow all the instructions.  They emphasize several times that
> you need to go to Microsoft Update first and install all high priority
> updates before installation.  That especially means updates for Office,
> but, I think, Windows too.  (http://update.microsoft.com).  If you
> installed the Compatability Pack but not the updates from Microsoft Update,
> you might be able to open your file by double=-clicking in Windows
> Explorer, but not by File>Open or drag and drop.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sanjib Chatterjee
> *Sent:* Tuesday, February 07, 2012 10:07 PM
> *To:* excel-macros
>
> *Subject:* $$Excel-Macros$$ unable to open file of 2007 in 2003
>
> ** **
>
>
> Dear Sir,
>
> Is there any way to open excel 2007 files in 2003.  I have try
> the patch that Microsoft provide to open 2007 file 2003, but failed
>
>
> Please help me..
>
> Thank you in Advance
>
> Regards,
>
> Sanjib
>
>
>
> --
> -
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ regarding number to text

[Sanjib Chatterjee]

thank you Members,

this is great.

regds,

Sanjib


On Tue, Jan 17, 2012 at 3:53 PM, NOORAIN ANSARI wrote:

> Yes Sanjib,
>
> Lakshman is right,
>
> If you want in Lakh format please check attached sheet.
>
> Hope it will help to u.
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Tue, Jan 17, 2012 at 2:02 PM, Lakshman Prasad wrote:
>
>> Because this vba for million and billion format.
>> For lakh you use other vba code
>>
>>
>>   *From:* Sanjib Chatterjee 
>> *To:* noorain.ansari ; excel-macros <
>> excel-macros@googlegroups.com>
>> *Sent:* Tuesday, 17 January 2012 1:19 PM
>> *Subject:* $$Excel-Macros$$ regarding number to text
>>
>> Dear NOORAIN ANSARI,
>>
>> This is great.  Would you please explain why it is showing just
>> thiousant, (e.i. If i put the figure as 123654.59,  I like to display as
>> "one lakh twenty three thousand six hundred fifty four and paise fifty nine
>> only)
>>
>> why lakh is not coming here?
>>
>> regards,
>>
>> Sanjib
>>
>>
>> --
>> -
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>>
>>  --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

$$Excel-Macros$$ regarding number to text

[Sanjib Chatterjee]

Dear NOORAIN ANSARI,

This is great.  Would you please explain why it is showing just thiousant,
(e.i. If i put the figure as 123654.59,  I like to display as "one lakh
twenty three thousand six hundred fifty four and paise fifty nine only)

why lakh is not coming here?

regards,

Sanjib


-- 
-

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Dairy 2012

[Sanjib Chatterjee]

thank you Muralidhar,

It is nice.

sanjib

On Mon, Jan 16, 2012 at 2:21 PM, muralidhar e wrote:

>
> Hi,
>
> Dear all wish u happy sankranti(Pongal) and a digital dairy gift for all.
>
> --
>  *Thanks & Regards,*
> **
> *Muralidhar E.*
>
>  --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Dec'2011

[Sanjib Chatterjee]

Congt, Ranjan Verma.  Keep the good work going.  Wish you happy and pros
new year

Sanjib


On Tue, Jan 3, 2012 at 11:50 PM, Ayush Jain  wrote:

> Hello Everyone,
>
> Wish you a very happy new year !!
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> December'2011
> He has posted 105 posts in December2011 and helped many people through his
> expertise. He has been consistent contributor to this excel forum and has
> acheived this recognition third time.
>
> He is back after long time but we all want him to continue his voluntary
> contribution in 2012 as well.
>
> Thanks to Don, Noorain, and other folks for helping excel enthusiasts
> voluntarily !! Keep it up !!
>
> Keep posting.
>
> Regards
> Ayush Jain
> Group Manager
> Microsoft MVP
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
-

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

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

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

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

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

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

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

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

Fwd: $$Excel-Macros$$ Fwd: date of birth

[Sanjib Chatterjee]

plz see the attachemnt

-- Forwarded message --
From: Ansar Ellahi 
Date: Tue, Dec 27, 2011 at 2:01 PM
Subject: $$Excel-Macros$$ Fwd: date of birth
To: excel-macros@googlegroups.com




-- Forwarded message --
From: Ansar Ellahi 
Date: Tue, Dec 27, 2011 at 1:29 PM
Subject: date of birth
To: rajanverma1...@gmail.com




came out actual date of birth
as below

december 27, 2011 minus march 16, 1986


with best regards
Ansar Ellahi
Management Office
*SML-Bhone (Jhang)
*Cell +92 303 790 2645
Ph   048-6889211-12
Fax  048-6889213




-- 



Ansar Ellahi
Management Office
*SML-Bhone (Jhang)
*Cell +92 303 790 2645
Ph   048-6889211-12
Fax  048-6889213

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


datedif.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Instead of using Isempty(), what other ways can be used for filling up the data

[Sanjib Chatterjee]

please check the below mentioned code

Sub Macro_del()
'
'
' Keyboard Shortcut: Ctrl+q
'
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete
ActiveWindow.SmallScroll Down:=-15
End Sub

On Tue, Dec 20, 2011 at 12:25 PM, Asa Rossoff  wrote:

> Hi Darwin,
> Instead of looping through all the cells, use the RANGE.Find method.
>
> Here's a modification of your routine (I commented out lines I replaced)
> that I think will have the same result, but uses RANGE.Find for speed:
> Sub reportdata()
>
> ** **
>
> 'Paste the data according to the date of report
>
> ** **
>
> Dim dt As Integer
>
> 'Dim i As Integer
>
> 'Dim datarow As Integer
>
> Dim rpdate As String
>
> Dim SearchRange As Range
>
> Dim Found As Range
>
> ** **
>
> ** **
>
> 'Get the date of report need to finish (without data)
>
> ** **
>
> Sheets("Summary").Activate
>
> 'datarow = Range("A" & Rows.Count).End(xlUp).Row
>
> Set SearchRange = Range(Cells(166, 1), Cells(Rows.Count,
> 1).End(xlUp)).Offset(ColumnOffset:=2)
>
> 'For i = 166 To datarow
>
> Set Found = SearchRange.Find("", SearchRange.Cells(SearchRange.Rows.Count,
> 1), xlValues, xlWhole)
>
> 'If IsEmpty(Cells(i, 3)) Then
>
> 'rpdate = Format(Left(Cells(i, 3).Offset(0, -2).Value, 10),
> "-mm-dd")
>
> 'Exit For
>
> 'End If
>
> 'Next
>
> If Not Found Is Nothing Then
>
> rpdate = Format(Left(Found.Offset(0, -2).Value, 10), "-mm-dd")
>
> Sheets("PivotTable").Cells(2, 10).Value = rpdate
>
> dt = Sheets("PivotTable").Cells(2, 12).Value
>
> ** **
>
> '20', 40, RF marshalling btw CY/CFS and MR/CMR AND disc/load btw
> BH/V/L and MR/CMR
>
> ** **
>
> Sheets("PivotTable").Range("L4").Resize(12, 74).Copy
>
> Worksheets("Summary").Cells(dt, 2).PasteSpecial (xlPasteValues)
>
> Else
>
> 'There were no blanks to find
>
> End If
>
> End Sub
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Darwin Chan
> *Sent:* Monday, December 19, 2011 9:52 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Instead of using Isempty(), what other ways
> can be used for filling up the data
>
> ** **
>
> Dear all,
>
> ** **
>
> I have created a report to copy the data from a sheet to another. However,
> i use isempty to check where to paste the data, but I found there is
> performance issue.
>
> ** **
>
> Is there any other way out other than using Isempty()??
>
> ** **
>
> File: http://www.sendspace.com/file/64pseo
>
> ** **
>
> Below can find the code and also the file.
>
> ** **
>
> Sub reportdata()
>
> ** **
>
> 'Paste the data according to the date of report
>
> ** **
>
> Dim dt As Integer
>
> Dim i As Integer
>
> Dim datarow As Integer
>
> Dim rpdate As String
>
> ** **
>
> 'Get the date of report need to finish (without data)
>
> ** **
>
> Sheets("Summary").Activate
>
> datarow = Range("A" & Rows.Count).End(xlUp).Row
>
> For i = 166 To datarow
>
> If* IsEmpty*(Cells(i, 3)) Then
>
> rpdate = Format(Left(Cells(i, 3).Offset(0, -2).Value, 10),
> "-mm-dd")
>
> Exit For
>
> End If
>
> 
>
> Next
>
> Sheets("PivotTable").Cells(2, 10).Value = rpdate
>
> dt = Sheets("PivotTable").Cells(2, 12).Value
>
> ** **
>
> '20', 40, RF marshalling btw CY/CFS and MR/CMR AND disc/load btw BH/V/L
> and MR/CMR
>
> ** **
>
> Sheets("PivotTable").Range("L4").Resize(12, 74).Copy
>
> Worksheets("Summary").Cells(dt, 2).PasteSpecial (xlPasteValues)
>
> End Sub
>
> ** **
>
> --
> Darwin Chan
>
> darwin.chankaw...@gmail.com
>
> kw42c...@yahoo.com.hk
>
> ** **
>
> --
> 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
> wi

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

[Sanjib Chatterjee]

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 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 wrote:
>
>>
>>
>> 2011/11/28 Kenil Gala 
>>
>>>   Rename the file.
>>> 2003 format :  .xls
>>> 2007 format :   .xlsx
>>>
>>> --- On *Mon, 11/28/11, Sanjib Chatterjee 
>>> *wrote:
>>>
>>>
>>> From: Sanjib Chatterjee 
>>> Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous
>>> version of excel
>>> To: "excel-macros" 
>>> 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
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use

$$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

[Sanjib Chatterjee]

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

Re: $$Excel-Macros$$ regarding date changing method

[Sanjib Chatterjee]

Thank you NOORAIN ANSARI

regards,

sanjib



On Tue, Nov 15, 2011 at 8:51 PM, NOORAIN ANSARI wrote:

> Dear Sajib,
>
> Please try it and see attached sheet..
>
> *Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> On Error Resume Next
> If ActiveCell.Column = 1 And IsNumeric(ActiveCell.Offset(-1, 0).Value) =
> True And Not IsEmpty(ActiveCell.Offset(-1, 0)) Then
> ActiveCell.Offset(-1, 0).Value = ActiveCell.Offset(-1, 0).Value & ".11"
> Exit Sub
> End If
> End Sub
> *
>
> 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 15, 2011 at 4:07 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Mambers,
>>
>> any body please help.
>>
>> regards,
>>
>> Sanjib
>>
>>
>>  On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee <
>> chatterjee.kolk...@gmail.com> wrote:
>>
>>>
>>> Dear Members,
>>>
>>> In excel 2003 I want to put the value in the cell (A1) as 15.11.  But
>>> while changing(i.e. press enter or tab)
>>>  the cell I want to  convert the figure as 15.11.2011 and so on.
>>>
>>> Thanking you in Advance
>>>
>>> Regards,
>>>
>>> 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
>>
>
>
>
> --
>
>  --
> 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$$ regarding date changing method

[Sanjib Chatterjee]

Dear Mambers,

any body please help.

regards,

Sanjib


On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

>
> Dear Members,
>
> In excel 2003 I want to put the value in the cell (A1) as 15.11.  But
> while changing(i.e. press enter or tab)
>  the cell I want to  convert the figure as 15.11.2011 and so on.
>
> Thanking you in Advance
>
> Regards,
>
> 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

Re: $$Excel-Macros$$ regarding date changing method

[Sanjib Chatterjee]

Dear Ranjan Verma,

But I want I only put 15.11 in a cell, it will convert into 15.11.2011



Thanking you in advance

Sanjib


On Tue, Nov 15, 2011 at 2:12 PM, rajan verma wrote:

> HI,
> You can change Cell Format as you required like dd.mm or mm.dd
>
> On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Members,
>>
>> In excel 2003 I want to put the value in the cell (A1) as 15.11.  But
>> while changing(i.e. press enter or tab)
>>  the cell I want to  convert the figure as 15.11.2011 and so on.
>>
>> Thanking you in Advance
>>
>> Regards,
>>
>> 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
>>
>
>
>
> --
> Regards
> Rajan verma
> +91 9158998701
>
> --
> 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$$ regarding date changing method

[Sanjib Chatterjee]

Dear Members,

In excel 2003 I want to put the value in the cell (A1) as 15.11.  But while
changing(i.e. press enter or tab)
 the cell I want to  convert the figure as 15.11.2011 and so on.

Thanking you in Advance

Regards,

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

Re: $$Excel-Macros$$ Seeking help small letters to capital letters

[Sanjib Chatterjee]

=UPPER(A1)


2011/11/10 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ <
vadnalaki...@gmail.com>

> Hi
>
> Anybody can help me out
> how to make small letter to capital letter in Ms excel
>
> V.Kiran
>
>
>  --
> 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$$ copy from sheets1 to sheets2 automatically

[Sanjib Chatterjee]

thank you sam and thank you Ashish

regards

sanjib

On Tue, Nov 1, 2011 at 2:12 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

>
> Dear Members,
>
> I have two sheets in my excel file.  In sheets1 i have data but sheets2 is
> blank.
> I want when i select a value of sheet1 it copy and paste in sheets2
> automatically
> this will repeat again and again for each value.
>
>
> Thanking you in Advance
>
> Regards,
>
> Sanjib
>
> --
> --
> FORUM RULES (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) 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 (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) 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 (925+ members already BANNED for violation)

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

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

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

4) 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$$ copy from sheets1 to sheets2 automatically

[Sanjib Chatterjee]

Dear Sam,
how to execute that.

Thanking you

Regards,

Sanjib


On Tue, Nov 1, 2011 at 2:20 PM, Sam Mathai Chacko wrote:

> Sub CopyFromSheetToAnotherSheet()
>
> Selection.Copy Sheets(2).Range(Selection.Cells(1).Address)
>
> End Sub
>
> Regards,
>
> Sam Mathai Chacko (GL)
>
>
> On Tue, Nov 1, 2011 at 10:42 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Members,
>>
>> I have two sheets in my excel file.  In sheets1 i have data but sheets2
>> is blank.
>> I want when i select a value of sheet1 it copy and paste in sheets2
>> automatically
>> this will repeat again and again for each value.
>>
>>
>> Thanking you in Advance
>>
>> Regards,
>>
>> Sanjib
>>
>> --
>> --
>> FORUM RULES (925+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) 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 (925+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) 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 (925+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) 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 (925+ members already BANNED for violation)

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

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

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

4) 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 (925+ members already BANNED for violation)

1) Use concise, accurate th

$$Excel-Macros$$ copy from sheets1 to sheets2 automatically

[Sanjib Chatterjee]

Dear Members,

I have two sheets in my excel file.  In sheets1 i have data but sheets2 is
blank.
I want when i select a value of sheet1 it copy and paste in sheets2
automatically
this will repeat again and again for each value.


Thanking you in Advance

Regards,

Sanjib

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

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

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

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

4) 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 (925+ members already BANNED for violation)

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

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

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

4) 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$$ unable to do any operation with this data

[Sanjib Chatterjee]

thank you very much it is working fine.

thank to all the member to support me.

regards,

sanjib


On Tue, Oct 25, 2011 at 7:32 PM, dguillett1  wrote:

>   I have this in my personal.xls file assigned to a custom button
> Select your range and fire it
>
> Sub fixmynums()
> Application.ScreenUpdating = False
> On Error Resume Next
> For Each C In Selection
>If Trim(Len(C)) > 0 And C.HasFormula = False Then
> C.NumberFormat = "General"
> C.Value = CDbl(C)
>End If
>   Next
>
> Application.ScreenUpdating = True
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sanjib Chatterjee 
> *Sent:* Tuesday, October 25, 2011 3:00 AM
> *To:* excel-macros 
> *Subject:* $$Excel-Macros$$ unable to do any operation with this data
>
> Dear Members,
>
> Please see the attachment.  I am unable to do any operation with this
> figure in the excel file.  (i.e. Addition, multiplication, division etc)
>
>
> please help
>
> regards,
>
> Sanjib
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ unable to do any operation with this data

[Sanjib Chatterjee]

Dear Swapnil Palande,

how to remove the space.  What function do i use?

PLease help

ragards,

sanjib


On Tue, Oct 25, 2011 at 1:36 PM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:

> Hi,
>
> There are white spaces before number, remove those spaces and then you can
> use functions.
>
> Regards,
>
> Swapnil.
>
> On Tue, Oct 25, 2011 at 1:30 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Members,
>>
>> Please see the attachment.  I am unable to do any operation with this
>> figure in the excel file.  (i.e. Addition, multiplication, division etc)
>>
>>
>> please help
>>
>> regards,
>>
>> Sanjib
>>
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

$$Excel-Macros$$ unable to do any operation with this data

[Sanjib Chatterjee]

Dear Members,

Please see the attachment.  I am unable to do any operation with this figure
in the excel file.  (i.e. Addition, multiplication, division etc)


please help

regards,

Sanjib

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

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


SAMPLE_FILE.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

[Sanjib Chatterjee]

B. sharma.

goto vba = module1=>paste the code

in excel write a date = inset the function from userdefined function



Sanjib

On Wed, Oct 12, 2011 at 4:43 PM, B Sharma  wrote:

> Dear Sanjib.
> there is no option there to attach the file
> please help
>
>
> On Oct 12, 12:16 pm, Sanjib Chatterjee 
> wrote:
> > dear
> > B Sharma
> > please send me the sheets
> >
> > sanjib
> >
> >
> >
> >
> >
> >
> >
> > On Wed, Oct 12, 2011 at 12:37 PM, B Sharma  wrote:
> > > Dear Excel Experts
> > > I want to select a date which is either equals to or lesser than the
> > > select date.
> >
> > > For Example
> >
> > > in Column 1 I have different dates
> >
> > > 01-Apr-2010
> > > 01-Jul-2010
> > > 15-Aug-2010
> > > 01-Oct-2010
> > > 15-Nov-2010
> > > 08-Aug-2010
> >
> > >  (sorted and un sorted both)
> >
> > > In Cell B2 I have entered a date, say.  15-Sep-2010
> > > In Cell C3 I want a formula which will return the date either equals
> > > to B2 or 1 time lesser than it.
> > > In this case the result will be 15-Aug-2010
> >
> > > Please help its very urgent
> >
> > > --
> >
> > >
> ---
> ---
> > > Some important links for excel users:
> > > 1. Follow us on TWITTER for tips tricks and links :
> > >http://twitter.com/exceldailytip
> > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
> >
> > > To post to this group, send email to excel-macros@googlegroups.com
> >
> > > <><><><><><><><><><><><><><><><><><><><><><>
> > > Like our page on facebook , Just follow below link
> > >http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ file browser

[Sanjib Chatterjee]

reference : Microsoft Office 10 object libarary need to download

Private Sub Command0_Click()

Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
Dim vrtSelectedItem As Variant
With fd
If .Show = -1 Then
For Each vrtSelectedItem In .SelectedItems
MsgBox "The path is: " & vrtSelectedItem
Next vrtSelectedItem
Else
End If
End With
Set fd = Nothing
End Sub


On Wed, Oct 12, 2011 at 3:56 PM, airen  wrote:

> Hi experts,
> How to open a file from user via "browse" in VBA
> Thanks
> Akhilesh
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Unable to change date fromate

[Sanjib Chatterjee]

Dear Suman,

Please use the below mentioned formula

Function put_date(input_your_date As String) As String

Dim splt
splt = Split(input_your_date, "/")
put_date = Format(DateSerial(splt(2), splt(1), splt(0)), "mm-dd-")

End Function

On Tue, Oct 11, 2011 at 6:38 PM, Suman  wrote:

> Hi,
> Good evening to all,
> Please help in changing date formate.
>
> --
>
>
>
>
>
>
>
>«•´`•.(*•.¸(`•.¸*¸.•´)¸.•*).•´`•»
> «´¨*•.¸¸.*.~*--Suman --*~..*.¸¸.•*¨`»
>«•´`•.(¸.•´(¸.• * •.¸)`•.¸).•´`•»
>
> Mob: +91 9810333884
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Selecting a date from a database, which equal to or lesser than the selected date

[Sanjib Chatterjee]

dear
B Sharma
please send me the sheets

sanjib

On Wed, Oct 12, 2011 at 12:37 PM, B Sharma  wrote:

> Dear Excel Experts
> I want to select a date which is either equals to or lesser than the
> select date.
>
> For Example
>
> in Column 1 I have different dates
>
> 01-Apr-2010
> 01-Jul-2010
> 15-Aug-2010
> 01-Oct-2010
> 15-Nov-2010
> 08-Aug-2010
>
>  (sorted and un sorted both)
>
> In Cell B2 I have entered a date, say.  15-Sep-2010
> In Cell C3 I want a formula which will return the date either equals
> to B2 or 1 time lesser than it.
> In this case the result will be 15-Aug-2010
>
>
> Please help its very urgent
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Extract 6 & 7 Digit Number

[Sanjib Chatterjee]

check the below mentioned linked

regards

sanjib
http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx

On Fri, Oct 7, 2011 at 11:37 AM, karan 1237  wrote:

> Dear All,
>
> Hope you all are doing well !
>
> I need your assistance to sort out my problem. I need to extract 6 & 7
> Digit number from the string.
>
> Example :
>
> I. C, Rajendra Palace, New Delhi 110053
> II. C, 301 Rajendra Palace, 110053 New Delhi
> III. C, Rajendra Palace, 110 053 New Delhi
>
> *Result : *
>
> I. 110053
> II. 110053
> III. 110 053
>
>
> Kindly help.
>
>
> Kaяan
>
>  
> 
> 
>  
> 
>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Want to separate Alphabet and Numeric Values

[Sanjib Chatterjee]

hi Suman,

check the below mentioned link

sanjib


http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx

On Wed, Oct 5, 2011 at 3:12 PM, Suman  wrote:

> Hi Group
> I have multiple data in column A (Alphabet with numeric values) n i want to
> separate them?
>
> Available Data
>
>*A*
>  suman1456  Sam221  Manni457
>
> I want like this:
>
>suman 1456 Sam 221  Manni 457
>
>
>
>
> --
>
>
>
>
>
>
>
>
>
> Suman Kumar
>
> Mob: +91 9810333884
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ regarding date format in excel vba

[Sanjib Chatterjee]

But It is not working sir,

I want to put the value as "25/09/2011" and like to display "25/sep/2011"

regards,

sanjib

On Mon, Oct 3, 2011 at 12:58 PM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:

> Hi Sanjib,
>
> The code I had given is vba code it will not change your computer date
> format.
>
> If you want to change date format for particular cell without using code
> then you can do that using following method
>
> 1. Right Click on Cell and select Format Cells option
> 2. Custom category in Number tab
> 3. and type "dd/mm/" in Type text box
>
> Regards,
>
> Swapnil
>
> On Mon, Oct 3, 2011 at 12:28 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> thank you for your quick responce Swapnil Palande .  But i want to say is
>> there any option in excel to put the date value like "dd/mm/",without
>> changing my computer date format.
>>
>> Thanking you
>>
>> Sanjib
>>
>>
>>
>> On Mon, Oct 3, 2011 at 11:43 AM, Swapnil Palande <
>> palande.swapni...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Use format function.
>>>
>>> ex. MsgBox Format(CDate("03/10/2011"), "dd-mmm-")
>>> Regards,
>>>
>>> Swapnil.
>>>   On Mon, Oct 3, 2011 at 11:33 AM, Sanjib Chatterjee <
>>> chatterjee.kolk...@gmail.com> wrote:
>>>
>>>> Dear Friends,
>>>>
>>>> would u please help me about the below mentioned problem in VBA EXCEL
>>>>
>>>> I like to put the date value in excel as "dd/mm/".  But like to get
>>>> the output
>>>> as "dd-mmm-"
>>>>
>>>> please help and oblige
>>>>
>>>> Thank you in advance
>>>>
>>>> Ragards,
>>>>
>>>> Sanjib
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ regarding date format in excel vba

[Sanjib Chatterjee]

thank you for your quick responce Swapnil Palande .  But i want to say is
there any option in excel to put the date value like "dd/mm/",without
changing my computer date format.

Thanking you

Sanjib



On Mon, Oct 3, 2011 at 11:43 AM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:

> Hi,
>
> Use format function.
>
> ex. MsgBox Format(CDate("03/10/2011"), "dd-mmm-")
> Regards,
>
> Swapnil.
> On Mon, Oct 3, 2011 at 11:33 AM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear Friends,
>>
>> would u please help me about the below mentioned problem in VBA EXCEL
>>
>> I like to put the date value in excel as "dd/mm/".  But like to get
>> the output
>> as "dd-mmm-"
>>
>> please help and oblige
>>
>> Thank you in advance
>>
>> Ragards,
>>
>> Sanjib
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

$$Excel-Macros$$ Fwd: date format help

[Sanjib Chatterjee]

Dear All

Please go through the mail and help me.

Ragards,

sanjib

-- Forwarded message --
From: Sanjib Chatterjee 
Date: Fri, Sep 30, 2011 at 12:15 PM
Subject: date format help
To: excel-macros 


Dear All members,

please help me regarding date format in Excel.

I want to put the value in excel as "dd/mm/", but like to get the value
as "dd-mmm-"

(i.e. 30/09/2011 should display 30-sep-2011, 01/12/2011 should display
01-dec-2011)

Thank you in advance

Regards,

Sanjib

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

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

Fwd: $$Excel-Macros$$ date format in Excel

[Sanjib Chatterjee]

Dear all members

please help to solve the problem

Sanjib
-- Forwarded message --
From: Sanjib Chatterjee 
Date: Fri, Sep 30, 2011 at 11:03 AM
Subject: $$Excel-Macros$$ date format in Excel
To: excel-macros 


Dear

I like to put the date format in Excel as "dd/mm/", and like to get the
output as "dd-mmm-"

thank you in Advance

sanjib


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

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

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

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

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

Re: $$Excel-Macros$$ reference auto copy in shee2

[Sanjib Chatterjee]

Dear Friends,

error message "will not take any arguments"

On Thu, Sep 8, 2011 at 1:31 PM, NOORAIN ANSARI wrote:

> Dear Sanjib,
>
> Another option, you record macro with short-cut key
> and paste red color code
>
> Sub Macro10()
> '
> ' Macro10 Macro
> '
> ' Keyboard Shortcut: Ctrl+r
> '
> *If TypeName(Selection) = "Range" Then
> Selection.Copy Sheets("Sheet2").Range("A" &
> Sheets("Sheet2").UsedRange.Rows.Count + 1)
> End If
> *
> End Sub
>
> On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>  Good Morning Everybody,
>>
>> I want to create a macro to copy the selected data from sheets1 to sheet2
>> automatically
>> after pressing a shortcut key.
>> Please help who to do that.
>> Waiting for your reply.
>>
>> Thank you in Advance
>>
>> Sanjib Chatterjee
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Fwd: $$Excel-Macros$$ ragarding FIFO METHOD in Ms Access

[Sanjib Chatterjee]

Dear Sir,

Please go through the mail and help me.

-- Forwarded message --
From: Sanjib Chatterjee 
Date: Fri, Aug 19, 2011 at 4:06 PM
Subject: $$Excel-Macros$$ ragarding FIFO METHOD in Ms Access
To: excel-macros 


Dear Sirs,

anybody please help regarding FIFO method in Ms Access 2003.  Please see the
attachment.  I want the fifo method will continue automatically in Ms
Access.  I have mentioned only one scripts but there could be more than 100
scripts

Thanking you in Advance

Sanjib

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

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

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

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

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


FIFO_METHODS.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ ragarding FIFO METHOD in Ms Access

[Sanjib Chatterjee]

Dear Sirs,

anybody please help regarding FIFO method in Ms Access 2003.  Please see the
attachment.  I want the fifo method will continue automatically in Ms
Access.  I have mentioned only one scripts but there could be more than 100
scripts

Thanking you in Advance

Sanjib

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

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


FIFO_METHODS.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Export of Personal Macro Book

[Sanjib Chatterjee]

you can find it in personal.xls file in you system.  Which is stays in
\Microsoft Office\xlstart folder.  copy it and paste in you new
location

On 8/16/11, Amit Desai (MERU)  wrote:
> Dear Masters,
>
> I am currently using a temporary laptop & in few days will receive another
> one. I have created some Macros & saved them in personal macro workbook.
>
> My queries are;
>
> 1)  Where to find them on my system,
>
> 2)  How to transfer them to new system.
>
> Best Regards,
> Amit Desai
>
> 
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Re: Can you please help regd. lists

[Sanjib Chatterjee]

This is excellent work.  Would you please explain how you have done it.
Your Formula Bar is showing nothing.

Sanjib



On Thu, Aug 11, 2011 at 12:58 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:

> Hello Naresh,
>
> See the attached. You can Add/Delete New/Old entries.
>
> HTH
> Haseeb
>
> For free help, visit,
> http://www.excelfox.com/forum/forum.php
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Convert Txt file into Excel into proper Columns

[Sanjib Chatterjee]

Open excel
data=>import External Data = >select datasource=>select the appropriate
option=>ok


On Tue, Jul 12, 2011 at 8:22 AM, Susan 1  wrote:

> Hi,
> Need your help.  How can I do this project faster than manually CTRL+ X ,
> then CTRL+ V , to delete and paste contact information into appropriate
> column headings?
>
> maybe I did the the Text Import Wizard incorrectly...
>
> Any help / ideas would be greatly appreciated!
>
> Thanks,
> Sunnie
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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

Re: $$Excel-Macros$$ Need formula for Current Date Access

[Sanjib Chatterjee]

Dear Friend,

Would you please send a formula of MS Access regarding FIFO
Thanking you

Sanjib


On Sat, Jul 9, 2011 at 12:46 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:

> Dear Friend,
> Can you please send a formula how to use a FIFO method in MS ACCESS?
>
> Waiting for your reply
>
> Thanking you
>
> Sanjib
>
>
>
> On Thu, Jul 7, 2011 at 11:50 AM, ankur  wrote:
>
>> * my pleasure
>> *
>> Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>>
>> On Wed, Jul 6, 2011 at 7:04 PM, Idhrees Mohamed wrote:
>>
>>> Dear Ankur,
>>>
>>> Its working fine. Thank you very much.
>>>
>>> Regards,
>>> Idhrees.
>>>
>>> On Tue, Jul 5, 2011 at 3:46 PM, ankur  wrote:
>>>
>>>> *You can create a form, by using  the IIF function in   Control Source
>>>> property...Of the field which required
>>>>
>>>> =IIf([Valid date]=Date(),"valid","expired")
>>>>
>>>> one sample file is attached...
>>>>
>>>>
>>>> *Have A Nice Time & Enjoy Life
>>>>
>>>> Regards:
>>>> CMA Ankur Pandey
>>>> (Someone Different)
>>>>
>>>> I'm not the best but i'm not like the rest~~
>>>>
>>>>
>>>>
>>>> On Tue, Jul 5, 2011 at 12:35 PM, Idhrees Mohamed 
>>>> wrote:
>>>>
>>>>>  Dear Friends,
>>>>>
>>>>> I need a help to access query for current date.
>>>>>
>>>>> I have an column with name valid date. I need a formula for validity
>>>>> date less than current date, its shown "valid otherwise "expired" like 
>>>>> that.
>>>>> Please help me the ms access fuction for this.
>>>>>
>>>>> --
>>>>> Thanks & Regards,
>>>>>
>>>>> Mohamed Idhrees. S.
>>>>>
>>>>> --
>>>>>
>>>>> --
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Join our LinkedIN group @
>>>>> http://www.linkedin.com/groups?gid=1871310
>>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>>
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> Like our page on facebook , Just follow below link
>>>>> http://www.facebook.com/discussexcel
>>>>>
>>>>
>>>> --
>>>>
>>>> --
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>>
>>> --
>>> Thanks & Regards,
>>>
>>> Mohamed Idhrees. S.
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ Need formula for Current Date Access

[Sanjib Chatterjee]

Dear Friend,
Can you please send a formula how to use a FIFO method in MS ACCESS?

Waiting for your reply

Thanking you

Sanjib


On Thu, Jul 7, 2011 at 11:50 AM, ankur  wrote:

> * my pleasure
> *
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
>
> On Wed, Jul 6, 2011 at 7:04 PM, Idhrees Mohamed wrote:
>
>> Dear Ankur,
>>
>> Its working fine. Thank you very much.
>>
>> Regards,
>> Idhrees.
>>
>> On Tue, Jul 5, 2011 at 3:46 PM, ankur  wrote:
>>
>>> *You can create a form, by using  the IIF function in   Control Source
>>> property...Of the field which required
>>>
>>> =IIf([Valid date]=Date(),"valid","expired")
>>>
>>> one sample file is attached...
>>>
>>>
>>> *Have A Nice Time & Enjoy Life
>>>
>>> Regards:
>>> CMA Ankur Pandey
>>> (Someone Different)
>>>
>>> I'm not the best but i'm not like the rest~~
>>>
>>>
>>>
>>> On Tue, Jul 5, 2011 at 12:35 PM, Idhrees Mohamed 
>>> wrote:
>>>
  Dear Friends,

 I need a help to access query for current date.

 I have an column with name valid date. I need a formula for validity
 date less than current date, its shown "valid otherwise "expired" like 
 that.
 Please help me the ms access fuction for this.

 --
 Thanks & Regards,

 Mohamed Idhrees. S.

 --

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

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

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

>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Thanks & Regards,
>>
>> Mohamed Idhrees. S.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

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

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