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

2011-08-16 Thread NOORAIN ANSARI 
Dear Amit,

Please find full fath of  Personal Macro File..

1. C:\Program Files\Microsoft Office\Office12\XLSTART
2.  Press Alt+F11, Go to File-Import Option to Transfer Macro file.



Thanks  regards,
Noorain Ansari
On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU) amit.de...@merucabs.com
 wrote:

  Dear Masters,

 ** **

 I am currently using a temporary laptop  in few days will receive another
 one. I have created some Macros  saved them in personal macro workbook.**
 **

 ** **

 My queries are;

 **1)  **Where to find them on my system,

 **2)  **How to transfer them to new system.

 ** **

 Best Regards,

 Amit Desai

 --
 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --

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

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

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


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


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

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

2011-08-16 Thread Venkat CV 
*Hi Amit,*
*
*
*See the below path*
*
*
*C:\Documents and Settings\vcc7328\Application
Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB*
*
*
*Login ID:vcc7328*
*
*
*For 2007 2010...*


*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 16, 2011 at 11:33 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:

 Dear Amit,

 Please find full fath of  Personal Macro File..

 1. C:\Program Files\Microsoft Office\Office12\XLSTART
 2.  Press Alt+F11, Go to File-Import Option to Transfer Macro file.



 Thanks  regards,
 Noorain Ansari
 On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU) 
 amit.de...@merucabs.com wrote:

  Dear Masters,

 ** **

 I am currently using a temporary laptop  in few days will receive another
 one. I have created some Macros  saved them in personal macro workbook.*
 ***

 ** **

 My queries are;

 **1)  **Where to find them on my system,

 **2)  **How to transfer them to new system.

 ** **

 Best Regards,

 Amit Desai

 --
 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --

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

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

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




  --

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

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

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




-- 
*
*
*
*

-- 
--
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$$ Export of Personal Macro Book

2011-08-16 Thread Amit Desai (MERU) 
This one helped thanks...

Best Regards,
Amit Desai


From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Venkat CV
Sent: Tuesday, August 16, 2011 11:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Export of Personal Macro Book

Hi Amit,

See the below path

C:\Documents and Settings\vcc7328\Application 
Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB

Login ID:vcc7328

For 2007 2010...


Best Regards,
Venkat
Chennai

On Tue, Aug 16, 2011 at 11:33 AM, NOORAIN ANSARI 
noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote:
Dear Amit,

Please find full fath of  Personal Macro File..

1. C:\Program Files\Microsoft Office\Office12\XLSTART
2.  Press Alt+F11, Go to File-Import Option to Transfer Macro file.



Thanks  regards,
Noorain Ansari
On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU) 
amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote:
Dear Masters,

I am currently using a temporary laptop  in few days will receive another one. 
I have created some Macros  saved them in personal macro workbook.

My queries are;

1)  Where to find them on my system,

2)  How to transfer them to new system.

Best Regards,
Amit Desai


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.comhttp://www.excel-macros.blogspot.com/
4. Learn VBA Macros at 
http://www.quickvba.blogspot.comhttp://www.quickvba.blogspot.com/
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.comhttp://exceldailytip.blogspot.com/

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


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-16 Thread B Sharma 
Congrats to my lovely friend.. Hey Rajan... carry on your
social work dude.

On Aug 5, 11:08 pm, Manish pansari.man...@gmail.com wrote:
 CongratulationsRajan... :)

 -
 Manish

 On Aug 5, 9:37 pm, neil johnson neil.jh...@googlemail.com wrote:







  CongratulationRajan.

  On Fri, Aug 5, 2011 at 8:57 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com

   wrote:
   CongratulationsRajan...!

   Regards, Haseeb

   --

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

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

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

  - Show quoted text -

-- 
--
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$$ How to use Multiple criteria in DSUM function...

2011-08-16 Thread B Sharma 
Hello to Excel Experts and other users of this group.

I've been looking everywhere   about how to put several criteria in
different cell ranges in:

DSUM(database, field, criteria).

I have a very large database and using Dsum and I am using different
different criteria  in different different columns.

Normally you put for example A1:G2 and everything works fine. Now the
problem is that I have quite many criterias that are common for
several DSUM() and I would like to split the criterias into for
example A1:D2 and G1:G2.

I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays
with refernces..),
DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.

What can I do?

If anyone has an idea please let me know !!

B. Sharma

-- 
--
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$$ Export of Personal Macro Book

2011-08-16 Thread Venkat CV 
Welcome

On Tue, Aug 16, 2011 at 11:55 AM, Amit Desai (MERU) amit.de...@merucabs.com
 wrote:

  This one helped thanks…

 ** **

 Best Regards,

 Amit Desai

 ** **

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
 *Sent:* Tuesday, August 16, 2011 11:41 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Export of Personal Macro Book

 ** **

 *Hi Amit,*

 ** **

 *See the below path*

 ** **

 *C:\Documents and Settings\vcc7328\Application
 Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB*

 ** **

 *Login ID:vcc7328*

 ** **

 *For 2007 2010...*

 ** **

 ** **

 *Best Regards,*

 *Venkat *

 *Chennai*

 ** **

 On Tue, Aug 16, 2011 at 11:33 AM, NOORAIN ANSARI noorain.ans...@gmail.com
 wrote:

 Dear Amit,

  

 Please find full fath of  Personal Macro File..

  

 1. C:\Program Files\Microsoft Office\Office12\XLSTART

 2.  Press Alt+F11, Go to File-Import Option to Transfer Macro file.
  

  

  

 Thanks  regards,

 Noorain Ansari

 On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU) 
 amit.de...@merucabs.com wrote:

 Dear Masters,

  

 I am currently using a temporary laptop  in few days will receive another
 one. I have created some Macros  saved them in personal macro workbook.**
 **

  

 My queries are;

 1)  Where to find them on my system,

 2)  How to transfer them to new system.

  

 Best Regards,

 Amit Desai

 ** **
  --

 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --

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

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

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



 

 --

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

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

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



 

 ** **

 -- 

 ** **

 ** **

 ** **

 ** **

 --

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

 --
 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should

Re: $$Excel-Macros$$ Notes : Help

2011-08-16 Thread ashish koul 
hi chandar

 i tried it its working fine  also ur code is password protected .can u
unlock it and send it again

On Tue, Aug 16, 2011 at 12:43 PM, Chandra Shekar 
chandrashekarb@gmail.com wrote:

 Hi Ashish,

 Please find attached file and kindly do the needful. Thanks in advance.

 On Tue, Aug 16, 2011 at 5:40 AM, ashish koul koul.ash...@gmail.comwrote:

 can you attach your file



 On Mon, Aug 15, 2011 at 5:35 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Hi,

 I am getting attached error while running the macro. Please let me know
 whats the error in the below code.

  *MailDoc.Save True, True, False*

 Regards,

 Chandra Shekar B
   On Mon, Aug 15, 2011 at 11:43 AM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Hi Asish,
 Thank u for the help again I am getting error in the below code. Please
 let me know whats the problem in the below code.

 Thanks in advance.
 **
 *MailDoc.Save True, True, False
 *
   On Mon, Aug 15, 2011 at 9:53 AM, ashish koul 
 koul.ash...@gmail.comwrote:

 dont use .copy  in set statement


 On Fri, Aug 12, 2011 at 3:43 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Hello Ashish,

 I got solution for this issue but I am getting one more error in code
 as type mismatch


 *Set rnbody1 = Sheets(Details).UsedRange.Copy
 rnbody1.Copy

 *
   On Fri, Aug 12, 2011 at 9:12 AM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Hi Ashsh,

 I used ur code but getting error in below lines. I think I need to
 enable some reference. Please let me know about this.

 *Set Data = New DataObject
 Data.GetFromClipboard
 *
 Thanks,

 Chandra Shekar B
   On Fri, Aug 12, 2011 at 8:21 AM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Thanks Ashish I will check it out. :-)


 On Fri, Aug 12, 2011 at 4:31 AM, ashish koul koul.ash...@gmail.com
  wrote:

 try these


 On Wed, Aug 10, 2011 at 6:10 PM, Chandra Shekar 
 chandrashekarb@gmail.com wrote:

 Hi,

 In below code some times I could able to send attachments but some
 times its not taking attachment at all. Please let me know whats is 
 the
 problem in the below code.

 Sub sendmail()
 '
 Dim UserName As String
 Dim MailDbName As String
 Dim Recipient As Variant
 Dim ccRecipient As String
 Dim Attachment1 As String
 Dim Maildb As Object
 Dim MailDoc As Object
 Dim AttachME As Object
 Dim AttachME2 As Object
 Dim AttachME3 As Object
 Dim AttachME4 As Object
 Dim AttachME5 As Object
 Dim Session As Object
 Dim EmbedObj1 As Object
 Dim EmbedObj2 As Object
 Dim EmbedObj3 As Object
 Dim EmbedObj4 As Object
 Dim EmbedObj5 As Object
 Dim stSignature As String
 With Application
 .ScreenUpdating = False
 .DisplayAlerts = False
 ' Open and locate current LOTUS NOTES User
 Set Session = CreateObject(Notes.NotesSession)
 UserName = Session.UserName
 MailDbName = Left$(UserName, 1)  Right$(UserName, (Len(UserName)
 - InStr(1, UserName,  )))  .nsf
 Set Maildb = Session.GetDatabase(, MailDbName)
 If Maildb.IsOpen = True Then
 Else
 Maildb.OPENMAIL
 End If
 ' Create New Mail and Address Title Handlers
 Set MailDoc = Maildb.CREATEDOCUMENT
 MailDoc.Form = Memo
 stSignature =
 Maildb.GetProfileDocument(CalendarProfile).GetItemValue(Signature)(0)
 ' Select range of e-mail addresses
 Recipient = notes_id
 MailDoc.SendTo = Recipient
 MailDoc.Subject = Test Mail 
 MailDoc.Body = Hi,  vbCrLf  vbCrLf  Please find attached
 schedule for the day   vbCrLf  vbCrLf  Regards  vbCrLf  
 vbCrLf 
 Chandru
 ' Select Workbook to Attach to E-Mail
 MailDoc.SaveMessageOnSend = True
 Attachment1 = C:\temp.bmp ' Required File Name
 If Attachment1   Then
 On Error Resume Next
 Set AttachME = MailDoc.CREATERICHTEXTITEM(Attachment1)
 Set EmbedObj1 = AttachME.EmbedObject(1454, , Attachment1,
 Attachment1)
 MailDoc.CREATERICHTEXTITEM (Attachment1)
 On Error Resume Next
 End If
 MailDoc.PostedDate = Now()
 On Error GoTo errorhandler1
 MailDoc.SEND 0, Recipient
 Set Maildb = Nothing
 Set MailDoc = Nothing
 Set AttachME = Nothing
 Set AttachME2 = Nothing
 Set AttachME3 = Nothing
 Set AttachME4 = Nothing
 Set AttachME5 = Nothing
 Set Session = Nothing
 Set EmbedObj1 = Nothing
 Set EmbedObj2 = Nothing
 Set EmbedObj3 = Nothing
 Set EmbedObj4 = Nothing
 Set EmbedObj5 = Nothing
 .ScreenUpdating = True
 .DisplayAlerts = True
 Exit Sub
 End With
 errorhandler1:
 MsgBox Err.Description
 Set Maildb = Nothing
 Set MailDoc = Nothing
 Set AttachME = Nothing
 Set AttachME2 = Nothing
 Set AttachME3 = Nothing
 Set AttachME4 = Nothing
 Set AttachME5 = Nothing
 Set Session = Nothing
 Set EmbedObj1 = Nothing
 Set EmbedObj2 = Nothing
 Set EmbedObj3 = Nothing
 Set EmbedObj4 = Nothing
 Set EmbedObj5 = Nothing
 End Sub

 --

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

Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

2011-08-16 Thread Venkat CV 
*Hi Sharma,*
*
*
*See if Helps*
*
*
*http://www.mrexcel.com/forum/showthread.php?t=58539*http://www.mrexcel.com/forum/showthread.php?t=58539

On Tue, Aug 16, 2011 at 12:53 PM, B Sharma sharma@gmail.com wrote:

 Hello to Excel Experts and other users of this group.

 I've been looking everywhere   about how to put several criteria in
 different cell ranges in:

 DSUM(database, field, criteria).

 I have a very large database and using Dsum and I am using different
 different criteria  in different different columns.

 Normally you put for example A1:G2 and everything works fine. Now the
 problem is that I have quite many criterias that are common for
 several DSUM() and I would like to split the criterias into for
 example A1:D2 and G1:G2.

 I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays
 with refernces..),
 DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.

 What can I do?

 If anyone has an idea please let me know !!

 B. Sharma

 --

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




-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

-- 
--
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$$ From Word to Excel

2011-08-16 Thread Shrinivas Shevde 
Dear Daniel
Very very thanks for kind help
There is some problem at following line

For j = 3 To myTable.Columns(i).Cells.Count

Run Time ERROR 5992
Can not access indivsual columns in this collection because the table has
mixed cell width
Please Help

Shrinivas


On Sat, Aug 13, 2011 at 4:10 PM, Daniel dcolarde...@free.fr wrote:

  Test the below macro :

 ** **

 Sub WordToExcel()

 Dim strFolder As String, F As Object, strRootFolder As String

 Dim FSO As Object, SF As Object, WordApp As Object

 Dim WordDoc As Object, Ctr As Long, strFile As String, myTable As
 Object

 Application.ScreenUpdating = False

 Set WordApp = CreateObject(Word.application)

 WordApp.Visible = True

 strRootFolder =
 C:\Users\Daniel\Documents\Donnees\Daniel\mpfe\Shrinivas

 Set FSO = CreateObject(Scripting.FileSystemObject)

 For Each F In FSO.GetFolder(strRootFolder).SubFolders

 For Each SF In F.SubFolders

 strFile = Dir(SF.Path  \*.doc*)

 Do While strFile  

 Ctr = Ctr + 2

 Set WordDoc = WordApp.Documents.Open(SF.Path  \ 
 strFile)

 Set myTable = WordDoc.Tables(1)

 For i = 4 To myTable.Columns.Count

 For j = 1 To myTable.Columns(i).Cells.Count

 ActiveSheet.Cells(Ctr + j, i - 3) =
 myTable.Columns(i).Cells(j)

 Next j

 Next i

 Ctr = Ctr + myTable.Rows.Count + 2

 WordDoc.Close False

 strFile = Dir

 Loop

 Next SF

 Next F

 Application.ScreenUpdating = True

 WordApp.Quit

 Set WordApp = Nothing

 Set FSO = Nothing

 End Sub

 ** **

 HTH

 Daniel

 ** **

 *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
 *De la part de* Shrinivas Shevde
 *Envoyé :* vendredi 12 août 2011 07:27
 *À :* excel-macros@googlegroups.com
 *Objet :* $$Excel-Macros$$ From Word to Excel

 ** **

 Dear All

 I required help from all of u

 Read the Problem

 I have a folder  Let Folder name is AA

 In this folder I have more than 200 folder let us name B,C D,CD,CF
 ,...more than 200

 In each of this folder I have 8 folder which is having comman name Consider
 X,Y,Z ...

 In folder Z there are Word file(may be one or many not more than 6) which
 contain Table 

 I want a macro which can copy paste this tables in the Excel work sheet and
 the name of the folder of the second level

 Example

 1st level -Folder AA

 2 nd Level Folder - CD

 Third Level Folder Z (Sample Word file attached)

 I dont want first 3 column to copy,All the column after 3rd column should
 get copy in Attached file 3 column will get coopied.

  

 If some one is ready to help then it will be great help for me or I will
 required at least 1 month.


 Thanks in advanced
 --
 Shrini

 --

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




-- 
Shrini

-- 
--
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$$ From Word to Excel

2011-08-16 Thread Daniel 
Can you please send the word document which provoked the error (the one
which is opened) ? apparently, there are some merged cells in it.

 

Regards.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shrinivas Shevde
Envoyé : mardi 16 août 2011 10:46
À : excel-macros@googlegroups.com
Objet : Re: $$Excel-Macros$$ From Word to Excel

 

Dear Daniel

Very very thanks for kind help 

There is some problem at following line


For j = 3 To myTable.Columns(i).Cells.Count 

 

Run Time ERROR 5992

Can not access indivsual columns in this collection because the table has
mixed cell width

Please Help

 

Shrinivas

 

 

On Sat, Aug 13, 2011 at 4:10 PM, Daniel dcolarde...@free.fr wrote:

Test the below macro :

 

Sub WordToExcel()

Dim strFolder As String, F As Object, strRootFolder As String

Dim FSO As Object, SF As Object, WordApp As Object

Dim WordDoc As Object, Ctr As Long, strFile As String, myTable As Object

Application.ScreenUpdating = False

Set WordApp = CreateObject(Word.application)

WordApp.Visible = True

strRootFolder =
C:\Users\Daniel\Documents\Donnees\Daniel\mpfe\Shrinivas

Set FSO = CreateObject(Scripting.FileSystemObject)

For Each F In FSO.GetFolder(strRootFolder).SubFolders

For Each SF In F.SubFolders

strFile = Dir(SF.Path  \*.doc*)

Do While strFile  

Ctr = Ctr + 2

Set WordDoc = WordApp.Documents.Open(SF.Path  \ 
strFile)

Set myTable = WordDoc.Tables(1)

For i = 4 To myTable.Columns.Count

For j = 1 To myTable.Columns(i).Cells.Count

ActiveSheet.Cells(Ctr + j, i - 3) =
myTable.Columns(i).Cells(j)

Next j

Next i

Ctr = Ctr + myTable.Rows.Count + 2

WordDoc.Close False

strFile = Dir

Loop

Next SF

Next F

Application.ScreenUpdating = True

WordApp.Quit

Set WordApp = Nothing

Set FSO = Nothing

End Sub

 

HTH

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shrinivas Shevde
Envoyé : vendredi 12 août 2011 07:27
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ From Word to Excel

 

Dear All

I required help from all of u

Read the Problem

I have a folder  Let Folder name is AA

In this folder I have more than 200 folder let us name B,C D,CD,CF
,...more than 200

In each of this folder I have 8 folder which is having comman name Consider
X,Y,Z ...

In folder Z there are Word file(may be one or many not more than 6) which
contain Table 

I want a macro which can copy paste this tables in the Excel work sheet and
the name of the folder of the second level

Example

1st level -Folder AA

2 nd Level Folder - CD

Third Level Folder Z (Sample Word file attached)

I dont want first 3 column to copy,All the column after 3rd column should
get copy in Attached file 3 column will get coopied.

 

If some one is ready to help then it will be great help for me or I will
required at least 1 month.


Thanks in advanced 
-- 
Shrini

-- 

--
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
http://www.excel-macros.blogspot.com/ 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
http://www.quickvba.blogspot.com/ 
5. Excel Tips and Tricks at  http://exceldailytip.blogspot.com/
http://exceldailytip.blogspot.com

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

Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel 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
http://www.excel-macros.blogspot.com/ 
4. Learn VBA Macros at http://www.quickvba.blogspot.com
http://www.quickvba.blogspot.com/ 
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
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




-- 
Shrini

-- 

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

$$Excel-Macros$$ AutoHide

2011-08-16 Thread SAJID MEMON 

Hi all Experts,
 
I have a little doubt but may be challanging.
I have enclosed my file. plz refer this and give me solution.
 
awaiting your reply
 
yours
sajid memon   

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


AutoHide.xls
Description: MS-Excel spreadsheet

RE: $$Excel-Macros$$ Update Data source range converting 0 to -

2011-08-16 Thread Amit Desai (MERU) 
Dear All,

Still waiting a solution for below issue...

I have created several pivot tables  want to update the data source
range for all the pivot tables all together. (We do have option as refresh
all for applying the preset pivot criteria in all pivots.)
Best Regards,
Amit Desai

Assistant Manager, Fleet MIS (Corporate)
Desk No.: 022 40520129
Cell No.: 9867232534

From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
Sent: Thursday, August 11, 2011 4:16 PM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Update Data source range  converting 0 to -

Thanks this one helped me

Can you please also reply on below request;

I have created several pivot tables  want to update the data source
range for all the pivot tables all together. (We do have option as refresh
all for applying the preset pivot criteria in all pivots.)

Best Regards,
Amit Desai

Assistant Manager, Fleet MIS (Corporate)
Desk No.: 022 40520129
Cell No.: 9867232534

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Rajan_Verma
Sent: Thursday, August 11, 2011 3:02 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Update Data source range  converting 0 to -

See if it helps, I use conditional Formatting

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of mrinal saha
Sent: Thursday, August 11, 2011 11:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Update Data source range  converting 0 to -

See the attached file, does it make sense..

regards,
Mrinal Saha
On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) 
amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote:
Dear All,

Please help me on the following;

1) I have created several pivot tables  want to update the data source
range for all the pivot tables all together. (We do have option as refresh
all for applying the preset pivot criteria in all pivots.)
2) I have few work sheets where in I get the data through formula. There may
be many cells where I might get data as 0(zero). I want to make all the
0 as -. But the total of these - I want as 0.

Best Regards,
Amit Desai


Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

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

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


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

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

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


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

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

$$Excel-Macros$$ Fwd: Job

2011-08-16 Thread Venkat CV 
- Original message 
From:Crome Search shailend...@cromesearch.com 
Date: 16 Aug 11 17:04:36
Subject: Urgent Opening with Visteon ( MNC ) for Chennai Location
To:

For Internal Use of Employer (Please don't delete or modify while replying
to this email)Monster Resume ID: 33564079  Personal Folder ID: 10208364
Dear Venkatesan,

Greetings from Crome Search!!

Urgent opening with our client Visteon
(http://www.visteon.com )

Job Title: SQL DBA

Exp Level: 3 to 5 years

Job Location: Chennai

Interview Date: 20th August 2011

Job Responsibilities:

Installation, configuration and upgrading of SQL server software and
related products
Establish and maintain sound backup and recovery policies and procedures
Review and assist development teams with application database design and
implementation Implement and maintain database security (create and maintain
users and roles, assign privileges)
Perform database tuning and performance monitoring
Perform application tuning and performance monitoring
Setup and maintain documentation and standards
Plan growth and changes (capacity planning)
Design and maintain Disaster Recovery solutions for databases
Perform general technical trouble shooting and consultation with
development teams
Interface with Microsoft for technical support
SQL Server Patch Management and Version Control
Evaluate MS SQL Server features and related products

Please revert back with your updated profile and the below details
Current company:
Current CTC:
Expected CTC:
Notice period:

Regards,
Shailendra G
Crome Search
020 6511 5222





-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

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


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

Fwd: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

2011-08-16 Thread vikas gupta 
Dear Sir,
Sir I have a query that by using this macro file I am able to merge
different files into single excel but after merging the data is not under
single column heading, Pls. suggest how can I merge files having similar
column headers in all files, so that I can easily sort data as per my
requirement.

Thanks for the help.

Pankaj Chawla
9911104968
 -Original Message-
From: vikas gupta [mailto:vikas.63...@gmail.com]
Sent: 13 August 2011 18:39
To: pankaj.chawl...@gmail.com
Cc: tech_pankajcha...@rediffmail.com
Subject: Fwd: $$Excel-Macros$$ Workbooks Consolidation Macro

-- Forwarded message --
From: ashish koul koul.ash...@gmail.com
Date: Fri, 22 Jul 2011 05:41:02 +0530
Subject: Re: $$Excel-Macros$$ Workbooks Consolidation Macro
To: excel-macros@googlegroups.com

try  this see if it helps



On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava
anish@gmail.comwrote:

 Harish,

 Did you try it.. ??

 On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava
anish@gmail.comwrote:

 Harish,

 PLease ignore the earlier attachment as I forgot to add *DUPLICATE
CHECK*in that macro.

 Use this attachment.

   On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava anish@gmail.com
  wrote:

 Hi Harsih,

 Since you didnt reply about column headers I assumed that it's the same
 for every file on share drive.

 Please see the attached file with macro.

 You must populate the file path in Sheet2-A1.

 Do let me know if it works fine for you.
 Cheers!!
 Anish
   On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava 
 anish@gmail.com wrote:

 Harish,

 I forgot to ask you one thing.
 The column headers in the file you attached will be constant for all
the
 30-35 files which are there on your sharedrive, right?
 Cheers,
 Anish
   On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma 
 harishsharma...@gmail.com wrote:

 Hi Anish,

 Please find attached the sample file with one row filled.
 And Column C  Column H concatenate should give us unique value so
 if this is repeated then we need to have below requested feature.

 Hope this would be more clear now.

 Thanks
 Harish



 On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote:

 One sample sheet would be helpful to us to see the data structure.

 However, for this *Also identifiy if there is any row duplicated and
 highlight them and paste them into another sheet * There must be any
 particular data field which has to be checked against others in order
to
 find duplicates.

 Macro for consolidation is not a big deal.


 On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma 
 harishsharma...@gmail.com wrote:

 Hi,

 I had a macro file which was able to consolidate small files but now
 I have a requirement to consolidate 30 workbooks saved in a share
drive and
 this data may even cross 66000 row after consolidation. Can someone
help me
 in creating a macro which picks all the file from shared folder and
 consolidates the one specific worksheet in all the workbook.

 This macro should also be capable of deleting any blank row in any
of
 these 30 workbooks so that we donot miss any data if someone by
error has
 missed a couple of row and entered the data in couple of row below.

 30 workbooks in sharedrive
 one specific worksheet from all of these named as Tracker
 Should cover all the blanks and delete them so that no data missed
 Also identifiy if there is any row duplicated and highlight them and
 paste them into another sheet
 If data crosses excel 2003 limit of row it should move to next
 worksheet.

 Hope to get a solution from excel experts.

 --
 Kind Regards,
 Harish Sharma

 --



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




 --
 Kind Regards,
 Harish Sharma

 --

Re: $$Excel-Macros$$ AutoHide

2011-08-16 Thread dguillett1 
Name your shape “LockShape” and use this assigned to a button or another shape 

Sub HideUnhideLockShape()
Shapes(LockShape).Visible = Not _
Shapes(LockShape).Visible
End Sub

From: SAJID MEMON 
Sent: Tuesday, August 16, 2011 5:33 AM
To: Excel Group 
Subject: $$Excel-Macros$$ AutoHide

Hi all Experts,
 
I have a little doubt but may be challanging.
I have enclosed my file. plz refer this and give me solution.
 
awaiting your reply
 
yours
sajid memon

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

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

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

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


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

Re: Fwd: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

2011-08-16 Thread dguillett1 

Your source files should all be structured the same. If not, you will have to 
program. Attach samples 

From: vikas gupta 
Sent: Tuesday, August 16, 2011 6:55 AM
To: excel-macros@googlegroups.com 
Cc: pankaj chawla ; tech_pankajcha...@rediffmail.com 
Subject: Fwd: FW: $$Excel-Macros$$ Workbooks Consolidation Macro


Dear Sir,
Sir I have a query that by using this macro file I am able to merge
different files into single excel but after merging the data is not under
single column heading, Pls. suggest how can I merge files having similar
column headers in all files, so that I can easily sort data as per my
requirement.

Thanks for the help.

Pankaj Chawla
9911104968

-Original Message-
From: vikas gupta [mailto:vikas.63...@gmail.com]
Sent: 13 August 2011 18:39
To: pankaj.chawl...@gmail.com
Cc: tech_pankajcha...@rediffmail.com
Subject: Fwd: $$Excel-Macros$$ Workbooks Consolidation Macro

-- Forwarded message --
From: ashish koul koul.ash...@gmail.com
Date: Fri, 22 Jul 2011 05:41:02 +0530
Subject: Re: $$Excel-Macros$$ Workbooks Consolidation Macro
To: excel-macros@googlegroups.com

try  this see if it helps



On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava
anish@gmail.comwrote:

 Harish,

 Did you try it.. ??

 On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava
anish@gmail.comwrote:

 Harish,

 PLease ignore the earlier attachment as I forgot to add *DUPLICATE
CHECK*in that macro.

 Use this attachment.

   On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava anish@gmail.com
  wrote:

 Hi Harsih,

 Since you didnt reply about column headers I assumed that it's the same
 for every file on share drive.

 Please see the attached file with macro.

 You must populate the file path in Sheet2-A1.

 Do let me know if it works fine for you.
 Cheers!!
 Anish
   On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava 
 anish@gmail.com wrote:

 Harish,

 I forgot to ask you one thing.
 The column headers in the file you attached will be constant for all
the
 30-35 files which are there on your sharedrive, right?
 Cheers,
 Anish
   On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma 
 harishsharma...@gmail.com wrote:

 Hi Anish,

 Please find attached the sample file with one row filled.
 And Column C  Column H concatenate should give us unique value so
 if this is repeated then we need to have below requested feature.

 Hope this would be more clear now.

 Thanks
 Harish



 On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote:

 One sample sheet would be helpful to us to see the data structure.

 However, for this *Also identifiy if there is any row duplicated and
 highlight them and paste them into another sheet * There must be any
 particular data field which has to be checked against others in order
to
 find duplicates.

 Macro for consolidation is not a big deal.


 On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma 
 harishsharma...@gmail.com wrote:

 Hi,

 I had a macro file which was able to consolidate small files but now
 I have a requirement to consolidate 30 workbooks saved in a share
drive and
 this data may even cross 66000 row after consolidation. Can someone
help me
 in creating a macro which picks all the file from shared folder and
 consolidates the one specific worksheet in all the workbook.

 This macro should also be capable of deleting any blank row in any
of
 these 30 workbooks so that we donot miss any data if someone by
error has
 missed a couple of row and entered the data in couple of row below.

 30 workbooks in sharedrive
 one specific worksheet from all of these named as Tracker
 Should cover all the blanks and delete them so that no data missed
 Also identifiy if there is any row duplicated and highlight them and
 paste them into another sheet
 If data crosses excel 2003 limit of row it should move to next
 worksheet.

 Hope to get a solution from excel experts.

 --
 Kind Regards,
 Harish Sharma

 --



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

$$Excel-Macros$$ Fwd: Job

2011-08-16 Thread Venkat CV 
- Original message 
From:Ma Foi Management Consultants Ltd. paramita.b...@mafoirandstad.com
Date: 16 Aug 11 17:41:48
Subject: WFM-opening at kolkata
To:

For Internal Use of Employer (Please don't delete or modify while replying
to this email)Monster Resume ID: 33564079  Personal Folder ID: 10208723
Dear Venkatesan,

Opening at Ericsson Kolkata

Skill-WFM
Preferred exp in click software.
Others can also apply.

Pls send me your cv at paramita.b...@mafoirandstad.com
with foll details must
name-
total exp-
relevent exp in wfm-
exp in click software(if any)-
current ctc-
exp ctc-
notice period-
current designation-
current company-
current location-
willing to work with Ericsson at Kolkata-

rgds,
Paramita
mafoi-kol

0340008042



This mail has been sent by one of the employers (Employer name: Ma Foi
Management Consultants Ltd.) accessing the services of monsterindia.com and
not by Monster. Monster is committed to protecting the privacy of our users
and our “Terms of Use” prohibits any misuse including spamming. If you
consider the contents of the mails inappropriate or as spam, please forward
this mail to spam@monsterindia.comDouble your chances of getting the right
job by keeping your resume updated.
Update Resume now



-- 
*Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

-- 
--
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: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

2011-08-16 Thread Excel VBASQL 
I can help email me at excelvba...@gmail.com

On Tue, Aug 16, 2011 at 6:55 AM, vikas gupta vikas.63...@gmail.com wrote:


 Dear Sir,
 Sir I have a query that by using this macro file I am able to merge
 different files into single excel but after merging the data is not under
 single column heading, Pls. suggest how can I merge files having similar
 column headers in all files, so that I can easily sort data as per my
 requirement.

 Thanks for the help.

 Pankaj Chawla
 9911104968
  -Original Message-
 From: vikas gupta [mailto:vikas.63...@gmail.com]
 Sent: 13 August 2011 18:39
 To: pankaj.chawl...@gmail.com
 Cc: tech_pankajcha...@rediffmail.com
 Subject: Fwd: $$Excel-Macros$$ Workbooks Consolidation Macro

 -- Forwarded message --
 From: ashish koul koul.ash...@gmail.com
 Date: Fri, 22 Jul 2011 05:41:02 +0530
 Subject: Re: $$Excel-Macros$$ Workbooks Consolidation Macro
 To: excel-macros@googlegroups.com

 try  this see if it helps



 On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava
 anish@gmail.comwrote:

  Harish,
 
  Did you try it.. ??
 
  On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava
 anish@gmail.comwrote:
 
  Harish,
 
  PLease ignore the earlier attachment as I forgot to add *DUPLICATE
 CHECK*in that macro.
 
  Use this attachment.
 
On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava 
 anish@gmail.com
   wrote:
 
  Hi Harsih,
 
  Since you didnt reply about column headers I assumed that it's the same
  for every file on share drive.
 
  Please see the attached file with macro.
 
  You must populate the file path in Sheet2-A1.
 
  Do let me know if it works fine for you.
  Cheers!!
  Anish
On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava 
  anish@gmail.com wrote:
 
  Harish,
 
  I forgot to ask you one thing.
  The column headers in the file you attached will be constant for all
 the
  30-35 files which are there on your sharedrive, right?
  Cheers,
  Anish
On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma 
  harishsharma...@gmail.com wrote:
 
  Hi Anish,
 
  Please find attached the sample file with one row filled.
  And Column C  Column H concatenate should give us unique value
 so
  if this is repeated then we need to have below requested feature.
 
  Hope this would be more clear now.
 
  Thanks
  Harish
 
 
 
  On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com
 wrote:
 
  One sample sheet would be helpful to us to see the data structure.
 
  However, for this *Also identifiy if there is any row duplicated
 and
  highlight them and paste them into another sheet * There must be
 any
  particular data field which has to be checked against others in
 order
 to
  find duplicates.
 
  Macro for consolidation is not a big deal.
 
 
  On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma 
  harishsharma...@gmail.com wrote:
 
  Hi,
 
  I had a macro file which was able to consolidate small files but
 now
  I have a requirement to consolidate 30 workbooks saved in a share
 drive and
  this data may even cross 66000 row after consolidation. Can someone
 help me
  in creating a macro which picks all the file from shared folder and
  consolidates the one specific worksheet in all the workbook.
 
  This macro should also be capable of deleting any blank row in any
 of
  these 30 workbooks so that we donot miss any data if someone by
 error has
  missed a couple of row and entered the data in couple of row below.
 
  30 workbooks in sharedrive
  one specific worksheet from all of these named as Tracker
  Should cover all the blanks and delete them so that no data missed
  Also identifiy if there is any row duplicated and highlight them
 and
  paste them into another sheet
  If data crosses excel 2003 limit of row it should move to next
  worksheet.
 
  Hope to get a solution from excel experts.
 
  --
  Kind Regards,
  Harish Sharma
 
  --
 
 

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

Re: $$Excel-Macros$$ Update Data source range converting 0 to -

2011-08-16 Thread Excel VBASQL 
I can do this email me at excelvba...@gmail.com

On Tue, Aug 16, 2011 at 6:00 AM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:

  Dear All,

 ** **

 Still waiting a solution for below issue…

 ** **

 I have created several pivot tables  want to update the data source
 range for all the pivot tables all together. (We do have option as refresh
 all for applying the preset pivot criteria in all pivots.)

 Best Regards,

 Amit Desai

 ** **

 Assistant Manager, Fleet MIS (Corporate)

 Desk No.: 022 40520129

 Cell No.: 9867232534

 ** **

 *From:* Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
 *Sent:* Thursday, August 11, 2011 4:16 PM
 *To:* 'excel-macros@googlegroups.com'
 *Subject:* RE: $$Excel-Macros$$ Update Data source range  converting 0
 to -

 ** **

 Thanks this one helped me….

 ** **

 Can you please also reply on below request;

 ** **

 I have created several pivot tables  want to update the data source
 range for all the pivot tables all together. (We do have option as refresh
 all for applying the preset pivot criteria in all pivots.)

 ** **

 Best Regards,

 Amit Desai

 ** **

 Assistant Manager, Fleet MIS (Corporate)

 Desk No.: 022 40520129

 Cell No.: 9867232534

 ** **

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Rajan_Verma
 *Sent:* Thursday, August 11, 2011 3:02 PM
 *To:* excel-macros@googlegroups.com
 *Subject:* RE: $$Excel-Macros$$ Update Data source range  converting 0
 to -

 ** **

 *See if it helps, I use conditional Formatting *

 * *

 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *mrinal saha
 *Sent:* Thursday, August 11, 2011 11:46 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* Re: $$Excel-Macros$$ Update Data source range  converting 0
 to -

 ** **

 See the attached file, does it make sense..

  

 regards,

 Mrinal Saha

 On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) 
 amit.de...@merucabs.com wrote:

 Dear All,

 Please help me on the following;

 1) I have created several pivot tables  want to update the data source
 range for all the pivot tables all together. (We do have option as refresh
 all for applying the preset pivot criteria in all pivots.)
 2) I have few work sheets where in I get the data through formula. There
 may
 be many cells where I might get data as 0(zero). I want to make all the
 0 as -. But the total of these - I want as 0.

 Best Regards,
 Amit Desai


 Disclaimer: This message and its attachments contain confidential
 information and may also contain legally privileged information. This
 message is intended solely for the named addressee. If you are not the
 addressee indicated in this message (or authorized to receive for
 addressee), you may not copy or deliver any part of this message or its
 attachments to anyone or use any part of this message or its attachments.
 Rather, you should permanently delete this message and its attachments (and
 all copies) from your system and kindly notify the sender by reply e-mail.
 Any content of this message and its attachments that does not relate to the
 official business of Meru Cab Company Pvt. Ltd. must be taken not to have
 been sent or endorsed by any of them. Email communications are not private
 and no warranty is made that e-mail communications are timely, secure or
 free from computer virus or other defect.

 --

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

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

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

 ** **

 --

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

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

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

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our

$$Excel-Macros$$ Table - extract some data

2011-08-16 Thread x x 
Folks, please give me a hint about table attached. I'd like to find a way to 
extract exact and wished value from table but of course regarding 
pre-existing required conditions.

For instance, if someone choose diameter 40, left diameter 10 and delta 60 
excel should get in some empty cell the value 40,2. Like crossword game. How 
to do it?
I've tried with filters and some if, vlookup functions but it seems to be to 
complicated for my excel level of knowledge. Teach me. Many thanks.

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


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

Re: $$Excel-Macros$$ Table - extract some data

2011-08-16 Thread dguillett1 
I would restructure your table to make it simpler but this works.

From: x x 
Sent: Tuesday, August 16, 2011 7:31 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Table - extract some data

Folks, please give me a hint about table attached. I'd like to find a way to 
extract exact and wished value from table but of course regarding pre-existing 
required conditions. 

For instance, if someone choose diameter 40, left diameter 10 and delta 60 
excel should get in some empty cell the value 40,2. Like crossword game. How to 
do it?
I've tried with filters and some if, vlookup functions but it seems to be to 
complicated for my excel level of knowledge. Teach me. Many thanks.
-- 
--
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


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

$$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-16 Thread ICWAI Help 
Please provide me UDF functino for below requirement

example:)

if the cell value is 4 then including active cell next 4 cell in a row
should be higleted with color.
ex
if
a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.

Thansk,
Rakesh.

-- 
--
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$$ UDF Function for conditoin formetting

2011-08-16 Thread Excel VBASQL 
I can do this email me at excelvba...@gmail.com

On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help icwai.answ...@gmail.comwrote:

 Please provide me UDF functino for below requirement

 example:)

 if the cell value is 4 then including active cell next 4 cell in a row
 should be higleted with color.
 ex
 if
 a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.

 Thansk,
 Rakesh.

 --

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

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

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


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


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

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-16 Thread dguillett1 
I did this VERY recently in another formum. Was it you?
Right click sheet tabview codeinsert this

Private Sub Worksheet_Change(ByVal Target As Range)
Dim tr As Long
tr = Target.Row
Rows(tr).Borders(xlEdgeBottom).LineStyle = xlNone
If Target.Column  1 Or Not IsNumeric(Target) Or _
Len(Application.Trim(Target))  1 Then Exit Sub
Range(Cells(tr, 2), Cells(tr, Target + 1)) _
.Borders(xlEdgeBottom).LineStyle = xlContinuous
End Sub

From: ICWAI Help 
Sent: Tuesday, August 16, 2011 11:02 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ UDF Function for conditoin formetting

Please provide me UDF functino for below requirement 

example:)

if the cell value is 4 then including active cell next 4 cell in a row should 
be higleted with color.
ex
if 
a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.

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

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

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

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


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

Re: $$Excel-Macros$$ re: required phone book in excel

2011-08-16 Thread XLS S 
Hey Harsh,

Please find the below link

http://office.microsoft.com/en-us/templates/CT010144671.aspx

On Tue, Aug 16, 2011 at 1:37 PM, harsh shah harshsha...@gmail.com wrote:
 dear all,

 anybody having phone book software in excel ??
 i.e. name contact details phone numbers up to 3 or 4 numbers
 and important thing one has search window which reflects results based on
 each character we type.

 i.e. if name searching is harsh
 when i type h--it shows all contacts starting from h
 then ha -only contacts starting with ha..and so on...

 -harsh.

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

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

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




-- 
.

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


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

Re: $$Excel-Macros$$ AutoHide

2011-08-16 Thread XLS S 
Very good venkat..

On Tue, Aug 16, 2011 at 5:03 PM, Venkat CV venkat1@gmail.com wrote:
 Hi Sajid,

 Look AttachedSee if it helps...

 Best Regards,
 Venkat
 Chennai
 On Tue, Aug 16, 2011 at 4:03 PM, SAJID MEMON sajidwi...@hotmail.com wrote:

 Hi all Experts,

 I have a little doubt but may be challanging.
 I have enclosed my file. plz refer this and give me solution.

 awaiting your reply

 yours
 sajid memon

 --

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

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

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



 --




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

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

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




-- 
.

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


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

Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro

2011-08-16 Thread XLS S 
hey Vikas,

try to use batch file
open notepad...paste below code then save as
copy.bat

Copy  *Comman file name*.xls output.xls
exit

On Tue, Aug 16, 2011 at 5:25 PM, vikas gupta vikas.63...@gmail.com wrote:

 Dear Sir,
 Sir I have a query that by using this macro file I am able to merge
 different files into single excel but after merging the data is not under
 single column heading, Pls. suggest how can I merge files having similar
 column headers in all files, so that I can easily sort data as per my
 requirement.

 Thanks for the help.

 Pankaj Chawla
 9911104968
 -Original Message-
 From: vikas gupta [mailto:vikas.63...@gmail.com]
 Sent: 13 August 2011 18:39
 To: pankaj.chawl...@gmail.com
 Cc: tech_pankajcha...@rediffmail.com
 Subject: Fwd: $$Excel-Macros$$ Workbooks Consolidation Macro

 -- Forwarded message --
 From: ashish koul koul.ash...@gmail.com
 Date: Fri, 22 Jul 2011 05:41:02 +0530
 Subject: Re: $$Excel-Macros$$ Workbooks Consolidation Macro
 To: excel-macros@googlegroups.com

 try  this see if it helps



 On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava
 anish@gmail.comwrote:

 Harish,

 Did you try it.. ??

 On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava
 anish@gmail.comwrote:

 Harish,

 PLease ignore the earlier attachment as I forgot to add *DUPLICATE
 CHECK*in that macro.

 Use this attachment.

   On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava anish@gmail.com
  wrote:

 Hi Harsih,

 Since you didnt reply about column headers I assumed that it's the same
 for every file on share drive.

 Please see the attached file with macro.

 You must populate the file path in Sheet2-A1.

 Do let me know if it works fine for you.
 Cheers!!
 Anish
   On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava 
 anish@gmail.com wrote:

 Harish,

 I forgot to ask you one thing.
 The column headers in the file you attached will be constant for all
 the
 30-35 files which are there on your sharedrive, right?
 Cheers,
 Anish
   On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma 
 harishsharma...@gmail.com wrote:

 Hi Anish,

 Please find attached the sample file with one row filled.
 And Column C  Column H concatenate should give us unique value so
 if this is repeated then we need to have below requested feature.

 Hope this would be more clear now.

 Thanks
 Harish



 On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote:

 One sample sheet would be helpful to us to see the data structure.

 However, for this *Also identifiy if there is any row duplicated and
 highlight them and paste them into another sheet * There must be any
 particular data field which has to be checked against others in order
 to
 find duplicates.

 Macro for consolidation is not a big deal.


 On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma 
 harishsharma...@gmail.com wrote:

 Hi,

 I had a macro file which was able to consolidate small files but now
 I have a requirement to consolidate 30 workbooks saved in a share
 drive and
 this data may even cross 66000 row after consolidation. Can someone
 help me
 in creating a macro which picks all the file from shared folder and
 consolidates the one specific worksheet in all the workbook.

 This macro should also be capable of deleting any blank row in any
 of
 these 30 workbooks so that we donot miss any data if someone by
 error has
 missed a couple of row and entered the data in couple of row below.

 30 workbooks in sharedrive
 one specific worksheet from all of these named as Tracker
 Should cover all the blanks and delete them so that no data missed
 Also identifiy if there is any row duplicated and highlight them and
 paste them into another sheet
 If data crosses excel 2003 limit of row it should move to next
 worksheet.

 Hope to get a solution from excel experts.

 --
 Kind Regards,
 Harish Sharma

 --


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

Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...

2011-08-16 Thread XLS S 
Hey Sharma,

Please find the attachment


On Tue, Aug 16, 2011 at 12:53 PM, B Sharma sharma@gmail.com wrote:
 Hello to Excel Experts and other users of this group.

 I've been looking everywhere   about how to put several criteria in
 different cell ranges in:

 DSUM(database, field, criteria).

 I have a very large database and using Dsum and I am using different
 different criteria  in different different columns.

 Normally you put for example A1:G2 and everything works fine. Now the
 problem is that I have quite many criterias that are common for
 several DSUM() and I would like to split the criterias into for
 example A1:D2 and G1:G2.

 I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays
 with refernces..),
 DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc.

 What can I do?

 If anyone has an idea please let me know !!

 B. Sharma

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


Copy of EXAMPLE1.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ UDF Function for conditoin formetting

2011-08-16 Thread ICWAI Help 
Please find the attached file and give me the solution :)
if the perticuler cell value is 4 then next 4 coloumn cells in same row
shoudl be highleted .

On Tue, Aug 16, 2011 at 11:42 PM, dguillett1 dguille...@gmail.com wrote:

   I did this VERY recently in another formum. Was it you?
 Right click sheet tabview codeinsert this

 Private Sub Worksheet_Change(ByVal Target As Range)
 Dim tr As Long
 tr = Target.Row
 Rows(tr).Borders(xlEdgeBottom).LineStyle = xlNone
 If Target.Column  1 Or Not IsNumeric(Target) Or _
 Len(Application.Trim(Target))  1 Then Exit Sub
 Range(Cells(tr, 2), Cells(tr, Target + 1)) _
 .Borders(xlEdgeBottom).LineStyle = xlContinuous
 End Sub

  *From:* ICWAI Help icwai.answ...@gmail.com
 *Sent:* Tuesday, August 16, 2011 11:02 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ UDF Function for conditoin formetting

   Please provide me UDF functino for below requirement

 example:)

 if the cell value is 4 then including active cell next 4 cell in a row
 should be higleted with color.
 ex
 if
 a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.

 Thansk,
 Rakesh.
 --

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

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

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

 --

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

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

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


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


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


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

$$Excel-Macros$$ What is done?

2011-08-16 Thread XLS S 
hey All,

please look into the attachment and say how to use table function with array
(table is a function or what ?)

cell F11 = {=TABLE(,E2)} what is this

..

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


copy of table.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ What is done?

2011-08-16 Thread XLS S 
ok, got it,

thnx

On Wed, Aug 17, 2011 at 5:16 AM, XLS S xlst...@gmail.com wrote:
 hey All,

 please look into the attachment and say how to use table function with array
 (table is a function or what ?)

 cell F11 = {=TABLE(,E2)} what is this

 ..




-- 
.

-- 
--
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$$ UDF Function for conditoin formetting

2011-08-16 Thread Muhtasim Billah 
On 8/16/11, Excel VBASQL excelvba...@gmail.com wrote:
 I can do this email me at excelvba...@gmail.com

 On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help icwai.answ...@gmail.comwrote:

 Please provide me UDF functino for below requirement

 example:)

 if the cell value is 4 then including active cell next 4 cell in a row
 should be higleted with color.
 ex
 if
 a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.

 Thansk,
 Rakesh.

 --

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



-- 
B.Rgds//
Tasim

-- 
--
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$$ User Defined formula in Excel

2011-08-16 Thread Atul 
Hi,

Is there any way to defined a user defined formula in excel which will
work like default functions e.g. Sum, Average etc.

Suppose I want to insert a formula to solve the equation y=ax+b

So I will just give the value of a, b and x so it will return the
required value of Y and this function will be appear with pre-defined
functions (Sum, Average, Count).

I hope any macro is possible to do this.

Looking forward to hear from all excel gurus for this problem.

Thanks!

Regards,
Atul

-- 
--
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$$ Table - extract some data

2011-08-16 Thread Rajan_Verma 
Hi 

See if it helps, I have used name range with Range intersection ,

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Tuesday, August 16, 2011 8:08 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Table - extract some data

 

I would restructure your table to make it simpler but this works.

 

From: x x mailto:fee...@gmail.com  

Sent: Tuesday, August 16, 2011 7:31 AM

To: excel-macros@googlegroups.com 

Subject: $$Excel-Macros$$ Table - extract some data

 

Folks, please give me a hint about table attached. I'd like to find a way to
extract exact and wished value from table but of course regarding
pre-existing required conditions. 

 

For instance, if someone choose diameter 40, left diameter 10 and delta 60
excel should get in some empty cell the value 40,2. Like crossword game. How
to do it?

I've tried with filters and some if, vlookup functions but it seems to be to
complicated for my excel level of knowledge. Teach me. Many thanks.

-- 

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

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

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

-- 

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

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

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

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


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


Copy of examplei.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet