$$Excel-Macros$$ VBA Macro with Input Box
Hi Where can I find some good info on : When a macro runs I want a input box for user to insert the column range A:(or B; or F: etc) and then a input box for the text to look for say ABC or 123 or xyz etc and then a third box for the column for a format to be done. Have googled but have not found anything. Let me know of a suitable site and I can try and adapt code Thank you Charlie -- -- 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$$ help requ
Hi, Is this possible using formula ? On Thu, Jul 21, 2011 at 7:38 PM, Anish Shrivastava anish@gmail.comwrote: Hi Vijay, See the attached file. let me know if it works fine. On Thu, Jul 21, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, I have names, order no and county names in two sheets.. need to consolidate in one sheet.. Thanks On Thu, Jul 21, 2011 at 7:04 PM, Anish Shrivastava anish@gmail.comwrote: Vijay, Though you have provided the sample sheet your requirement is not clear. What do you mean by merge the names in one sheet. do you want to consolidate the data or you want a concatenation. On Thu, Jul 21, 2011 at 5:33 PM, vijayajith VA vijayajith...@gmail.com wrote: fyi On Wed, Jul 20, 2011 at 6:25 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Vijay, Please provide sample sheet On Wed, Jul 20, 2011 at 5:49 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi, 1; I have several names in two sheets..i need to merge it in one sheet...is this possible using formula.. 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 -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- 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
Re: $$Excel-Macros$$ Re: VBA - Remove duplicate and get sums
Hi All, Thank you all for your response. Special thanks to Noorain Ansari, who provided me what I wanted. Regards, Raghavendra On Jul 22, 8:22 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Raghvendra, Please try below code and see attached sheet Sub advancefilter_sumif() Dim i, j As Long Dim abc, cba As Range Application.ScreenUpdating = False Sheet1.Range(A1:A Sheet1.Range(A1).End(xlDown).Row).Copy Sheet1.Range(D1).Select ActiveSheet.Paste Sheet1.Range(E1).Value = Amount Sheet1.Range(D1:D Sheet1.Range(A1).End(xlDown).Row).RemoveDuplicates 1, xlNo j = Application.WorksheetFunction.CountA(Sheet1.Range(D:D)) Set abc = Sheet1.Range(A1:A Sheet1.Range(A1).End(xlDown).Row) Set cba = Sheet1.Range(B1:B Sheet1.Range(B1).End(xlDown).Row) For i = 2 To j Sheet1.Range(E i).Value = Application.WorksheetFunction.SumIf(abc, Sheet1.Range(D i).Value, cba) Next Application.ScreenUpdating = True end sub -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Jul 22, 2011 at 12:24 AM, GoldenLance samde...@gmail.com wrote: A Pivot Table is used precisely for such computations. As a thumb rule, use Excel functions and tools where Excel can handle it efficiently. Use VBA only if Excel cannot give desired output on its own On Jul 21, 10:19 pm, Raghavendra raghavendra@gmail.com wrote: Hi, Can anyone let me know VBA code for the below? Input Data Names Amount A 100 B 200 C 100 B 100 A 100 D 150 Out put data should be Names Amount A 200 B 300 C 100 D 150 Regards, Raghavendra -- -- 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 advance Filter + Sumif_Example.xlsm 25KViewDownload -- -- 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$$ Extracting data from Website
Thank u Ashish. I will check it out and come back to u If I have any clarification. Thanks! On Thu, Jul 21, 2011 at 3:07 PM, ashish koul koul.ash...@gmail.com wrote: http://akoul.blogspot.com/2011/06/macro-to-import-data-from-webpage-to.html http://akoul.blogspot.com/2011/06/copy-data-of-webpage-to-excel-using.html http://akoul.blogspot.com/2011/06/macro-to-copy-text-from-webpage-to.html On Thu, Jul 21, 2011 at 6:30 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Any link is ok. Just I need to learn how to do this task. Thanks. On Thu, Jul 21, 2011 at 2:15 PM, ashish koul koul.ash...@gmail.comwrote: can you send the direct link On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, How to extract data from websites for ex: Yahoo News Columns. could anyone provide VBA code for this. 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Excel Pivot data export into Access or text file
Hi All, Please can anyone help me how to export excel pivot data into access table or text file Is that possible? Thanks in advance Sushil -- -- 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$$ Extracting data from Website
Hi Asish, How to pull out particular lines or paragraphs in any site. Can we do this without using webquery method. Please let me know about this. Thanks, Chandra Shekar B On Fri, Jul 22, 2011 at 1:00 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Thank u Ashish. I will check it out and come back to u If I have any clarification. Thanks! On Thu, Jul 21, 2011 at 3:07 PM, ashish koul koul.ash...@gmail.comwrote: http://akoul.blogspot.com/2011/06/macro-to-import-data-from-webpage-to.html http://akoul.blogspot.com/2011/06/copy-data-of-webpage-to-excel-using.html http://akoul.blogspot.com/2011/06/macro-to-copy-text-from-webpage-to.html On Thu, Jul 21, 2011 at 6:30 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Any link is ok. Just I need to learn how to do this task. Thanks. On Thu, Jul 21, 2011 at 2:15 PM, ashish koul koul.ash...@gmail.comwrote: can you send the direct link On Thu, Jul 21, 2011 at 4:34 PM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, How to extract data from websites for ex: Yahoo News Columns. could anyone provide VBA code for this. 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- 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$$ ***Formula for find and replace***
Try this =SUBSTITUTE(A1,abc,#) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Thursday, July 21, 2011 8:51 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ ***Formula for find and replace*** Hi Friends, Can you help me to know the formula for find and replace.Examble i need to find ABC in the A1 cell and replace with #. If there is no 'ABC existing A1 should remain as it is. Existing CellReplace as 12ABC 12# 13XTZ 13XTZ -- -- 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$$ VBA Conditional Format Offset
Try the Attachement -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: Thursday, July 21, 2011 9:36 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ VBA Conditional Format Offset Try : Sub ConFormatOffset() With Range([A1], Cells(Rows.Count, 1).End(xlUp)) .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Operator:=xlGreater, _ Formula1:==A1B1 .FormatConditions(1).Interior.Color = RGB(255, 0, 0) End With End Sub Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Natron Envoyé : jeudi 21 juillet 2011 04:15 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ VBA Conditional Format Offset I have multiple columns (around 140) of data and need to conditionally format the data as apposed to looping through. For instance I have the following data in column A and B. A B 1 10 2 1 8 4 4 3 5 6 Here is basically what I'm trying to do: If Column A has a value Greater than Column B then change Column A cell interior color to red My attempt in a Macro to perform this task is Below...not quite working Sub ConFormatOffset() With Selection Debug.Print ActiveCell Debug.Print ActiveCell.Offset(0, 2) .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Operator:=xlGreater, Formula1:==A1Offset(ActiveCell,0,2) .FormatConditions(1).Interior.Color = RGB(255, 0, 0) End With 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 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 Conditonal.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error
Set Wb=ActiveWorkbook From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Thursday, July 21, 2011 10:44 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error Hi guys, i have this macro i use to copy a range from column D of a worksheet of a workbook to column G of another workbook and worksheet, but it keeps giving me the same error saying that it´s subscript out of range in the line in yellow. Public wb, wbmes As Workbook Sub filldatabase() Call AbrirFile Call left wbmes.Close End Sub Private Sub AbrirFile() Dim Filter, Caption As String Dim SelectedFile As Variant Set wb = ThisWorkbook Filter = Ficheiro XLS (*.xls),(*.xls) Caption = Escolha o ficheiro a importar... SelectedFile = Application.GetOpenFilename(Filter, , Caption) If SelectedFile = False Then Exit Sub Set wbmes = Workbooks.Open(SelectedFile, 1, 1) End Sub Private Sub left() Dim a As Double wbmes.Activate wbmes.Sheets(Total_Refrige).Select wbmes.Sheets(Total_Refrige).Range(Range(D2), Range(D2).End(xlDown)).Copy wb.Activate If wb.Sheets(Pivot).Range(G2).Value Then wb.Sheets(Pivot).Range(G1).End(xlDown).Offset(1, 0).Select Else wb.Sheets(Pivot).Range(G2).Select End If a = ActiveCell.Row wb.Sheets(Total Refrige).Paste Application.CutCopyMode = False i = a While wb.Sheets(Pivot).Range(G i).Value i = i + 1 Wend End Sub Do you have any idea how to solve this?1000 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
RE: $$Excel-Macros$$ Excel formula help
See the attached File, From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Thursday, July 21, 2011 10:54 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel formula help Hi Friends, In the attached sheet wherever we find Opt. (Opt dart and a space) is replace with # and add with the previous cell which does not contain Opt.originally. As per the attached sheet A9,10,11,12 we have to remove Opt. and add # with A8 as prefix. Similarly in A3 Opt. 0D1- Remove Opt. and insert # in front of A2 text i.e AH401A IF there is no Opt. in a particular cell it will remain as it is. Plz help me with formula. Regards, Prabhu -- -- 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 Opt .xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ Automatic Outlook message
See if it helps http://danielcurran.com/outlook/how-to-create-a-reminder-email-for-outlook-e mail-from-excel/ http://www.dummies.com/how-to/content/setting-up-email-reminders-in-outlook- 2007.html From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Sent: Thursday, July 21, 2011 11:03 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Automatic Outlook message Hi all, I need to send Automatic mail message from my mail id to some around 10 members in every week end to remind them to do something. I can create distribution list for whom i have to send mails, Message content will be same only. It needs to reach every week end to that particular distribution list members. Is there any way to send automatic reminder mail ? Plz help. Regards Prabhu -- -- 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$$ VBA - Remove duplicate and get sums
If your date in A and B Column then Try it Sub RemoveDuplicate() Dim rng As Range Dim cell As Range Set rng = Range(A2:A ActiveSheet.UsedRange.Rows.Count) For Each cell In rng If WorksheetFunction.CountIf(rng, cell.Value) 1 Then cell.EntireRow.Delete End If Next Range(B Range(B1).End(xlUp).Row + 1).Formula = =Sum(B2:B Range(B1).End(xlUp).Row ) End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Raghavendra Sent: Thursday, July 21, 2011 10:49 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ VBA - Remove duplicate and get sums Hi, Can anyone let me know VBA code for the below? Input Data Names Amount A 100 B 200 C 100 B 100 A 100 D 150 Out put data should be Names Amount A 200 B 300 C 100 D 150 Regards, Raghavendra -- -- 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: VBA - Remove duplicate and get sums
Try this Sub ReMoveDuplicateAndSum() Dim cell As Range Dim Rng As Range Range(A:A).Copy Range(E1) Range(E:E).RemoveDuplicates 1 Set Rng = Range(F2:F Range(E1).End(xlUp).Row) Range(F1).Value = Amount For Each cell In Rng cell.Value = WorksheetFunction.SumIf(Range(A:A), cell.Offset(0, -1).Value, Range(B:B)) Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Friday, July 22, 2011 8:52 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: VBA - Remove duplicate and get sums Dear Raghvendra, Please try below code and see attached sheet Sub advancefilter_sumif() Dim i, j As Long Dim abc, cba As Range Application.ScreenUpdating = False Sheet1.Range(A1:A Sheet1.Range(A1).End(xlDown).Row).Copy Sheet1.Range(D1).Select ActiveSheet.Paste Sheet1.Range(E1).Value = Amount Sheet1.Range(D1:D Sheet1.Range(A1).End(xlDown).Row).RemoveDuplicates 1, xlNo j = Application.WorksheetFunction.CountA(Sheet1.Range(D:D)) Set abc = Sheet1.Range(A1:A Sheet1.Range(A1).End(xlDown).Row) Set cba = Sheet1.Range(B1:B Sheet1.Range(B1).End(xlDown).Row) For i = 2 To j Sheet1.Range(E i).Value = Application.WorksheetFunction.SumIf(abc, Sheet1.Range(D i).Value, cba) Next Application.ScreenUpdating = True end sub -- Thanks regards, Noorain Ansari http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Fri, Jul 22, 2011 at 12:24 AM, GoldenLance samde...@gmail.com wrote: A Pivot Table is used precisely for such computations. As a thumb rule, use Excel functions and tools where Excel can handle it efficiently. Use VBA only if Excel cannot give desired output on its own On Jul 21, 10:19 pm, Raghavendra raghavendra@gmail.com wrote: Hi, Can anyone let me know VBA code for the below? Input Data Names Amount A 100 B 200 C 100 B 100 A 100 D 150 Out put data should be Names Amount A 200 B 300 C 100 D 150 Regards, Raghavendra -- -- 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 -- -- 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$$ Question regarding Sheets
Open Both Sheets and Run This Macro to Get Desired Result : Sub Seperate() Dim Wbopen As Workbook Dim wb As Workbook Set wb = Workbooks.Add ActiveWorkbook.SaveAs Consolidate wb.Sheets.Add.Name = BT wb.Sheets.Add.Name = BT-1 For Each Wbopen In Application.Workbooks If Wbopen.Name Consolidate Then For Each sh In Wbopen.Sheets If sh.Name = BT Then sh.UsedRange.Copy wb.Activate wb.Sheets(BT).Activate ActiveSheet.Range(A ActiveSheet.UsedRange.Rows.Count + 1).Activate ActiveSheet.Paste Application.CutCopyMode = False End If If sh.Name = BT-1 Then sh.UsedRange.Copy wb.Activate wb.Sheets(BT-1).Activate ActiveSheet.Range(A ActiveSheet.UsedRange.Rows.Count + 1).Activate ActiveSheet.Paste Application.CutCopyMode = False End If Next End If Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of neil johnson Sent: Friday, July 22, 2011 8:04 PM To: excel-macros Subject: $$Excel-Macros$$ Question regarding Sheets Hi all, I have two sheets . in these sheets i have data in two tabes name BT BT-1 I want to consolidate respectively tab. (BT from sheets 1 and BT (Tabs) from sheet 2 both data should goes in another new workbooks with sheet name(BT) and same as BT -1 . How ? Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Copy text from Word and paste into Excel
I am a newbie to VBA I have a word document that is composed of many pages with text. I want to find the first occurance of Objective and copy the text that follows then paste it into A1. Find the next occurance and past it into A2. Do this until the end of the word file. Then find the first occurance of Date and copy the text that follows then paste it into B1. Find the next occurance and paste it into B2. Do this until the end of the word file. Thanks in advance for some VBA code for Excel that can save me tons of time! -- -- 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$$ Copy text from Word and paste into Excel
Do the following 1.creTe word app 2.take microsoft word library in the references 3m specify the path of word doc and On 7/22/11, dkelb dkelb1...@gmail.com wrote: I am a newbie to VBA I have a word document that is composed of many pages with text. I want to find the first occurance of Objective and copy the text that follows then paste it into A1. Find the next occurance and past it into A2. Do this until the end of the word file. Then find the first occurance of Date and copy the text that follows then paste it into B1. Find the next occurance and paste it into B2. Do this until the end of the word file. Thanks in advance for some VBA code for Excel that can save me tons of time! -- -- 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 -- Hari kumar Our strength grows out of our weaknesses. -- -- 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$$ Call Center Dashboards
thank you... On Fri, Jul 22, 2011 at 7:12 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *See if it helps.* http://www.steptocallcenter.com/call_center_operational_documents_templates.html ** * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Raghunandan *Sent:* Thursday, July 21, 2011 10:10 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Call Center Dashboards ** ** Hi Guys, ** ** Can any1 help me out by sending Call center KPI dashboards or any link where in I can find that. ** ** Thank you... -- -- 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$$ Copy text from Word and paste into Excel
I dont' know the details of the code. Do you mind scripting it up?? Thanks. On Fri, Jul 22, 2011 at 11:23 AM, hari kumar prekkeh...@gmail.com wrote: Do the following 1.creTe word app 2.take microsoft word library in the references 3m specify the path of word doc and On 7/22/11, dkelb dkelb1...@gmail.com wrote: I am a newbie to VBA I have a word document that is composed of many pages with text. I want to find the first occurance of Objective and copy the text that follows then paste it into A1. Find the next occurance and past it into A2. Do this until the end of the word file. Then find the first occurance of Date and copy the text that follows then paste it into B1. Find the next occurance and paste it into B2. Do this until the end of the word file. Thanks in advance for some VBA code for Excel that can save me tons of time! -- -- 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 -- Hari kumar Our strength grows out of our weaknesses. -- -- 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$$ Copy text from Word and paste into Excel
Attached your word document. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Darin Kelberlau Sent: Saturday, July 23, 2011 9:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy text from Word and paste into Excel I dont' know the details of the code. Do you mind scripting it up?? Thanks. On Fri, Jul 22, 2011 at 11:23 AM, hari kumar prekkeh...@gmail.com wrote: Do the following 1.creTe word app 2.take microsoft word library in the references 3m specify the path of word doc and On 7/22/11, dkelb dkelb1...@gmail.com wrote: I am a newbie to VBA I have a word document that is composed of many pages with text. I want to find the first occurance of Objective and copy the text that follows then paste it into A1. Find the next occurance and past it into A2. Do this until the end of the word file. Then find the first occurance of Date and copy the text that follows then paste it into B1. Find the next occurance and paste it into B2. Do this until the end of the word file. Thanks in advance for some VBA code for Excel that can save me tons of time! -- -- 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 -- Hari kumar Our strength grows out of our weaknesses. -- -- 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