Re: $$Excel-Macros$$ Date Format Query

2014-06-17 Thread Pravin Gunjal
Yes rightly said. The file which has been downloaded from software isn't
having proper systems date format.  So I would like to make it in
DD.MM. (2.2.4 digits)

Kindly do the needful.


On Mon, Jun 16, 2014 at 5:19 PM, Paul Schreiner schreiner_p...@att.net
wrote:

 Guys:

 I started with the same response, until I noticed that
 I believe what he's saying is that the value in the cell is NOT an Excel
 date:

 He said:  Now it is not in system's date format

 so, he cannot change the display format to display it in another date
 format.

 the solution using the parsing the string and re-assembling it as a valid
 date is what is necessary.

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

*From:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS 
 excel-macros@googlegroups.com
 *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com
 *Sent:* Sunday, June 15, 2014 1:24 PM
 *Subject:* Re: $$Excel-Macros$$ Date Format Query

 Hi Pravin ...

 You can go to Format cell and custom the format of the date which ever
 result you need. furthermore you can see in the attachement.


 [image: cid:image001.gif@01C80A4D.0DE9E110]


 *Delin.F*




   On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote:


 Hi

 You can change display format by going to cell property  select custom
 and type dd.mm.

 If by doing so if date format does not change then select single column
 then press Data tab in Menu then press Next 2 times then select Date (DMY)
 and press finish button.

 Cheers!!


 On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Hi,

 I wanted to convert the dates in this format *DD.MM.*

 Now it is not in system's date format ( MM/DD/ ) and it is displayed
 as DD/MM/ or as D/M/.

 Kindly help.

 Regards
 Pravin Gunjal.
  --
 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 

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi,

Thanks for the providing me the solution. But I received sheet 1 file
on daily basic in new sheet in that case this file is not working. it
would be very helpful if you provide me solution on this

Regards

On 6/17/14, Vaibhav Joshi v...@vabs.in wrote:
 Hi

 Use this file.

 Cheers!!


 On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote:


 HI

 Since date format is not the same excel can search directly what you
 want,
 however macro in attached sheet can help you to fetch data one by one.
 You
 need to keep open sheet 1  sheet 2 (Only 2 sheets). Goto sheet 2
 workbook,
 hit that blue button  select the date which is in sheet one in column A
 e.g. cell A8  value will be fetched.

 Hope it helps.

 Cheers!!


 On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com wrote:

 Hi vaibhav,

 Fist upon thanks for the reply. I will prefer both the way
 It would be very helpful If u help me on the same.

 Regards

 On 6/16/14, Vaibhav Joshi v...@vabs.in wrote:
  Hey
 
  How do you want to fetch? Formula or Macro?
 
 
 
 
  On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com
 wrote:
 
  Hi Team,
 
  I want to fetch data from one sheet to another sheet by referring the
  data, Attached sheet will explain you what i want exactly.
 
  Request all of you to kindly help me on this
 
  Regards
 
  --
  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, 

$$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Hi Guys,

I want to use formula on pivot table data.

Kindly help me.


-- 
Thanks £ Regards
Rakesh Kumar
+91-9650303464

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


Differance.xlsx
Description: MS-Excel 2007 spreadsheet


Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Dhaval Shah
fyi

Warm Regards,

Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*




On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com
wrote:

 Hi Guys,

 I want to use formula on pivot table data.

 Kindly help me.


 --
 Thanks £ Regards
 Rakesh Kumar
 +91-9650303464



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


Differance.xlsx
Description: MS-Excel 2007 spreadsheet


Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Vaibhav Joshi
I didnt get you what you are trying to say!




On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta jocky6...@gmail.com wrote:

 Hi,

 Thanks for the providing me the solution. But I received sheet 1 file
 on daily basic in new sheet in that case this file is not working. it
 would be very helpful if you provide me solution on this

 Regards

 On 6/17/14, Vaibhav Joshi v...@vabs.in wrote:
  Hi
 
  Use this file.
 
  Cheers!!
 
 
  On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote:
 
 
  HI
 
  Since date format is not the same excel can search directly what you
  want,
  however macro in attached sheet can help you to fetch data one by one.
  You
  need to keep open sheet 1  sheet 2 (Only 2 sheets). Goto sheet 2
  workbook,
  hit that blue button  select the date which is in sheet one in column A
  e.g. cell A8  value will be fetched.
 
  Hope it helps.
 
  Cheers!!
 
 
  On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com
 wrote:
 
  Hi vaibhav,
 
  Fist upon thanks for the reply. I will prefer both the way
  It would be very helpful If u help me on the same.
 
  Regards
 
  On 6/16/14, Vaibhav Joshi v...@vabs.in wrote:
   Hey
  
   How do you want to fetch? Formula or Macro?
  
  
  
  
   On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com
  wrote:
  
   Hi Team,
  
   I want to fetch data from one sheet to another sheet by referring
 the
   data, Attached sheet will explain you what i want exactly.
  
   Request all of you to kindly help me on this
  
   Regards
  
   --
   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 

Re: $$Excel-Macros$$ Date Format Query

2014-06-17 Thread Vaibhav Joshi
hi..

if data imported is in date then by using data text t o column you can do
easily..

Refer my earlier email..


On Tue, Jun 17, 2014 at 12:19 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Yes rightly said. The file which has been downloaded from software isn't
 having proper systems date format.  So I would like to make it in
 DD.MM. (2.2.4 digits)

 Kindly do the needful.


 On Mon, Jun 16, 2014 at 5:19 PM, Paul Schreiner schreiner_p...@att.net
 wrote:

 Guys:

 I started with the same response, until I noticed that
 I believe what he's saying is that the value in the cell is NOT an Excel
 date:

 He said:  Now it is not in system's date format

 so, he cannot change the display format to display it in another date
 format.

 the solution using the parsing the string and re-assembling it as a valid
 date is what is necessary.

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

*From:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS 
 excel-macros@googlegroups.com
 *To:* excel-macros@googlegroups.com excel-macros@googlegroups.com
 *Sent:* Sunday, June 15, 2014 1:24 PM
 *Subject:* Re: $$Excel-Macros$$ Date Format Query

 Hi Pravin ...

 You can go to Format cell and custom the format of the date which ever
 result you need. furthermore you can see in the attachement.


 [image: cid:image001.gif@01C80A4D.0DE9E110]


 *Delin.F*




   On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote:


 Hi

 You can change display format by going to cell property  select custom
 and type dd.mm.

 If by doing so if date format does not change then select single column
 then press Data tab in Menu then press Next 2 times then select Date (DMY)
 and press finish button.

 Cheers!!


 On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Hi,

 I wanted to convert the dates in this format *DD.MM.*

 Now it is not in system's date format ( MM/DD/ ) and it is displayed
 as DD/MM/ or as D/M/.

 Kindly help.

 Regards
 Pravin Gunjal.
  --
 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 

Re: $$Excel-Macros$$ Help Needed

2014-06-17 Thread Rakesh kumar
Thanks Brother, But how you Did this.
Please explain the process.


On Tue, Jun 17, 2014 at 1:02 PM, Dhaval Shah todhavals...@gmail.com wrote:

 fyi

 Warm Regards,

 Dhaval Shah
 M) 98240 35253
 *E-mail : todhavals...@gmail.com todhavals...@gmail.com*




 On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com
 wrote:

 Hi Guys,

 I want to use formula on pivot table data.

 Kindly help me.


 --
 Thanks £ Regards
 Rakesh Kumar
 +91-9650303464



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




-- 
Thanks £ Regards
Rakesh Kumar
+91-9650303464

-- 
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$$ Needs help in Data validation

2014-06-17 Thread Rakesh kumar
PFA


-- 
Thanks £ Regards
Rakesh Kumar
+91-9650303464

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


rrr.xlsx
Description: MS-Excel 2007 spreadsheet


Re: $$Excel-Macros$$ Date Format Query

2014-06-17 Thread Pravin Gunjal
This is working perfectly as per my requirement.
Thanks.

Regards
Pravin Gunjal.


On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA
MACROS excel-macros@googlegroups.com wrote:

 Hi Pravin ...

 You can go to Format cell and custom the format of the date which ever
 result you need. furthermore you can see in the attachement.


 [image: cid:image001.gif@01C80A4D.0DE9E110]


 *Delin.F*




   On Sunday, 15 June 2014 4:54 PM, Vaibhav Joshi v...@vabs.in wrote:


 Hi

 You can change display format by going to cell property  select custom
 and type dd.mm.

 If by doing so if date format does not change then select single column
 then press Data tab in Menu then press Next 2 times then select Date (DMY)
 and press finish button.

 Cheers!!


 On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Hi,

 I wanted to convert the dates in this format *DD.MM.*

 Now it is not in system's date format ( MM/DD/ ) and it is displayed
 as DD/MM/ or as D/M/.

 Kindly help.

 Regards
 Pravin Gunjal.
  --
 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 a topic in the
 Google Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this topic, visit
 https://groups.google.com/d/topic/excel-macros/KuYWzt64SjI/unsubscribe.
 To unsubscribe from this group and all its topics, 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 

Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Jocky Beta
Hi every time I received new sheet from my colleague in. That
situation your sheet not working

Regards

On 6/17/14, Vaibhav Joshi v...@vabs.in wrote:
 I didnt get you what you are trying to say!




 On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta jocky6...@gmail.com wrote:

 Hi,

 Thanks for the providing me the solution. But I received sheet 1 file
 on daily basic in new sheet in that case this file is not working. it
 would be very helpful if you provide me solution on this

 Regards

 On 6/17/14, Vaibhav Joshi v...@vabs.in wrote:
  Hi
 
  Use this file.
 
  Cheers!!
 
 
  On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote:
 
 
  HI
 
  Since date format is not the same excel can search directly what you
  want,
  however macro in attached sheet can help you to fetch data one by one.
  You
  need to keep open sheet 1  sheet 2 (Only 2 sheets). Goto sheet 2
  workbook,
  hit that blue button  select the date which is in sheet one in column
  A
  e.g. cell A8  value will be fetched.
 
  Hope it helps.
 
  Cheers!!
 
 
  On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com
 wrote:
 
  Hi vaibhav,
 
  Fist upon thanks for the reply. I will prefer both the way
  It would be very helpful If u help me on the same.
 
  Regards
 
  On 6/16/14, Vaibhav Joshi v...@vabs.in wrote:
   Hey
  
   How do you want to fetch? Formula or Macro?
  
  
  
  
   On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com
  wrote:
  
   Hi Team,
  
   I want to fetch data from one sheet to another sheet by referring
 the
   data, Attached sheet will explain you what i want exactly.
  
   Request all of you to kindly help me on this
  
   Regards
  
   --
   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 

$$Excel-Macros$$ Auto update Data, Row Columns

2014-06-17 Thread Rajeev
Dear Experts,

 

Please find attached file and please do the needful as per mentioned in the
file.

 

Thanks / Regards,

 

 

Rajeev

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


autoupdate.xlsx
Description: MS-Excel 2007 spreadsheet


Re: $$Excel-Macros$$ Data Fetching

2014-06-17 Thread Vaibhav Joshi
Hi

Try second file which i sent today, pl note..either data structure or
heading should be unique.. I have prepared second sheet assuming data
structure will be same..For working 1st file you need to have same headings
in both input  output file. Do let me know where exactly you are finding
problem.

Cheers!!


On Tue, Jun 17, 2014 at 4:18 PM, Jocky Beta jocky6...@gmail.com wrote:

 Hi every time I received new sheet from my colleague in. That
 situation your sheet not working

 Regards

 On 6/17/14, Vaibhav Joshi v...@vabs.in wrote:
  I didnt get you what you are trying to say!
 
 
 
 
  On Tue, Jun 17, 2014 at 12:36 PM, Jocky Beta jocky6...@gmail.com
 wrote:
 
  Hi,
 
  Thanks for the providing me the solution. But I received sheet 1 file
  on daily basic in new sheet in that case this file is not working. it
  would be very helpful if you provide me solution on this
 
  Regards
 
  On 6/17/14, Vaibhav Joshi v...@vabs.in wrote:
   Hi
  
   Use this file.
  
   Cheers!!
  
  
   On Tue, Jun 17, 2014 at 1:22 AM, Vaibhav Joshi v...@vabs.in wrote:
  
  
   HI
  
   Since date format is not the same excel can search directly what you
   want,
   however macro in attached sheet can help you to fetch data one by
 one.
   You
   need to keep open sheet 1  sheet 2 (Only 2 sheets). Goto sheet 2
   workbook,
   hit that blue button  select the date which is in sheet one in
 column
   A
   e.g. cell A8  value will be fetched.
  
   Hope it helps.
  
   Cheers!!
  
  
   On Mon, Jun 16, 2014 at 7:16 PM, Jocky Beta jocky6...@gmail.com
  wrote:
  
   Hi vaibhav,
  
   Fist upon thanks for the reply. I will prefer both the way
   It would be very helpful If u help me on the same.
  
   Regards
  
   On 6/16/14, Vaibhav Joshi v...@vabs.in wrote:
Hey
   
How do you want to fetch? Formula or Macro?
   
   
   
   
On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com
 
   wrote:
   
Hi Team,
   
I want to fetch data from one sheet to another sheet by referring
  the
data, Attached sheet will explain you what i want exactly.
   
Request all of you to kindly help me on this
   
Regards
   
--
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
   

Re: $$Excel-Macros$$ Repeat Header Rows in prints for specific sheets

2014-06-17 Thread Rohan Young
thanks a lot bro, this is awesome and that's i need

very-2 thanks bro


On Thu, Jun 12, 2014 at 10:22 PM, Vaibhav Joshi v...@vabs.in wrote:

 PFA

 You need to customize send key letters to get desired output.

 Cheers!!


 On Thu, Jun 12, 2014 at 5:34 PM, Rohan Young rohan.j...@gmail.com wrote:

 its already set on both side printing by default but when i am taking
 print through that its coming on one side printing


 On Thu, Jun 12, 2014 at 5:24 PM, Vaibhav Joshi v...@vabs.in wrote:

 You need to set duplex printing option as default before printing..


 On Thu, Jun 12, 2014 at 5:10 PM, Rohan Young rohan.j...@gmail.com
 wrote:

 one more thing if you can add on this that is both side printing coz
 our organization preferred that or excel could take own-self the setting of
 both side printing as default

 thanks


 On Thu, Jun 12, 2014 at 5:06 PM, Rohan Young rohan.j...@gmail.com
 wrote:

 please also solve my query of folders of mails logbook

 regds


 On Thu, Jun 12, 2014 at 5:05 PM, Rohan Young rohan.j...@gmail.com
 wrote:

 thanks a lot bro




 On Thu, Jun 12, 2014 at 4:33 PM, Vaibhav Joshi v...@vabs.in wrote:

 PFA

 Cheers!!
 .*show(Time)*


 On Thu, Jun 12, 2014 at 4:02 PM, Rohan Young rohan.j...@gmail.com
 wrote:

 no bro,

 i want Repeat Top row should come in print on every individual
 sheet's first 6 pages. from page 7 i dont need Repeat Top Row in 
 prints it
 should come in print without Repeat Top Rows in remaining pages. Same 
 is
 for rest of the sheets.

 Thanks


 On Thu, Jun 12, 2014 at 3:27 PM, Vaibhav Joshi v...@vabs.in wrote:

 If there is sheets 1 to 10..You want to repeat 1st row of sheet 1
 on all pages of sheet 1,2,3 etc..

 it it correct??



 On Thu, Jun 12, 2014 at 2:33 PM, Rohan Young rohan.j...@gmail.com
  wrote:

 hi,

 i am talking about the Repeat Top Rows not header or footer

 thanks


 On Wed, Jun 11, 2014 at 10:42 PM, Vaibhav Joshi v...@vabs.in
 wrote:

 Check this link.:


 http://www.mrexcel.com/forum/excel-questions/456534-excel-visual-basic-applications-change-header-each-page.html

 Cheers
 On Jun 11, 2014 9:39 PM, Rohan Young rohan.j...@gmail.com
 wrote:


 On Wed, Jun 11, 2014 at 3:11 PM, Rohan Young 
 rohan.j...@gmail.com wrote:

 Dear Group,

 I need to repeat header rows in prints in specific sheets
 after that no need to print header rows on remaining sheets.

 Thanks in advance
 ROHAN

 --


 Dear Group,

 I need to repeat header rows in prints in specific sheets after
 that no need to print header rows on remaining sheets.

 Thanks in advance
 ROHAN

 --

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

$$Excel-Macros$$ Urgent required Python Developer - San Jose, CA

2014-06-17 Thread Gary .
Please respond to *gurjant.si...@damcosoft.com
gurjant.si...@damcosoft.com*



*Position:  Python DeveloperLocation:  San Jose, CADuration:  6 months,
possibility of extension*

Required Skills:
•4+ years Python experience.
•2+ years Django
•2+ years JS with experience on MV* frameworks such as backbone.js or
angular.js
•Release to Production Experience.
•2+Years RDBMS experience.
•Experience in developing REST APIs.



Thanks and Regards,



Gurjant Singh - (Gary)

Technical Recruiter

+1 212 389 9503 ext 208

E: gurjant.si...@damcosoft.com



*NY Office:  *112 W 34th St, 18th Floor, New York, NY 10120

*NJ Office:  *894 Green Street, Suite B, Iselin, NJ 08830



Corporate: www.damcosoft.com

*[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]*



*[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]*



*P** Please consider the planet before printing | Switch off as you go
|**q**Recycle
always |* *Your child deserves a better world*

*CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the original message*

-- 
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$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread pankaj khairanar


Hi Expert,

I want excel formula for below scenario.

Date-9=result

If result=saturday or sunday then omit saturday or sunday and consider 
monday.


Extample1


02/June/14 - 9=Saturday, May 24, 2014 
Want to omit this saturday and sunday want result as Monday, May 26,2014
 
Extample2
 
03/June/14 - 9=Sunday, May 25, 2014 
Want to omit this sunday and want result as Monday, May 26,2014


Regards,
Pankaj

-- 
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$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread Paul Schreiner
Here we can make use of a couple of different concepts:
#1) Excel stores dates as numbers (the number of days since 1/1/1900).
  So, if your date (June 3, 2014) is in cell A1, the date 9 days previous to 
that is A1-9
 
#2) The Excel function Weekday() returns the day number of the weekday.
  the function has optional parameters that let you establish the first 
day of the week.
  So, =WEEKDAY(A1-9) will return Sunday=1 through Saturday = 7
but if you use WEEKDAY(A1-9,2) then it will make Monday=1 and Saturday and 
Sunday are 6 and 7(Friday =5)
 
  So, if we test to see if the result of A1-9 is = 5, we can use the date.
  If it is 6, then it's a Saturday and you need to add 2 days. 
Otherwise, add 1 day.
 
You end up with a formula like:
 
=IF(WEEKDAY(A1-9,2)=5,A1-9,
  IF(WEEKDAY(A1-9,2)=6,A1-9+2,A1-9+1)) 
 
Of course you could simplify it with:
=IF(WEEKDAY(A1-9,2)=5,A1-9,
  IF(WEEKDAY(A1-9,2)=6,A1-7,A1-8))

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
-

 From: pankaj khairanar pankajkh...@gmail.com
To: excel-macros@googlegroups.com 
Sent: Tuesday, June 17, 2014 10:28 AM
Subject: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!
  


Hi Expert,
I want excel formula for below scenario.
Date-9=result
If result=saturday or sunday then omit saturday or sunday and consider monday.

Extample1

02/June/14 - 9=Saturday, May 24, 2014 
Want to omit this saturday and sunday want result as Monday, May 26,2014

Extample2

03/June/14 - 9=Sunday, May 25, 2014 
Want to omit this sunday and want result as Monday, May 26,2014

Regards,
Pankaj

-- 
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$$ Urgent required .Net developer - Dublin, OH

2014-06-17 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com
gurjant.si...@damcosoft.com*



*Position: .Net developerLocation: Dublin, OHDuration: 3 to 6 months
(Extendable)*

Visa: US/GC/EAD only

Revised skills:

What we would need:

1.   Object Oriented Programming
2.   .NET C#
a.   Generics, Collections, LINQ
b.  File IO – Text, XML etc.
c.   Regular Expressions
3.   VSTO using C#
4.   Design Patterns
5.   WCF Services, Web Services

Good to have
a.   SQL Database
b.  ASP.NET MVC
c.   JavaScript / JQuery



Thanks and Regards,



Gurjant Singh - (Gary)

Technical Recruiter

+1 212 389 9503 ext 208

E: gurjant.si...@damcosoft.com



*NY Office:  *112 W 34th St, 18th Floor, New York, NY 10120

*NJ Office:  *894 Green Street, Suite B, Iselin, NJ 08830



Corporate: www.damcosoft.com

*[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]*



*[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]*



*P** Please consider the planet before printing | Switch off as you go
|**q**Recycle
always |* *Your child deserves a better world*

*CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the original message*

-- 
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$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread pankaj khairanar
Thanks Paul! Got the solution and as well knowledge!
 
Regards,
Pankaj
On Tuesday, June 17, 2014 8:43:44 PM UTC+5:30, Paul Schreiner wrote:

 Here we can make use of a couple of different concepts:
 #1) Excel stores dates as numbers (the number of days since 1/1/1900).
   So, if your date (June 3, 2014) is in cell A1, the date 9 days previous 
 to that is A1-9
  
 #2) The Excel function Weekday() returns the day number of the weekday.
   the function has optional parameters that let you establish the 
 first day of the week.
   So, =WEEKDAY(A1-9) will return Sunday=1 through Saturday = 7
 but if you use WEEKDAY(A1-9,2) then it will make Monday=1 and Saturday and 
 Sunday are 6 and 7(Friday =5)
  
   So, if we test to see if the result of A1-9 is = 5, we can use the date.
   If it is 6, then it's a Saturday and you need to add 2 days. 
 Otherwise, add 1 day.
  
 You end up with a formula like:
  
 =IF(WEEKDAY(A1-9,2)=5,A1-9,
   IF(WEEKDAY(A1-9,2)=6,A1-9+2,A1-9+1)) 
  
 Of course you could simplify it with:
 =IF(WEEKDAY(A1-9,2)=5,A1-9,
   IF(WEEKDAY(A1-9,2)=6,A1-7,A1-8))
  
 *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*
 -

*From:* pankaj khairanar panka...@gmail.com javascript:
 *To:* excel-...@googlegroups.com javascript: 
 *Sent:* Tuesday, June 17, 2014 10:28 AM
 *Subject:* $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!
  
 Hi Expert,
 I want excel formula for below scenario.
 Date-9=result
 If result=saturday or sunday then omit saturday or sunday and consider 
 monday.

 Extample1

 02/June/14 - 9=Saturday, May 24, 2014 
 Want to omit this saturday and sunday want result as Monday, May 26,2014
  
 Extample2
  
 03/June/14 - 9=Sunday, May 25, 2014 
 Want to omit this sunday and want result as Monday, May 26,2014

 Regards,
 Pankaj
 -- 
 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...@googlegroups.com javascript:.
 To post to this group, send email to excel-...@googlegroups.com 
 javascript:.
 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.


Re: $$Excel-Macros$$ Want Excel formula to Omit saturday sunday!

2014-06-17 Thread hari kumar
Networkdays( stdate, end date,[holidays]

Thanks  Regards
Hari Kumar

Our strength grows from our weakness.
On Jun 17, 2014 10:28 AM, pankaj khairanar pankajkh...@gmail.com wrote:

 Hi Expert,

 I want excel formula for below scenario.

 Date-9=result

 If result=saturday or sunday then omit saturday or sunday and consider
 monday.


 Extample1


 02/June/14 - 9=Saturday, May 24, 2014
 Want to omit this saturday and sunday want result as Monday, May 26,2014

 Extample2

 03/June/14 - 9=Sunday, May 25, 2014
 Want to omit this sunday and want result as Monday, May 26,2014


 Regards,
 Pankaj

 --
 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$$ Urgent required Java developer (Scala) - Indianapolis,IN

2014-06-17 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com
gurjant.si...@damcosoft.com*



*Position: Java developer (Scala)Location: Indianapolis,INDuration: 6-12
Months*

*Position: 10*

This is an immediate requirement and interview can happen immediately with
next day join date.

JD:

Strong functional programming knowledge, Scala
Strong SQL knowledge, MySQL experience
Strong experience with JMS, RESTful webservices
Proficiency building unit tests
Proficiency building and deploying cloud-based applications, preferably
using AWS
optional - experieince with   ElasticSearch, RDS,  SQS
Experience with continuous integration tools like Jenkins or CircleCI
Experience with PLAY framework



Thanks and Regards,



Gurjant Singh - (Gary)

Technical Recruiter

+1 212 389 9503 ext 208

E: gurjant.si...@damcosoft.com



*NY Office:  *112 W 34th St, 18th Floor, New York, NY 10120

*NJ Office:  *894 Green Street, Suite B, Iselin, NJ 08830



Corporate: www.damcosoft.com

*[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]*



*[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]*



*P** Please consider the planet before printing | Switch off as you go
|**q**Recycle
always |* *Your child deserves a better world*

*CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the original message*

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