from:"P.VIJAYKUMAR"

Respected Vikas,

There is no problem with the tracker.Just enable the macros of excel.For
inputting any new data do not type manually but use the button given and
type the data into the dialogue box you get after pressing the button.


**
 Regards,
 VijayKumar

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

Respected Neeraj,

Excel stores all dates as integers and all times as decimal fractions. With
this system, Excel can add, subtract, or compare dates and times just like
any other numbers, and all dates are manipulated by using this system.Times
are stored as decimal numbers between .0 and .9, where .0 is 00:00:00
and .9 is 23:59:59. The date integers and time decimal fractions can be
combined to create numbers that have a decimal and an integer portion. For
example, the number 32331.06 represents the date and time 7/7/1988 1:26:24
a.m.

You can refer the following link for information about date and time
calculations.
http://support.microsoft.com/kb/214094

Regards,
VijayKumar


On Wed, Jul 17, 2013 at 6:00 PM, Pravin Gunjal isk1...@gmail.com wrote:

 It's awesome.

 -- Forwarded message --
 From: Anonymous singhoram...@gmail.com
 Date: Wed, Jul 17, 2013 at 5:57 PM
 Subject: $$Excel-Macros$$ Re: Help Required
 To: excel-macros@googlegroups.com


 Hi All,

 I've found a more simpler way to get the time in hrs and minute..
  And yes i've seen all ur tricks for this..i dnt know where my trick
 fails...but i am getting the desired output via my trick also..

 so its a question just out of curiosity that my trick is wrong or not, and
 if it's wrong then please suggest what's wrong with it...

 Attached the File for your reference.


 On Wednesday, July 17, 2013 3:41:31 PM UTC+5:30, neeraj chauhan wrote:

  Dear experts,



 How to subtract time in hours and minute



 10:30 AM

 -  10:30 PM

 =



 * *

 *Thanks  Regards*

 *Neeraj Chauhan*

 *+91-9756706350*

 *neerajch...@gmail.com*



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



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






-- 









P.VIJAY KUMAR

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

Re: Fwd: $$Excel-Macros$$ Un hide a workbook

Respected Kaushal,

I think that the file is saved as read only and modifications and editing
are prohibited.The procedure of saving the excel file or any office file as
read only is as per the following link
http://support.microsoft.com/kb/214094.You can see the file but hen you
open the file the sheets are not displayed.If that is the case the file is
marked for read only and can be modified or edited only with a
password.Please look into the link and if you need further information you
can google for the procedure.If you want to alter the file contents ask for
the viewing and editing passwords from the person who made the file read
only.

Regards,
Vijaykumar


On Wed, Jul 17, 2013 at 6:00 PM, Kaushal Kumar kaushal.anal...@live.comwrote:

 Apologies, I can not share that file

 Rgds, Kaushal

 -Original Message-
 From: Pravin Gunjal isk1...@gmail.com
 Date: Wed, 17 Jul 2013 12:26:18
 To: excel-macros@googlegroups.com
 Subject: Fwd: $$Excel-Macros$$ Un hide a workbook

 post the file at group.


 -- Forwarded message --
 From: Kaushal Kumar kaushal.anal...@live.com mailto:
 kaushal.anal...@live.com 
  Date: Wed, Jul 17, 2013 at 5:54 PM
 Subject: $$Excel-Macros$$ Un hide a workbook
 To: Excel VBA Group excel-macros@googlegroups.com mailto:
 excel-macros@googlegroups.com 


 Dear All,

  When I am opening an excel file it seems it is open but not visible.
 Seems like entire workbook is as been hidden.

  Can someone please help how can we retrieve that file.

  Rgds Kaushal

  Rgds, Kaushal

  --
  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 mailto:
 excel-macros%2bunsubscr...@googlegroups.com .
  To post to this group, send email to excel-macros@googlegroups.commailto:
 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.




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



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

Re: $$Excel-Macros$$

Respected Anil,

The dashboard is wonderful and fabulous.If you have designed it yourself
you are a top class excel genius and a excel expert.

Thanking you once again for the Dashboard.

Regards,
VijayKumar


On Wed, Jul 17, 2013 at 2:10 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:

 Dear Rajesh,

 Pl see the attached workbook.

 Warm Regards,
 Gawli Anil


 On Wed, Jul 17, 2013 at 1:01 PM, Rajesh Agarwal rajey...@gmail.comwrote:

 Hello everyone
 Is there anyone in the group having macro calculation sheet for indian
 stock or commodity market. If yes, I request to share with us.
 Rgds.

 --
 *Rajesh Kumar Agarwal*
 *9811063001*

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






 --
 Thanks  Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd

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






-- 









P.VIJAY KUMAR

-- 
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: Fwd: $$Excel-Macros$$ Un hide a workbook

Respected Kaushal,

If the file is hidden through a standard windows query you can go to the
properties tab and uncheck the hide button to unhide the sheet.Sometimes it
may be encrypted or user permissions to open or modify the file may be
restricted by the system administrator or the owner of the document. Within
excel the content may be password protected or restricted access can be
given if the work book is shared.

Regards,
Vijaykumar


On Wed, Jul 17, 2013 at 6:38 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Hi Kausal,

 This is not possible to hide all sheets in excel. atleast one file should
 be visible. i hope the rows and colums are hidden.

 just check u can see the sheet names in that file. if so then just try to
 unhide the rows and columns.

 To unhide the rows and columns:

 in 2007 verson : Goto Home tab-- Cells option -- Format -- change
 the column with from 0 to any value..

 now ur sheet will be visible.


 Thanks  Regards,
 Prabhu R


 On 17 July 2013 18:00, Kaushal Kumar kaushal.anal...@live.com wrote:

 Apologies, I can not share that file

 Rgds, Kaushal

 -Original Message-
 From: Pravin Gunjal isk1...@gmail.com
 Date: Wed, 17 Jul 2013 12:26:18
 To: excel-macros@googlegroups.com
 Subject: Fwd: $$Excel-Macros$$ Un hide a workbook

 post the file at group.


 -- Forwarded message --
 From: Kaushal Kumar kaushal.anal...@live.com mailto:
 kaushal.anal...@live.com 
  Date: Wed, Jul 17, 2013 at 5:54 PM
 Subject: $$Excel-Macros$$ Un hide a workbook
 To: Excel VBA Group excel-macros@googlegroups.com mailto:
 excel-macros@googlegroups.com 


 Dear All,

  When I am opening an excel file it seems it is open but not visible.
 Seems like entire workbook is as been hidden.

  Can someone please help how can we retrieve that file.

  Rgds Kaushal

  Rgds, Kaushal

  --
  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 mailto:
 excel-macros%2bunsubscr...@googlegroups.com .
  To post to this group, send email to excel-macros@googlegroups.commailto:
 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.




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



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

Re: $$Excel-Macros$$ Extract the data from one sheet to multiple sheets

2013-07-16 Thread P.VIJAYKUMAR

Respected Pravin,

Create a sheet and remove the Totals rows.This you can selecting and
deleting them using filter.Then Create a Pivot table with Head quarter in
the Report Filter Field and all your required fields as per your required
layout.Now go to the Pivot table Options and select the Create report
filter pages option. You will get all the Sheet created as per the head
quarters with totals.But Your sheets begin with column 2 and Column 1 will
not there.I think your actual requirement will be met even without column
1,because you will get sheets generated according to the head quarters only.

Regards,
VijayKumar


On Tue, Jul 16, 2013 at 2:01 PM, Pravin Gunjal isk1...@gmail.com wrote:

 Hi, I need to extract the data from one sheet to multiple sheets based on
 column A.

 That means the separate sheets must be created Head Quarter wise with
 it's total line.  And Row No. 1  2 would be the common for all the sheets.

 Kly help.  Thanks,

 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/groups/opt_out.






-- 









P.VIJAY KUMAR

-- 
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$$ Query on lookup left side and second, and third values

2013-07-16 Thread P.VIJAYKUMAR

Respected Muralidhar,

You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible by VLookup.

Regards,
VijayKumar


On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:

 Dear Murlidhar,

 Please visit here..

 http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html



 On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote:


 Dear Friends good afternoon,

 I need help reg. lookup values

 1.It is possible to vlookup the values for the left side
  2.Vlookup for the second value(occurence), third value
 Is their any other ways or functions to get the results.?

 Thanks in advance.

 --
  *Thanks  Regards,*
 **
 *Muralidhar E.*
 Think different
 Do Different
 Make different

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






 --
 With Regards,
 Noorain Ansari
 http:// 
 http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
 http:// 
 http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/

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






-- 









P.VIJAY KUMAR

-- 
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$$ Query on lookup left side and second, and third values

2013-07-16 Thread P.VIJAYKUMAR

Respected Muralidhar,

You can see the following links for Examples
http://exceluser.com/blog/465/excels-best-lookup-method-index-match.html
http://www.youtube.com/watch?v=IX2TZ3OlOlA
http://www.randomwok.com/excel/how-to-use-index-match/

Regards,
Vijaykumar

On Tue, Jul 16, 2013 at 3:37 PM, Muralidhar E emuralidha...@gmail.comwrote:

Hi,

ThanksVijay. can u present me with an example,it is better to understand
me.

Thanks in advance.

On 16 July 2013 15:07, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

Respected Muralidhar,

You can use Index,Match,Indirect functions for accomplishing some look up
tasks which are not possible by VLookup.

Regards,
VijayKumar

On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:

Dear Murlidhar,

Please visit here..

http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html

On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E
emuralidha...@gmail.comwrote:

Dear Friends good afternoon,

I need help reg. lookup values

1.It is possible to vlookup the values for the left side
2.Vlookup for the second value(occurence), third value
Is their any other ways or functions to get the results.?

Thanks in advance.

--
*Thanks Regards,*
**
*Muralidhar E.*
Think different
Do Different
Make different

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

--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/
http://
http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/

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

P.VIJAY KUMAR

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

Re: $$Excel-Macros$$ Pie Chart Help

2013-07-01 Thread P.VIJAYKUMAR

Respected Priti Madam,

I have also pasted the doughnut chart on the pie chart as mentioned by you
in the process.After that when I Change the inner doughnut into a pie chart
the whole chart is becoming a pie chart and it does not remain a
combination chart.I do not understand the reason for this.Is the process
right or any special feature  or add-in needs to be installed for that.

Regards,
VIJAYKUMAR


On Mon, Jul 1, 2013 at 3:04 PM, Rajan sharma rajansharma9...@gmail.comwrote:

 Hi All,

   I got idea and have plotted, please find the attachment. See if it is
 ok. if needed please suggest with different charts.

 Warm regards,
 Rajan Sharma



 On Mon, Jul 1, 2013 at 2:42 PM, Rajan sharma rajansharma9...@gmail.comwrote:

 Dear Priti Mam,

Thanks for the solution provided.

 Now i am trying to plot the same graph for different data, i don't
 understand why it is not working. please check and let me know.

 As of now, i have inserted some pie-shapes above the Doughnut graph in
 attachment. please find the attachment for data and more clarities.


  Warm regards,
 Rajan Sharma



 On Thu, Jun 27, 2013 at 12:27 PM, priti verma 
 pritiverma1...@gmail.comwrote:

 Hi vijay,
 Pfa for more clarification



 On Wed, Jun 26, 2013 at 1:57 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote:

 Respected priti,

 I tried to  paste the donought chart on the pie chart,but only a single
 chart is showing not both charts,how should we make both charts show at a
 time like the one you did in the attachment.


 Regards,
 VIJAYKUMAR

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




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





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

Re: $$Excel-Macros$$ how to solve international decimal and comma separator issue,

2013-06-27 Thread P.VIJAYKUMAR

Respected Divakar,

You can check the following link.It might be of some help to  you.
http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html

Regards,
VIJAYKUMAR


On Thu, Jun 27, 2013 at 4:16 PM, Divaker Pandey divake...@gmail.com wrote:


 Hi Expert,

 how to solve international  decimal and comma separator issue, it data
 download from web in US Format


 Thanks  Regards,
 Divaker

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






-- 









P.VIJAY KUMAR

-- 
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$$ Pie Chart Help

Respected Ranjan,

When you select the data for the chart select the complete table along with
C also.You have selected in the data upto B only and plotted the Pie
Chart.Select C data also and plot the Chart and you will get the chart as
per your requirement.


Regards,
VIJAYKUMAR


On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.comwrote:

 Dear All,

   I am trying to plot Pie chart, but unable to plot as per my data. Can
 somebody help me in plotting the data as pie chart. My requirement and the
 criteria is attached here with, plse find the attachment.

   Actually as of now i have done with the shapes and tried to explain,
 plse refer attached file.

 Thanks


 With warm regards,
 Rajan Sharma


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






-- 









P.VIJAY KUMAR

-- 
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$$ Pie Chart Help

Respected Ranjan,

For that type of data you can use a stacked pie chart or a pie of pie chart
.You can find how to prepare a stacked pie chart in Ms Excel Help or you
can follow the following links also.hope they may be of some help to you

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471
http://office.microsoft.com/en-in/excel-help/creating-pie-of-pie-and-bar-of-pie-charts-HA001117937.aspx

Regards,
VIJAYKUMAR

On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.comwrote:

Yes sir, your points are valid, but you know, My requirement is not that.
let me explain you, please see the below image. There you will find A and B
is the Main type, C (light orange color) is only a subset of B, So,
A= 927688
B= 1093947
Now C = 20 should be under B Area, it means out of total B area, some
portion of C is covered.

Hope you might have understand my query. thanks sir.

[image: Inline image 1]

With warm regards,
Rajan Sharma

On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote:

Respected Ranjan,

When you select the data for the chart select the complete table along
with C also.You have selected in the data upto B only and plotted the Pie
Chart.Select C data also and plot the Chart and you will get the chart as
per your requirement.

Regards,
VIJAYKUMAR

On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma rajansharma9...@gmail.com
wrote:

Dear All,

I am trying to plot Pie chart, but unable to plot as per my data. Can
somebody help me in plotting the data as pie chart. My requirement and the
criteria is attached here with, plse find the attachment.

Actually as of now i have done with the shapes and tried to explain,
plse refer attached file.

Thanks

With warm regards,
Rajan Sharma

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

P.VIJAY KUMAR

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

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

Re: $$Excel-Macros$$ Pie Chart Help

Respected Priti,

Can you explain the process of fusing the Pie and Doughnut Chart.How to
edit the series as to show both the charts as single chart as shown in your
attachment.Can you explain the process of making the chart or can you give
a link to it.

Thanks in advance,

Regards,
VIJAYKUMAR

On Wed, Jun 26, 2013 at 12:39 PM, Rajan sharma rajansharma9...@gmail.comwrote:

Thanks Priti and Vijay and to all, yes it will help me to figure out my
solution. thanks a ton champs.

With warm regards,
Rajan Sharma

On Wed, Jun 26, 2013 at 12:30 PM, P.VIJAYKUMAR vijay.4...@gmail.comwrote:

Respected Ranjan,

For that type of data you can use a stacked pie chart or a pie of pie
chart .You can find how to prepare a stacked pie chart in Ms Excel Help or
you can follow the following links also.hope they may be of some help to you

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471

http://office.microsoft.com/en-in/excel-help/creating-pie-of-pie-and-bar-of-pie-charts-HA001117937.aspx

Regards,
VIJAYKUMAR

On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.com
wrote:

Yes sir, your points are valid, but you know, My requirement is not
that. let me explain you, please see the below image. There you will find A
and B is the Main type, C (light orange color) is only a subset of B, So,
A= 927688
B= 1093947
Now C = 20 should be under B Area, it means out of total B area,
some portion of C is covered.

Hope you might have understand my query. thanks sir.

[image: Inline image 1]

With warm regards,
Rajan Sharma

On Wed, Jun 26, 2013 at 11:46 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote:

Respected Ranjan,

Regards,
VIJAYKUMAR

On Wed, Jun 26, 2013 at 11:23 AM, Rajan sharma
rajansharma9...@gmail.com wrote:

Dear All,

I am trying to plot Pie chart, but unable to plot as per my data.
Can somebody help me in plotting the data as pie chart. My requirement and
the criteria is attached here with, plse find the attachment.

Actually as of now i have done with the shapes and tried to explain,
plse refer attached file.

Thanks

With warm regards,
Rajan Sharma

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

P.VIJAY KUMAR

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

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT

Re: $$Excel-Macros$$ Pie Chart Help

Respected priti,

I tried to  paste the donought chart on the pie chart,but only a single
chart is showing not both charts,how should we make both charts show at a
time like the one you did in the attachment.


Regards,
VIJAYKUMAR

-- 
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$$ Web links in word - reg.

2013-06-22 Thread P.VIJAYKUMAR

Respected Pravin,

How do I turn off automatic hyperlinks?
To turn off automatic hyperlinks, follow these steps, as appropriate for
the version of Word that you are running:
In Microsoft Office Word 2010and 2013, follow these steps:
On the File menu, click Options.
Click Proofing, and then click AutoCorrect Options.
On the AutoFormat as you type tab and on the AutoFormat tab, click to clear
the Internet and network paths with hyperlinks check box, and then click
OK.
Click OK to close the Word Options dialog box.
In Microsoft Office Word 2007, follow these steps:
Click the Microsoft Office Button, and then click Word Options.
Click Proofing, and then click AutoCorrect Options.
On the AutoFormat as you type tab and on the AutoFormat tab, click to clear
the Internet and network paths with hyperlinks check box, and then click OK.
Click OK to close the Word Options dialog box.

Regards,
P.VIJAY KUMAR

-- 
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$$ CAPTURE ATTENDENCE FROM MULTIPLE SHEET

2013-06-18 Thread P.VIJAYKUMAR

Respected Preethiji,

Where and how did u learn these advanced excel formulas and also VBA.How to
get to Intermediate or to expert level like you in Excel and VBA.Is it
through regular practice or should be take coaching or classes for that.

Regards,
P.VIJAY KUMAR

-- 
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$$ Need information about MOS Certificate

2013-06-15 Thread P.VIJAYKUMAR

Respected Prabhakar,

You can find information from the following links,
http://www.microsoft.com/learning/en/us/mos-certification.aspx#fbid=x8BGjYz2g2o
http://www.onlc.com/excel-certification-mos.html
http://www.excelprodigy.in/microsoft-certification.html#.UbxVsT4isRA
http://www.ehow.com/how_6240458_obtain-microsoft-excel-certification.html
http://www.cyberlearningindia.org/microsoft_mos.asp

These may provide you some help.There are also some videos on you tube on
this topic.Check them also.


Regards,
P.VIJAY KUMAR

-- 
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$$ Excel Training Material (PPT)

2013-06-12 Thread P.VIJAYKUMAR

Respected Prabhakar,

Go to google docs through the link provided at the bottom of the mail i.e
Learn Exceel with Fun.pptx.Then go to the file menu in google doc and go to
the download tab to download the file.

Regards,
VIJAYKUMAR


On Wed, Jun 12, 2013 at 1:08 PM, Prabhakar S H prabakar.k...@gmail.comwrote:

 Hi,
 I am getting erro while opening that link.

 Rgds,
 Prabhakar

 On Wednesday, June 12, 2013 9:36:11 AM UTC+5:30, Vabz wrote:

 Hi

 Try this, hope it will help:

 https://docs.google.com/open?**id=**0B7i2wkMBVw9xQV9tb3hhZVdXWFEhttps://docs.google.com/open?id=0B7i2wkMBVw9xQV9tb3hhZVdXWFE

 Thanks


 On Wed, Jun 12, 2013 at 9:25 AM, Prabhakar S H prabak...@gmail.comwrote:

 Dear Team,

 MY HR given me responsibility to give training on Excel to my Marketing
 team. So can you send me the materilals on Basic  advance traning.

 I have engough experience on Excel but don't know where to start.

 So please send me either PPT or material on Basic as well as advance
 trainnig.

 Pls help.

 Rgds,
 Prabhakar

 --
 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/**discussexcelhttps://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.
 To post to this group, send email to excel-...@googlegroups.com.

 Visit this group at 
 http://groups.google.com/**group/excel-macros?hl=enhttp://groups.google.com/group/excel-macros?hl=en
 .
 For more options, visit 
 https://groups.google.com/**groups/opt_outhttps://groups.google.com/groups/opt_out
 .




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

 FORUM RULES

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

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






-- 









P.VIJAY KUMAR

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: List in Userform

2013-06-11 Thread P.VIJAYKUMAR

Respected Chandrashekar,

View the following link.Hope it helps you to create a List User form
Control.

http://mindkid.blogspot.in/2011/10/adding-listview-additional-activex.html

Regards,
VIJAYKUMAR



On Tue, Jun 11, 2013 at 4:30 PM, Lalit Mohan Pandey 
mohan.pande...@gmail.com wrote:

 Why don't you use listview form control.

 On Friday, 7 June 2013 18:38:48 UTC+5:30, Chandru wrote:

 Hi,

 How to get List as attached in the userform


 Regards,

 Chandra

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

 FORUM RULES

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

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






-- 









P.VIJAY KUMAR

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ help needed

2013-06-09 Thread P.VIJAYKUMAR

Respected Thameem,

After inserting the graph you get the chart tools in the menu bar. In the
chart tools menu go to the formatting tab. In the last tab (to the right)
you will find size munu.Click the small arrow down the tab and you will get
sizing message box with size and properties tabs.In the size tab check
whether lock aspect ratio ratio checkbox is checked(ticked) or not .If it
is not check it.In the properties tab ,select the second radio button move
and don't resize with cells.hope this should solve your problem.The problem
may also due to macros or virus in the system it is better to  check the
system for both.

Regards,
VIJAYKUMAR



On Mon, Jun 10, 2013 at 7:11 AM, thameem thamee...@gmail.com wrote:

 am sorry, it is office file, I am working for gas plant, they dont allow
 us to use USB or to upload any official file in mail.

 regards,
 Thameem.M


 On Sun, Jun 9, 2013 at 1:56 PM, priti verma pritiverma1...@gmail.comwrote:

 Can you please share your file


 On Sun, Jun 9, 2013 at 2:32 PM, thameem thamee...@gmail.com wrote:

 Dear sir's,

 I have problem in excel graph, its automatically getting enlarged, if i
 close and open excel, then again it will be in original size, with out any
 modification, please advise me


 regards,

 Thameem.m

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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




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

 FORUM RULES

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

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

Re: $$Excel-Macros$$ Insert Logo in Excel

2013-06-07 Thread P.VIJAYKUMAR

Respected Pravin,

Check the following link
http://www.techrepublic.com/blog/msoffice/quickly-add-a-header-or-footer-to-every-sheet-in-an-excel-workbook/6601.
it might be of some help to you

Regards,
VIJAYKUMAR


On Fri, Jun 7, 2013 at 6:42 PM, Pravin Gunjal isk1...@gmail.com wrote:

 I have attached a sample file with logo of a company.  I want this logo
 (or any other picture/logo) to be inserted in all the sheets at a time.
  How this can be done, please advice.

 Thanks in advance.

 Regards
 Pravin Gunjal.

 -- Forwarded message --
 From: ashish koul koul.ash...@gmail.com
 Date: Thu, Jun 6, 2013 at 8:32 PM
 Subject: Re: $$Excel-Macros$$ Insert picture in an excel's many sheets
 To: excel-macros excel-macros@googlegroups.com

 can u share the sample file

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

 FORUM RULES

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

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






-- 









P.VIJAY KUMAR

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Re: Formula require

2013-06-06 Thread P.VIJAYKUMAR

Respected Eugene Bernard,

The double negative is used to coerce, as we say, a non-number type into
a
number type. Since only a number (not text, boolean, error value, etc.) can
follow a minus sign, one minus sign forces the coercion to a number. The
 other just reverses the sign change caused by the first one.

For complete explanation together with examples please see the following
link : *http://www.mcgimpsey.com/excel/formulae/doubleneg.html*

Regards,
VIJAYKUMAR


On Tue, Jun 4, 2013 at 7:43 PM, Eugene Bernard eugene.bern...@gmail.comwrote:

 Hi Prince,

 What is the use of -- in the formula mentioned by you.

 The result is OK, but I do not find this of syntax in Excel Help.

 Please elaborate.

 Regards
 Eugene


 On Tue, Jun 4, 2013 at 5:16 PM, Prince prince141...@gmail.com wrote:

 may be it can help you.

 =SUMPRODUCT(--(I9:I17=Black),--(H9:H17=Cars),(J9:J17))

 Regards
 Prince

 On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote:

 Hi Team,

 i want to get formula to find Total value of cars with black color only.
 pls help.

 Rgds,
 Prabhakar

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






-- 









P.VIJAY KUMAR

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Marge Data from Different workssheet.

2013-06-04 Thread P.VIJAYKUMAR

Respected Tariq,

You can also download the add-in called Kutools from the following link :
http://www.extendoffice.com/download/kutools-for-excel.html

Regards,
VIJAY KUMAR

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Please help Excel Gurus

2013-06-04 Thread P.VIJAYKUMAR

Respected Harish,

On what ratio do you want to distribute the amount based on the date.what
are the specific criteria for distributing.

Regards,
VIJAYKUMAR


On Tue, Jun 4, 2013 at 9:22 AM, Harish P Y py.har...@gmail.com wrote:

 Hi Every One,
 Please find the attached file,
 Kindly help me with the required formula

 In the file there is a table,
 with start date end date amount and corresponding months in rows
 i want a formula to distribute the amount month wise by referring to start
 date and end date
 Kindly help me regarding this issue.

 Regards
 Harish

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

 FORUM RULES

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

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






-- 









P.VIJAY KUMAR

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Family Tree

2013-05-31 Thread P.VIJAYKUMAR

Respected Prabhu,

The family tree is just used to find the hierarchy in the family.It shows
how the authority and relationships flow in the family.It is similar to an
organisation chart which shown the authority and responsibility flow from
the top(MD or Chairman) and to the floor level executives.

Regards,
VIJAYKUMAR

On Fri, May 31, 2013 at 5:01 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

can anyone pls tellme how this family tree works.. and what is the
purpose..?

Thanks Regards,
Prabhu R

On 31 May 2013 16:25, Pravin Gunjal isk1...@gmail.com wrote:

*Thanks Mr. Vijay.*

-- Forwarded message --
From: P.VIJAYKUMAR vijay.4...@gmail.com
Date: Fri, May 31, 2013 at 11:52 AM
Subject: Re: $$Excel-Macros$$ Family Tree
To: excel-macros@googlegroups.com excel-macros@googlegroups.com

Respected Pravin,

Please find the attached format of a family tree that is downloaded from
the link.Yes it is possible to make a family tree and also other process
flow diagrams in excel.Watch the youtube link attached in the earlier mail.

Regards,
VIJAYKUMAR

On Fri, May 31, 2013 at 9:46 AM, Pravin Gunjal isk1...@gmail.com wrote:

Dear Mr Vijay,

I am unable to download the file from the link given below.

Is it possible to make family tree in an excel file?

Regards
Pravin Gunjal.

-- Forwarded message --
From: P.VIJAYKUMAR vijay.4...@gmail.com
Date: Thu, May 30, 2013 at 8:34 PM
Subject: Re: $$Excel-Macros$$ Family Tree
To: excel-macros@googlegroups.com excel-macros@googlegroups.com

Respected Pravin,

You can download the file from the following addresses
http://office.microsoft.com/en-us/ctndirectdownload.aspx?AssetID=TC001021967Application=XL,Version=11Result=2
and also you have a youu tube video for that in this link
http://www.youtube.com/watch?v=4Xymxie4beg.

Regards,
VIJAYKUMAR

On Thu, May 30, 2013 at 7:56 PM, Pravin Gunjal isk1...@gmail.comwrote:

HI,

Is anybody having an example file how to make family tree.
Suggestions / advice are welcome.

Thanks,

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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

P.VIJAY KUMAR

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

FORUM RULES

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

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

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

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Video in Word File

2013-05-30 Thread P.VIJAYKUMAR

Respected Pravin,

I downloaded the file and played the video.It is a nice animation about
traffic rules or road ethics.

Regards,
VIJAYKUMAR

On Thu, May 30, 2013 at 6:10 PM, Pravin Gunjal isk1...@gmail.com wrote:

*Thanks.*

-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Thu, May 30, 2013 at 5:49 PM
Subject: Re: $$Excel-Macros$$ Video in Word File
To: excel-macros@googlegroups.com

firstly install flash player then try to play

and for more information about Embed swf in word file

http://www.walkernews.net/2009/04/24/how-to-embed-swf-file-or-shockwave-flash-object-in-microsoft-word-2007/

Enjoy
Team XLS

On Thu, May 30, 2013 at 5:12 PM, Pravin Gunjal isk1...@gmail.com wrote:

May I know how to play the video in Word file, as I couldn't see anything
in attached file. Thanks.

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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

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

FORUM RULES

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

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

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

FORUM RULES

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

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

P.VIJAY KUMAR

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

Re: $$Excel-Macros$$ Family Tree

2013-05-30 Thread P.VIJAYKUMAR

Respected Pravin,

You can download the file from the following addresses
http://office.microsoft.com/en-us/ctndirectdownload.aspx?AssetID=TC001021967Application=XL,Version=11Result=2
and also you have a youu tube video for that in this link
http://www.youtube.com/watch?v=4Xymxie4beg.

Regards,
VIJAYKUMAR


On Thu, May 30, 2013 at 7:56 PM, Pravin Gunjal isk1...@gmail.com wrote:

 HI,

 Is anybody having an example file how to make family tree.
 Suggestions / advice are welcome.

 Thanks,

 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?hl=en.
 For more options, visit https://groups.google.com/groups/opt_out.






-- 









P.VIJAY KUMAR

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ Urgent help plss..

2013-05-29 Thread P.VIJAYKUMAR

Respected Prabhu,

Verify that the  other cells linked to it are not hidden.Remove any
formulas or links(hyper links or  other links) that the cell contains with
other sheets.Also verify that whether multiple cell which are hidden around
the cell are not selected  when you select the cell.If the cell contains
array formulas or if the cell is a part of a calculated field then also
copying and deleting is not possible.

Regards,
VIJAYKUMAR


On Wed, May 29, 2013 at 9:34 AM, Pravin Gunjal isk1...@gmail.com wrote:

 Pl share your file with group.
 And use the appropriate subject for your query.

 On Tue, May 28, 2013 at 6:44 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Nope I have selected only one cell in only one sheet.

 Prabhu R
 On May 28, 2013 3:50 PM, David Grugeon da...@grugeon.com.au wrote:

 Perhaps you have more than one sheet selected.

 Regards
 David Grugeon



 On 28 May 2013 14:37, Prabhu Pinky prabhupin...@gmail.com wrote:

 hi experts

 I have one excel, from that excel I am unable to copy and paste the
 data to new excel..even a single cell..am getting this command is cannot
 be processd in multiple selection error message..

 But am sure I selected and copied only single, but donno how am getting
 thus errorpls help...

 Prabhu R

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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



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

 FORUM RULES

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

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

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread P.VIJAYKUMAR

Respected Prabhu,

Please  go to excel options button and from there go to the advanced tab
and under that go to the formulas section.The third point will contain how
many processors are used for excel calculations.check the radio button to
use all the processors for calculations.This may boost up ur speed a little
bit.There may be various other reasons for slowness of the processes like
compatibility issues,macros errors or virus etc.I frequently face this
problem when the workbook contains plenty of calculations and number of
sheets and every small step even a copy and format takes many minutes to
accomplish.

Regards,
Vijaykumar


On Thu, May 23, 2013 at 4:15 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Hi Abhishek : thanks for the idea. i will try this one.


 David : i am unable attach the file, because it is violation in our office.





 On 23 May 2013 13:39, David Grugeon da...@grugeon.com.au wrote:

 Can't guess without seeing the file.  Can you attach it?

 Regards
 David Grugeon



 On 23 May 2013 16:49, Prabhu Pinky prabhupin...@gmail.com wrote:

 Hi experts,
 I have one excel file. Size is below 1mb. Even though it is very slow
 working in that file. If I do copy paste any single cell, it takes too much
 time.

 What could be the reasons...?

 Prabhu R

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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




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

Re: $$Excel-Macros$$ Problem in file..?

2013-05-23 Thread P.VIJAYKUMAR

Respected Prabhu,

You are saying that the sheet is companies sheet.Is is password protected
or are any user rights restricted to used and to modify or make any changes
to the file.Check also for version based compatibility issues because
earlier version had lower data input and processing capabilities compared
to the latest versions.Increasing you systems processor speed may also
solve the problem.If you do not have much data in the file crate a fresh
file with the same data because many time by some error the file gets
 corrupted and the new file works perfectly alright without any problems.To
know how much processing memory and time is  consumed by excel during the
stuck time start the Task manager and go to processes tab and search for
excel in the process. I think the processing time and memory used will be
more during that period.the problem can only be dealt with specifically if
only we know what exactly is causing the problem.

Regards,
VIJAYKUMAR


On Thu, May 23, 2013 at 5:23 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

 No david..that sheet contains no macros, even very less formula. Only the
 thing is some cells have formatted...

 Prabhu R
 On May 23, 2013 5:20 PM, David Grugeon da...@grugeon.com.au wrote:

 Also do you have macros which are run when changes are made to the
 sheets.  It may be possible to reorganise them so they run faster or are
 not triggered so readily.

 Regards
 David Grugeon



 On 23 May 2013 21:47, David Grugeon da...@grugeon.com.au wrote:

 Try setting the calculation to Manual.  Then see if Cut and Paste still
 takes a lot of time.  It could be that there are a lot of formulas having
 to be recalculated when there is a change to the worksheet.  If this is
 identified as the cause you may be able to get a gain by redesigning hr
 worksheets, or by keeping calculation turned off and pressing F9 when you
 want it to calculate.

 Regards
 David Grugeon



 On 23 May 2013 21:26, Prabhu Pinky prabhupin...@gmail.com wrote:

 thanks vijay, lemme try this too.

 but my doubt is if already Use all the processors on this computer
 option is selected. then..?


 Regards,
 Prabhu R



 On 23 May 2013 16:48, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Respected Prabhu,

 Please  go to excel options button and from there go to the advanced
 tab and under that go to the formulas section.The third point will contain
 how many processors are used for excel calculations.check the radio button
 to use all the processors for calculations.This may boost up ur speed a
 little bit.There may be various other reasons for slowness of the 
 processes
 like compatibility issues,macros errors or virus etc.I frequently face 
 this
 problem when the workbook contains plenty of calculations and number of
 sheets and every small step even a copy and format takes many minutes to
 accomplish.

 Regards,
 Vijaykumar


 On Thu, May 23, 2013 at 4:15 PM, Prabhu Pinky 
 prabhupin...@gmail.comwrote:

 Hi Abhishek : thanks for the idea. i will try this one.


 David : i am unable attach the file, because it is violation in our
 office.





 On 23 May 2013 13:39, David Grugeon da...@grugeon.com.au wrote:

 Can't guess without seeing the file.  Can you attach it?

 Regards
 David Grugeon



 On 23 May 2013 16:49, Prabhu Pinky prabhupin...@gmail.com wrote:

 Hi experts,
 I have one excel file. Size is below 1mb. Even though it is very
 slow working in that file. If I do copy paste any single cell, it 
 takes too
 much time.

 What could be the reasons...?

 Prabhu R

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

 FORUM RULES

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

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




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

 FORUM RULES

 1

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

2013-05-18 Thread P.VIJAYKUMAR

Respected Prabhu,

It think the file didn't get attached.Please find them,


On Fri, May 17, 2013 at 7:15 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Dear Vijaykumar,

 which file u refer to..? i dont find any attachment.



 On 17 May 2013 10:02, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Respected Prabhu,

 Hope this file will be of little help to u.


 Regards,
 VIJAYKUMAR


 On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Hi all,

 I am very new to VBA working in MNC as a WFM specialist. we are working
 lots of reports on a monthly, weekly as well as daily basis.

 i came acrossed many situation to create report, but i do it manually. i
 wants to became a expert or atleast intermediate in creating VBA reports in
 excel.

 Can anyone please refer a best way how can i learn VBA from beginning
 but in clear. sometimes i do record macro and trying to understand the
 codes. since i dont know about the actual working method of codes i cannot
 understand the codings.

 Please help me.

 Thanks
 Prabhu R

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

 FORUM RULES

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

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






 --









 P.VIJAY KUMAR

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






-- 









P.VIJAY KUMAR

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

Re: $$Excel-Macros$$ Am new to VBA - help me to became expert.

2013-05-16 Thread P.VIJAYKUMAR

Respected Prabhu,

Hope this file will be of little help to u.


Regards,
VIJAYKUMAR


On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky prabhupin...@gmail.comwrote:

 Hi all,

 I am very new to VBA working in MNC as a WFM specialist. we are working
 lots of reports on a monthly, weekly as well as daily basis.

 i came acrossed many situation to create report, but i do it manually. i
 wants to became a expert or atleast intermediate in creating VBA reports in
 excel.

 Can anyone please refer a best way how can i learn VBA from beginning but
 in clear. sometimes i do record macro and trying to understand the codes.
 since i dont know about the actual working method of codes i cannot
 understand the codings.

 Please help me.

 Thanks
 Prabhu R

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

 FORUM RULES

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

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






-- 









P.VIJAY KUMAR

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

FORUM RULES

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

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

$$Excel-Macros$$ PIVOT TABLE FROM MULTIPLE SHEETS

2013-05-16 Thread P.VIJAYKUMAR

Respected Experts,

Is it possible to create a pivot table taking data (or fields) from
different  sheets of the workbook.









Regards,
P.VIJAY KUMAR

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

FORUM RULES

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

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

Re: $$Excel-Macros$$ IF FORMULA NOT WORKING

2013-05-15 Thread P.VIJAYKUMAR

Respected Experts,

My exact requirement is that if 12(or any constant number specific to
login) is typed in Cell B4 of the attachment it should display the log-in
time according to the formula or otherwise working.In the same way if 34
(or any constant number specific to log-out)  is mentioned in cell B5 the
log-out time should be displayed according to the formula.Suppose a person
log-in the morning the 12 is typed in B4 Cell, and if the person logs-out
at the evening the 34 is typed to get the evening log-out time.But, the
problem is if the system clock is changed after typing both log-in and
log-out times even to one minute more both the log-in and logout times are
changing irrespective of the IF Formula present there and the IF conditions
are not working.

Regards,
VIJAYKUMAR




On Wed, May 15, 2013 at 11:16 AM, Abhishek Jain abhishek@gmail.comwrote:

 Your query is not clear. There are no log out times in the attachment.

 Please elaborate.


 On Wed, May 15, 2013 at 10:59 AM, P.VIJAYKUMAR vijay.4...@gmail.comwrote:

 Respected Experts,

 I Have an excel sheet which is used for getting the log-in and log-out
 times of employees.I have used if formulas as is seen in the attachment.
 But, when log-in time is updated unfortunately log-out time is also
 changing even if the IF condition does not apply in the case. I don't
 understand what is the reason behind that.I hope the experts will clear and
 solve the matter or suggest alternative methods for achieving the goal.


 Regards,
 P.VIJAYKUMAR










 P.VIJAY KUMAR

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

 FORUM RULES

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

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




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

 FORUM RULES

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

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






-- 









P.VIJAY KUMAR

-- 
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-Macros$$ IF FORMULA NOT WORKING

2013-05-14 Thread P.VIJAYKUMAR

Respected Experts,

I Have an excel sheet which is used for getting the log-in and log-out
times of employees.I have used if formulas as is seen in the attachment.
But, when log-in time is updated unfortunately log-out time is also
changing even if the IF condition does not apply in the case. I don't
understand what is the reason behind that.I hope the experts will clear and
solve the matter or suggest alternative methods for achieving the goal.


Regards,
P.VIJAYKUMAR










P.VIJAY KUMAR

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

FORUM RULES

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

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




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

Re: $$Excel-Macros$$ All Sheet Name in a Column wise.........

2013-04-25 Thread P.VIJAYKUMAR

Respected Chaya,

There is also an add-in called Ultimate add-in,Which has features like
sort sheets and a lot of very useful features.It is available for 2007 and
earlier excel version also.Please find the attachment and install the
add-in.

Regards,
Vijaykumar

SetUp2007.exehttps://docs.google.com/file/d/0B2N9mHu03qQYRDRFNTVycDU4WTQ/edit?usp=drive_web

On Thu, Apr 25, 2013 at 9:38 PM, priti verma pritiverma1...@gmail.comwrote:

Hi chaya

Thanks to provided me this pfa of noorain sir.
Thanks
Priti verma

On Thu, Apr 25, 2013 at 9:18 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:

Hi Preety,

PFA Get Function by Noorain Sir. I hope it will help you.

Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail
unless you really need to.*
*
*
On Thu, Apr 25, 2013 at 9:04 PM, priti verma pritiverma1...@gmail.comwrote:

Hi chaya
actually i am not getting Get.workbook
how you use Get.workbook have you written any code for that or it is a
function in other version of excel

On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh
naukrikuld...@gmail.comwrote:

Thanks Chaya.

On Fri, Apr 12, 2013 at 12:55 PM, Chaya chayamon...@gmail.com wrote:

Dear Kuldeep,

Please find the attachment for your requirement.
Actually i got this formula from this forum. just sharing you.

You need to copy and paste down the formula in A colomn, thats all.

Regards,
Chaya

On Fri, Apr 12, 2013 at 12:43 PM, Kuldeep Singh
naukrikuld...@gmail.com wrote:

Hi Experts,

I want to all sheet name in column wise. See attachment.

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

FORUM RULES

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

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

Regards,

Chaya

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

FORUM RULES

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

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

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

FORUM RULES

1) Use

Re: $$Excel-Macros$$ Need help on Graph

2013-04-11 Thread P.VIJAYKUMAR

Dear Praful,

There is plenty of difference between Data Validation and a drop down box
from the developer tab.
The list box in the data validation or data validation in general is used
for  validating an entry  which adheres to specified condition or not.For
example when a cell or range of cells are validated to contain whole
numbers, then any data which is not a whole number many not be accepted in
that cell or range or errors or error messages pop out when an incorrect
entry is made. The error message can be modified according to our needs.All
the cells which do not meet the validation criteria may also be
distinguished   by using circle invalid  data. Now Combo boxes and list
boxes taken from developer tab are basically Form controls and Active X
Controls. They are used in designing User Forms and applications and have
properties distinctive to themselves.Then are mainly part of VBA are are
used in other applications also. The fundamental difference between the
validation list and the list box is that you can change the properties that
is shape,size,texture,colour,linked cell or range  of the list box but u
cannot do the same with  data validation.


Regards,
VijayKumar


On Thu, Apr 11, 2013 at 5:04 PM, Deepak Rawat deepakexce...@gmail.comwrote:

 Thanx!! to all of you

 it has solved my query completely.

 Regards,
 Deepak


 On Wed, Apr 3, 2013 at 10:58 AM, prafull jadhav 
 prafulltjad...@gmail.comwrote:

 Dear Anil,

 Ok..thanks .

 Can you clear one things here ..is there any different between validation
 and drop down box is taken from developer menu

 Regards,
 Prafull.

 On Wed, Apr 3, 2013 at 10:48 AM, अनिल नारायण गवली 
 gawlianil8...@gmail.com wrote:

 Dear Praful,

 Yes it is right. but even me didn't used any type of macro here . the
 dropdown box is taken from developer menu.

 Warm Regards,
 Gawli Anil


 On Wed, Apr 3, 2013 at 10:29 AM, prafull jadhav 
 prafulltjad...@gmail.com wrote:

 Dear Anil,

 I have created the same with help of validation and index formula by
 editing your chart without using Macro.

 Please confirm the same whether it is correct or not .

 Regard,
 Prafull Jadhav.

 On Wed, Apr 3, 2013 at 10:08 AM, अनिल नारायण गवली 
 gawlianil8...@gmail.com wrote:

 Dear Deepak,

 Pl see the attached sheet. Is it OK.

 Warm Regards,
 Gawli Anil


 On Tue, Apr 2, 2013 at 5:18 PM, Deepak Rawat 
 deepakexce...@gmail.comwrote:

 Hi

 Kindly find attached ,
 i need a graph which change as i select the desired cell.
 suppose if i want to see sales then when i wil select Sale cell the
 graph should show Sale bars Only and so on.

 Regards,
 Deepak Rawat

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

 FORUM RULES

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

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






 --
 Thanks  Regards,
 Gawli Anil Narayan
 Software Developer,
 Abacus Software Services Pvt Ltd

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

Re: $$Excel-Macros$$ Merge entry cell

2012-12-17 Thread P.VIJAYKUMAR

Respected Champs,


Can you explain why the exponential function 10^10 is used in the formula
=LOOKUP(10^10,E7:H7,E7:H7) i.e 10 to the power of 10 would yield a quite
large number and how can it be useful in the look up function.



Regards,
P.VIJAY KUMAR

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

FORUM RULES

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

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

$$Excel-Macros$$ Pie Charts

2012-12-13 Thread P.VIJAYKUMAR

Respected Guru's,


I have a curious question i.e why cannot pie chart represent two sets of
values.For Example if  I Take a table with Employee Name ,Salaries ,PF. I
can get Pie Chart for only for only two sets of values only like Name 
Salaries,Name  PF etc.Why do not we get a pie chart for more than two sets
of Values?

Regards
VIJAY KUMAR

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

FORUM RULES

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

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

$$Excel-Macros$$ Calculated Field

2012-09-17 Thread P.VIJAYKUMAR

Dear SG,


Calculated field works well in table.Try Creating a table for the data than
a pivot table. If you want a calculated field  in Pivot Table go to
formulas tab then select a calculated field  and  select the required
function  and the feils which you want to make a calculated field.


Regards,
P.VIJAY KUMAR

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Basic and advanced VBA

2012-09-14 Thread P.VIJAYKUMAR

Dear All,

How can I Learn Basic and advanced VBA. Is any material available with the
group members.Are there any websites for videos tutorials available.Please
provide details and materials as they would be immensely helpful to me.

Thanks for all the help and support in answering everyone's excel issues
and problems in an amicable and extraordinary  way.

Regards,
VIJAY KUMAR

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Embed Video in Excel

2012-08-16 Thread P.VIJAYKUMAR

Hello Hilary,

To Get the video Loaded in in Excel 2007. First Save the file in Excel
97-2003 Version. Then in the properties of the embedded video you will get
a custom tab in which you specify the URL or the path of the video.Then
exit the design mode.Now you will have your video playing in Excel. Enjoy.


Regards,
VIJAY KUMAR

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Finacial Excel Work Books

2012-08-16 Thread P.VIJAYKUMAR

Hi, Roopesh,

For Financial excel sheets you can visit www.exinfm.com which has about 100
free excel sheets catering fianancial topics.


Regards,
P.VIJAY KUMAR

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Embed video in excel

2012-08-16 Thread P.VIJAYKUMAR

Hi Hillary,


The main mistake you are doing is trying to play video from the site.First
save the required video or game to your PC. Then try embedding the videos
in Excel 97-2003 as explained earlier and it definitely works. I have
embedded many videos in excel.


Regards,
P.VIJAY KUMAR

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

$$Excel-Macros$$ Excel Finacial Dash Boards

2012-06-19 Thread P.VIJAYKUMAR

Hello Pankaj,

To get more financial Dashboards and templates visit www.exinfm.com.



Regards,
P.VIJAY KUMAR

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

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

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

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

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

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

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

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

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

$$Excel-Macros$$ converting excel file into xml file

2011-11-18 Thread P.VIJAYKUMAR

Dear Gurus,

Is there any method to convert Excel file into XML format.In some specific
software for impotring data .the data should be in xml format only,then
only we can import the data.I need any macro method or any thing  which
converts excel data into XML FILE FORMAT

Thanking you all ,

Regards.
Vijaykumar

-- 
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$$ Thanks everyone.

2011-10-05 Thread P.VIJAYKUMAR

Dear All,


I am very soory if I have Hijacked any ones thread. I have just replied to
the to the mail received by mesent by others congratulating Ayush on his
achievement . I have done so because it is the easiest way of getting reply
from the group and while using reply to earlier mail you cannot have a
subject line saparatelyto start a question with.Anyhow, I am very sorry if
in anyway I have crossstepped the policies or rules of the group.


Once again Thanks to all,


Thanks  Regards,
VIJAYKUMAR

On Wed, Oct 5, 2011 at 5:56 PM, dguillett1 dguille...@gmail.com wrote:

   You should never “hijack” a thread to ask a question. Instead, start
 your own with a new subject line. However, can you not use
 dataautofiltercustomends with DR?

  *From:* P.VIJAYKUMAR vijay.4...@gmail.com
 *Sent:* Tuesday, October 04, 2011 8:22 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Thanks everyone.

  Dear Ayush ,

 Congrats on your second achievement,

 I have a problem with excel.Generally I work with Tally and Excel.When I
 export accounting Data into excel, I am getting the data with debit and
 credit along with the number i.e I am getting the data in custom format (
 0.00 Dr). It is not possible to select only debit(dr) or only Credit
 (Cr)figures at one shot. As it is not possible to select by conditional
 formatting or by other mode we are selecting the required numbers using
 filters but that to is a very time consuming and tedious task as the data
 could range into thousands of numbers and selecting each one using a filter
 is atime consuming task.I would be truly grateful to you and the group
 members if any helpis offered in this regard.




 Regards,
 VIJAY KUMAR
 --

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

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

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

 --

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

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

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




-- 









P.VIJAY KUMAR

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


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

Re: $$Excel-Macros$$ Thanks everyone.

2011-10-04 Thread P.VIJAYKUMAR

Dear Ayush ,

Congrats on your second achievement,

I have a problem with excel.Generally I work with Tally and Excel.When I
export accounting Data into excel, I am getting the data with debit and
credit along with the number i.e I am getting the data in custom format (
0.00 Dr). It is not possible to select only debit(dr) or only Credit
(Cr)figures at one shot. As it is not possible to select by conditional
formatting or by other mode we are selecting the required numbers using
filters but that to is a very time consuming and tedious task as the data
could range into thousands of numbers and selecting each one using a filter
is atime consuming task.I would be truly grateful to you and the group
members if any helpis offered in this regard.




Regards,
VIJAY KUMAR

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


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

$$Excel-Macros$$ EXCEL VBA

2011-05-31 Thread P.VIJAYKUMAR

Dear All,


I am  Completely new to VBA.I don't know its terminology and how to write
programs to execute specific action in Excel.I want to learn Excel VBA in an
easy way.Any E book would be of immense help to me and other people  would
like to learn VBA.Please upload any  VBA material .




Regards,
P.VIJAY KUMAR

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


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

$$Excel-Macros$$ Problem with Nested IF formula

2011-05-18 Thread P.VIJAYKUMAR

Dear Ashish,


In our company we give cash discounts for the dealers who pay cash within
the stipulated time  period. The conditions are as in the following table

   CD  POLICY  FOR THE MONTH OF OCTOBER




 SlNo. CD PolicyCategory   2 Lakhs  1 Lakh  1 Lakh  1 Advance 10% 9%
8%  2  30 Days 8% 7% 6%  3  60 Days 6% 5% 4%  4  90 Days 4% 3% 2%
The table may be explained as follows.

If the person pays money in advance without doing billing he gets he gets
the discount as per the rates given in the advance row.If he make sales
(billing)  and pays amount within 30 to 90days he gets the discounts
according to the slabs prescribed for 30,60, 90 days respectively as shown
above. I am trying to write nested IF formula for the payments received but
I am unable to do so satisfying all conditions.

I request all the members and also all you personally  to write a
formula(Nested IF or any other formula) satisfying all the conditions which
would be of a great help in my job.




Thanks  Regards,
P.VIJAY KUMAR

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


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

Re: $$Excel-Macros$$ How to use a drop down list to select data from another sheet

2010-12-31 Thread P.VIJAYKUMAR

Dear Steve,


If you want to get a drop down list for data that is in Other sheet, First
set the cursor or ur position where u want the list to appear then go to the
sheet  which you have the data then select all the Data and give a name to
the range of cells you have selected or in other words create a named
range.After that go to Data Validation in the DATA menu and in the Options
available select List and in the Cell reference give the name of of the
 Named range that you have named before. then you can have you list in you
required cell.even though you data is in other sheet.



Regards,
Vijaykumar

On Thu, Dec 30, 2010 at 7:20 PM, Steve stevebwea...@comcast.net wrote:

 Each month I must compare monthly expenses to the budget (forecast).
 To do this I have created a spreadsheet with a drop down list where
 the user selects the appropriate month to analyze. I would then like
 the data to be pulled in from another tab using the appropriate column
 based on the month selected. However, I am having trouble doing this
 via the lookup function and ask for your help. I have uploaded the
 spreadsheet Copy of Actual vs Forecast FY11.xls.

 Any help or advice offered will be appreciated.

 Thank you!

 Steve Weaver

 --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Change / Arrange no. of order of Sheets - Help

2010-12-31 Thread P.VIJAYKUMAR

Dear Rohan,



You can download and install an add-in called Ultimate Add-in which contains
many useful features along with a feature to sort work sheets.


Regards,
VijayKumar

On Fri, Dec 31, 2010 at 11:31 AM, Rohan Young rohan.j...@gmail.com wrote:

 Hi Experts,

 Gud morng  wishing u all a very HAPPY NEW YEAR 2011

 I hv a question, can we change / arrange the order of Sheets in excel.

 e.g. : i hv a file which has many of sheets  i want to take print of all
 sheets with the page nos. but the problem is all the sheets are arranged in
 descending order (from left to right : Sheet 10, Sheet 9, Sheet
 8...) but i want printouts from the sheet 1 with the page no. 1
 on sheet 1, if i give page nos. on these sheets excel will count the page
 no. 1 on sheet 10, how can i arrange or change the order of sheets (if there
 is so many sheets)?

 any ideas/thought/function/command on this please share

 thanks

 ROHAN
 9818247278, 8860567680

  --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ new que - help required for large range of data filteration

2010-12-23 Thread P.VIJAYKUMAR

Hi,

When you use filter excel only arranges the data according to the user
specified criteria whereas the original data remains the same.When you do
 delete entire rows the original data gets effected and gets deleted.If you
want to delete rows given by the filter after filtering select the required
data and press  Alt+;   to select the visible cells only.IF you
delete the entire row after using this option your remaining data will not
be deleted.

You can also use colours to filter the textoruse conditional
formating to format the data accoring to your specified condiatioin and then
use filter for your data for  more effective results.



Regards,
Vijaykumar

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ New Rupee Symbol

2010-12-19 Thread P.VIJAYKUMAR

Dear Kumar,


After installing the font the Rupee Symbol appears only if Rupee Foradian
font is selected and ~ is pressed you can have the rupee symbol.


Regards,
Vijay

On Sat, Dec 18, 2010 at 10:38 AM, C.G.Kumar kumar.bemlmum...@gmail.comwrote:

 Dear All,


 I want to use New Rupee symbol and did the following;

 1. Downloaded the font Rupee.ttf or the new version Rupee_Foradian.ttf
 2. Installed the font. (Copy and paste in Fonts folder in control
 panel).


 But , i am not able to use the symbol in excel.

 Could any one tell me the fallacy.



 Regards,

 C.G.Kumar

  --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ How can i enable all macros when start excel?

2010-11-05 Thread P.VIJAYKUMAR

Hi,


If you are using Excel 2007 ,then go to the Ribbon button ,Then Click the
Excel Options button .You will get a box with all the settings.In that
select Trust Center Settings. again  a new box will appear with Settings for
Active X control and Macro settings etc.Select macro settings..In the
options avail ble Select the last option i.e enable macros. This will enable
the  Macros for all work books.




Regards,
Vijaykumar

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Excel Date format dd/mm/yyyy hh:mm:ss

2010-10-28 Thread P.VIJAYKUMAR

Hi,


Forst Select your dat then go to format in the Home Menu(if your using Excel
2007) or format if you are using older versions.In the format menus dialog
box  you can select date formats as you like.At the last the is Customs
format. If you select that and specify what ever type of format you want(i.e
dd/mm/ hh.mm.ss or anything else).Only in Custom format you can
customize and specify the format you like your text to be in. You can also
use formulas for changing the format  as specified below  by our friend.





Regards,
VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ data cleaning in excel

2010-10-28 Thread P.VIJAYKUMAR

Hi,

You can download an add-in called asUltimate add-in which is available for
Excel @007 and for older versions also(Excel 2000.2003,2005 etc). It
contains a tool called Duplicate remover. There are also mainy other very
useful tool in that add-in which will be very useful to you.But make sure
you download the ass-in which is suitable for old versions.



Regards,
Vijay Kumar

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ manage lengthy database

2010-10-28 Thread P.VIJAYKUMAR

Hi Rakesh,


You can also change gridline colour or give colours to the cells in which
you want to see your Cursor.To change thecoulour of gridline(if you are
using excel 2007) Go to the Excel ribbon Button then go to the Excel option
Button In that go to  that advanced option. In that advanced option go to
the Display options in that in the end you will have chage gridline
Colour.you can select what ever coulour you want excep dark colours because
dark clours Mix withthe cursor  colour and you  will get confused,



Regards,
VijayKumar

On Mon, Oct 25, 2010 at 8:02 PM, Rajesh K R rajeshkainikk...@gmail.comwrote:

 Hi experts

 Any one can help me to manage my problem to work in the lengthy database,
 eg if selected a raw having a lot of field i am mistaken many times to
 identify the related name field. pls find the attachment regarding the
 problem  help me to find a solution.

 Expecting your valuable advise

 Regards

 Rajesh

 --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ vba to notepad

2010-10-18 Thread P.VIJAYKUMAR

Dear krishna,

It is possible to copy the contents of Excel to note pad.But, the only
problem is the pasted content will not maintain the same format as in Excel.


Regards,
Vijaykumar

On Mon, Oct 18, 2010 at 12:47 AM, Krishna krishnaja...@gmail.com wrote:

 How can we copy the contents from excel to notepad. For instance the
 range of cells A1:B5 to notepad?

 --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ vba to notepad

2010-10-18 Thread P.VIJAYKUMAR

Dear  Krishna,

I mean we can copy the range of cells A1:B5 from excel to note pad. But , it
is very difficult to copy the whole workbook to notepad.


Regards,
Vijaykumar

On Mon, Oct 18, 2010 at 12:47 AM, Krishna krishnaja...@gmail.com wrote:

 How can we copy the contents from excel to notepad. For instance the
 range of cells A1:B5 to notepad?

 --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Time in Decimal format

2010-10-15 Thread P.VIJAYKUMAR

Dear Vijay

After slecting your required data go to Format menu in that there are a
number of formats.In the last there is Custom Format,By selecting that  you
can specify your own format.In that specify the format you want to have your
data,Your data will be changed to the format you wanted.


Regards,
Vijaykumar

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Quick help needed to Find duplicate by formula

2010-10-15 Thread P.VIJAYKUMAR

Dear Ansari,

You can use Data Validation for the duplicates,



Regards,
Vijay

On Wed, Oct 13, 2010 at 8:43 PM, vinod rao vinod.ma...@gmail.com wrote:

 HI

 I have multipal duplicate numbers and excluding one for others it should
 say duplicate. how do i enter formula in 2003/2007

 Thanks
 Vinod

 --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Games in excel

2010-10-14 Thread P.VIJAYKUMAR

Dear Vijay,

How to Embed Flash Game in Excel Spreadsheet
Intructions
 Things You'll Need:

   - Microsoft Excel(this how-to is based on the 2007 version)
   - A downloaded flash game
   - internet connection


   1.  Download free flash game online or use one you already have
   2.  Open Excel and go to the top left option button. Choose excel options
   in the bottom right hand corner.
   3.  Click show developer tab in the ribbon.
   4.  Go to the developers tab and click insert. Choose insert shockwave
   object.
   5.  Create an area on the spreadsheet as large as the window you are
   working on.
   6.  Right click the area you just created and choose properties.

   1. Make the embed movies option True
   2. Find the file you want on your
computerhttp://www.ehow.com/computers/ and
   paste the path into the movie option. (exit properties)
   7.  Click design mode and you now have an active game.
   8.  Right click the game area on the screen and choose play.
   9.  Save normally and send it to yourself at work. Have fun.




Regards,
Vijaykumar

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Add-In

2010-10-07 Thread P.VIJAYKUMAR

Dear Friend,

Add-in in Excel is any tool (other than the normal available) ones which
does a specified activity i.e  detecting and eliminating duplicates,finding
difference between dates etc, .it is a sfecfically written Macro or VBA
which performs specific tasks in an easy manner. you can get Excel -add-ins
on www.ozgrid.com.www.office-excel.com,www.ablebits.com,etc. Add-ins are
also available for other components of MS OFFICE.




Regards,.
VijayKumar.

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ DATA VALIDATION AND HYPERLINK

2010-10-07 Thread P.VIJAYKUMAR

Dear Arif,

No file is attached,

Regards,
Vijaykumar

On Thu, Oct 7, 2010 at 5:34 PM, arif massani arifmass...@gmail.com wrote:

 THERE IS NO FILE ATTACHED

 On Thu, Oct 7, 2010 at 5:08 PM, santanu_ca santanu...@gmail.com wrote:

 HI
 I HYPERLINKES A SHEET WITH ANOTHER SHEET IN SAME WORK BOOK BUT IT
 DOES'NT WORKS. FILE ATTACHED.
 SANTANU

 --

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

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

 
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




 --
 Arif Mansoorali Massani
 Mali Street,
 Jadeja No Delo,
 Sanghediya Bazar,
 Bhavnagar
 State Gujarat, India

 M. +91-9913382099

 --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ write to end of page to foot total

2010-10-06 Thread P.VIJAYKUMAR

Hello,

You can link the total of the first page to the following page by keeping =
and selecting the previous page total to next page opening balance total.
this is Explained by the attached sheet.

Regards,
VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts


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

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit ,

There is also an add-in called Ultimate add-in which contains a lot of other
features like finding and removing duplicates, transposing cell contents
between two cells etc,  along with text to numbers conversion  feature.
But,unfortunately some features of them are not working.But it is quite an
useful add-in. Anyway thank you very much for your concern.


Regards,


P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit,

To use the add-in select the number you want to convert into text.then go to
the add-ins in the Menu bar and select the text to numbers button.
Automaticaaly the number you selected turns into text. But, you dont't have
the original number.If you want to have the number and also the converted
text copy the number into another cell and then change it into text. In this
way you can have both the number and also you converted text.Hope this
clarifies your doubt.


Regards,
Vijaykumar

On Tue, Oct 5, 2010 at 11:38 AM, Ankit Agrawal
ankit.agrawal...@gmail.comwrote:

 Thank you sir for deteil knowledge but again same problem *how we can use
 add-in? plz tell me *

 **
 Thnanks  Regards

 Ankit


 On Tue, Oct 5, 2010 at 8:30 AM, P.VIJAYKUMAR vijay.4...@gmail.com wrote:

 Dear Ankit,

 There is no Direct formula to convert numbers into text.But there are some
 add-ins available in the websites. just google for text to numbers converter
 in excel add-in.
 Once you download the add-in to install the add-in  to excel go to the
 excel ribbon Button, the from there open excel options ,then select add-in
 from the avialble options. Excel will then display the add-ins which are
 already installed . It will also have a go button in the bottom for
 installing others in that it will show some available not installed
 add-ins,you can also install them along with our add-in..After clicking go
 button  then click the browse button then select the file which you
 downloaded to any disk or any place in your computer.Then click OK.Your
 add-in is installed.Once installed the file which is selected for
 installation should not be moved from the place it is downloaded.To many
 movements make the add-in not working.So when downloading only make sure
 that the file is saved in a place in which is is not disturbed further.Once
 installed you add-in shall work in every workbook. Make sure that an addin
 button is added to the Menu Bar.Hope this clarified your problem


 Regards,
 VijayKumar

 --

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

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

 
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts


  --

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

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

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 









P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Help in sending the salary slip

Hello Ankit,

I did not understand you question properly. Why do use mail merge .You can
create  single sheet work book as you salary ship and give password to it
and also mail the password to the concerned person through a text file
attached along with the salary sheet.

Regards,
P.VIJAY KUMAR

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Numer To Text

Dear Ankit,

Here is a code that might help you. It is didvided into prts depending upon
your requirement copy and pate the required part in Visual basic.



'' Main Function *'
Function SpellNumbers(ByVal MyNumber)
Dim Rupees, Paise, Temp
Dim DecimalPlace, Count
ReDim Place(9) As String
Place(2) =  Thousand 
Place(3) =  Lac 
Place(4) =  Crore 
Place(5) =  Arab  ' String representation of amount
MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none
DecimalPlace = InStr(MyNumber, .)
'Convert Paise and set MyNumber to Rupee amount
If DecimalPlace  0 Then
Paise = GetTens(Left(Mid(MyNumber, DecimalPlace + 1)  00, 2))
MyNumber = Trim(Left(MyNumber, DecimalPlace - 1))
End If
Count = 1
Do While MyNumber  
If Count = 1 Then Temp = GetHundreds(Right(MyNumber, 3))
If Count  1 Then Temp = GetHundreds(Right(MyNumber, 2))
If Temp   Then Rupees = Temp  Place(Count)  Rupees
If Count = 1 And Len(MyNumber)  3 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 3)
Else
If Count  1 And Len(MyNumber)  2 Then
MyNumber = Left(MyNumber, Len(MyNumber) - 2)
Else
MyNumber = 
End If
End If
Count = Count + 1
Loop
Select Case Rupees
Case 
Rupees = No Rupees
Case One
Rupees = One Rupee
Case Else
Rupees = Rupees   Rupees
End Select
Select Case Paise
Case 
Paise = 
Case One
Paise =  and One Paisa
Case Else
Paise =  and   Paise   Paise
End Select
SpellNumbers = Rupees  Paise
End Function
'***
' Converts a number from 100-999 into text *
'***
Function GetHundreds(ByVal MyNumber)
Dim Result As String
If Val(MyNumber) = 0 Then Exit Function
MyNumber = Right(000  MyNumber, 3) 'Convert the hundreds place
If Mid(MyNumber, 1, 1)  0 Then
Result = GetDigit(Mid(MyNumber, 1, 1))   Hundred 
End If
'Convert the tens and ones place
If Mid(MyNumber, 2, 1)  0 Then
Result = Result  GetTens(Mid(MyNumber, 2))
Else
Result = Result  GetDigit(Mid(MyNumber, 3))
End If
GetHundreds = Result
End Function
'*
' Converts a number from 10 to 99 into text. *
'*
Function GetTens(TensText)
Dim Result As String
Result =  'null out the temporary function value
If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19
Select Case Val(TensText)
Case 10: Result = Ten
Case 11: Result = Eleven
Case 12: Result = Twelve
Case 13: Result = Thirteen
Case 14: Result = Fourteen
Case 15: Result = Fifteen
Case 16: Result = Sixteen
Case 17: Result = Seventeen
Case 18: Result = Eighteen
Case 19: Result = Nineteen
Case Else
End Select
Else ' If value between 20-99
Select Case Val(Left(TensText, 1))
Case 2: Result = Twenty 
Case 3: Result = Thirty 
Case 4: Result = Forty 
Case 5: Result = Fifty 
Case 6: Result = Sixty 
Case 7: Result = Seventy 
Case 8: Result = Eighty 
Case 9: Result = Ninety 
Case Else
End Select
Result = Result  GetDigit _
(Right(TensText, 1)) 'Retrieve ones place
End If
GetTens = Result
End Function
'***
' Converts a number from 1 to 9 into text. *
'***
Function GetDigit(Digit)
Select Case Val(Digit)
Case 1: GetDigit = One
Case 2: GetDigit = Two
Case 3: GetDigit = Three
Case 4: GetDigit = Four
Case 5: GetDigit = Five
Case 6: GetDigit = Six
Case 7: GetDigit = Seven
Case 8: GetDigit = Eight
Case 9: GetDigit = Nine
Case Else: GetDigit = 
End Select
End Function

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


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Numer To Text