$$Excel-Macros$$ how can we use of advance filter in worksheet change events
Hi Everyone. Can you tell me what is worksheet change events. how can we use of advance filter in worksheets change events. 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Help: Removing duplicate data
Hi All, Team, see attached file, please help me on how to remove duplicates in .xls file. .on love -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe 2.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Help: Removing duplicate data
You can use Advance filters to remove the duplicates. Select the data...Go to Data - Filter - Advance Filter - Click on Unique Records only - and Click Ok...All the duplicate records will be filtered of. Thanks, Shreedar On Thu, Sep 23, 2010 at 2:07 PM, janet dickson janetdicks...@gmail.comwrote: Hi All, Team, see attached file, please help me on how to remove duplicates in .xls file. .on love -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help: Removing duplicate data
Hi, See the attached file for details. Chandru On Thu, Sep 23, 2010 at 2:07 PM, janet dickson janetdicks...@gmail.comwrote: Hi All, Team, see attached file, please help me on how to remove duplicates in .xls file. .on love -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Copy of 2_DONExls.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Help: Removing duplicate data
Step1: Use additional columns as Test1 test 2 in Column H I Step2: Add the Below formula to H2 =A2C2D2 Step3: Add the Below formula to I2 =COUNTIF(H$2:H2,H2) Step4: Select H2 I2 then Copy paste the formula to the below cells in column HI Step5: Select the first row that the column heading then apply Data filter auto filter Step6: Apply Test2 filyter with value as 1. Now the Row with first occurance of the concatenated values are selected. Step7: Select the columns from A to G to a new wooksheet then duplicates are elminated. Enjoy. On Thu, Sep 23, 2010 at 2:07 PM, janet dickson janetdicks...@gmail.comwrote: Hi All, Team, see attached file, please help me on how to remove duplicates in .xls file. .on love -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Srinivasan Ethirajalu, +919840544295 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ vba excel understanding objects : worksheet
Hi cyberspace, I have some c programming background... Is it possible to increment a worksheet object (worksheets collection) in a loop such as below ? Public Sub CopyShNamesFromWkbToWkb2() Dim i As Integer Dim wkb As Object Set wkb = Workbooks(Nouveau_Feuille_Excel_1.xls) Dim wkb2 As Object Set wkb2 = Workbooks(Classeur1.xls) Dim ws As Object Set ws = Worksheets For i = 1 To ws.Count wkb.Sheets(3).Cells(i, 4) = wkb2.ws(i).Name'///A Next i End Sub line ///A should be: wkb.Sheets(3).Cells(i, 4) = wkb2.Sheets(i).Name Why a property pointing on an object variable such as count is working but not if it's being incremented like any excel vba name : sheets(i)... and not ws affected as a sheet ? Thanks for your help, cyber1000s -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Drop down list
Dear expert, I am facing a problem to create dependent dropdown list. Please check the attached file help. Thanks in advance Kalyan -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Drop down list.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ help need in the fomula
hi friends hereby i am attaching a worksheet in which i need a addition in the given formula for getting the desired result. please help me out. -- Sidhu -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe New Microsoft Excel Worksheet.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ vba excel understanding objects : worksheet
you need to use: Property Worksheets As Sheets of Excel.Workbook Public Sub CopyShNamesFromWkbToWkb2() Dim i As Long Dim wkb As Excel.Workbook Dim wkb2 As Excel.Workbook Set wkb = Workbooks(Nouveau_Feuille_Excel_1.xls) Set wkb2 = Workbooks(Classeur1.xls) 'Dim ws As Object 'Set ws = Worksheets For i = 1 To ws.Count wkb.Sheets(3).Cells(i, 4) = wkb2.Worksheets(i).Name'///A Next i End Sub regards r -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ vba excel understanding objects : worksheet
For i = 1 To wkb.Worksheets.Count Fix this line regards r -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help: Removing duplicate data
Thanks for your response I used *Advanced filter *and it worked out. One Love... On Thu, Sep 23, 2010 at 12:28 PM, Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com wrote: Step1: Use additional columns as Test1 test 2 in Column H I Step2: Add the Below formula to H2 =A2C2D2 Step3: Add the Below formula to I2 =COUNTIF(H$2:H2,H2) Step4: Select H2 I2 then Copy paste the formula to the below cells in column HI Step5: Select the first row that the column heading then apply Data filter auto filter Step6: Apply Test2 filyter with value as 1. Now the Row with first occurance of the concatenated values are selected. Step7: Select the columns from A to G to a new wooksheet then duplicates are elminated. Enjoy. On Thu, Sep 23, 2010 at 2:07 PM, janet dickson janetdicks...@gmail.comwrote: Hi All, Team, see attached file, please help me on how to remove duplicates in .xls file. .on love -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Srinivasan Ethirajalu, +919840544295 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ vba excel understanding objects : worksheet
On 23 Set, 12:28, roberto mensa robb@gmail.com wrote: For i = 1 To wkb.Worksheets.Count Fix this line regards r g :-) i'm sorry, so ... For i = 1 To wkb2.Worksheets.Count regard r -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help: Removing duplicate data
if you want to refer more than one column for identifying duplication you need to concatenate the columns for advance filter... please keep in mind. Thanks Srinivasan E On Thu, Sep 23, 2010 at 4:11 PM, janet dickson janetdicks...@gmail.comwrote: Thanks for your response I used *Advanced filter *and it worked out. One Love... On Thu, Sep 23, 2010 at 12:28 PM, Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com wrote: Step1: Use additional columns as Test1 test 2 in Column H I Step2: Add the Below formula to H2 =A2C2D2 Step3: Add the Below formula to I2 =COUNTIF(H$2:H2,H2) Step4: Select H2 I2 then Copy paste the formula to the below cells in column HI Step5: Select the first row that the column heading then apply Data filter auto filter Step6: Apply Test2 filyter with value as 1. Now the Row with first occurance of the concatenated values are selected. Step7: Select the columns from A to G to a new wooksheet then duplicates are elminated. Enjoy. On Thu, Sep 23, 2010 at 2:07 PM, janet dickson janetdicks...@gmail.comwrote: Hi All, Team, see attached file, please help me on how to remove duplicates in .xls file. .on love -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Srinivasan Ethirajalu, +919840544295 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Srinivasan Ethirajalu, +919840544295 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help: Getting data from website into .xls
hi check the attachment have made two functions see if it helps you On Mon, Sep 20, 2010 at 11:07 PM, janet dickson janetdicks...@gmail.comwrote: Hello Team, Everyday I am supposed to visit http://www.goldprice.org/ and checking gold price, then I enter gold price into an excel file. I was wondering if its possible to automate this task. I mean create some vba that will pick gold everday and put it into excel sheet am using. I hope am clear enough. Please help Much love -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Copy of abcde.xlsm Description: Binary data
$$Excel-Macros$$ Need to zip files
Hi All, Again I’m looking for help from you guys. This is time I’m not sure this can be done by excel macro but just really need it. I have two excel with name A_201025.xls and B_201025.xls, I need to zip the both file in a single compress file with a password protection. Below is the actual requirement. *add both Excel files to the same zip archive with maximum compression and AES 128-bit encryption using the password “hell12”*** to zip the two excel workbook is not a big problem if we will do it manually, but the same process I need to follow for more then 10-12 location. -- Thanks and Reagrd’s Shariq Shazad Khan -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ password
Send the file i will do it for you N.SHIVKUMAR Mobile : +919422613567 Office : +912332301775 Alternate Email: shiv1...@yahoo.com On 23 September 2010 04:40, Skanda skanda.pokkun...@gmail.com wrote: Hi All, How to unlock a password that is set for an excel file? -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Excel Macros
Hi, I wanted to learn Excel Macros.Kindly help me. Thanks, Aswin -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to copy ThisWorkbook events code into another thisworkbook module on another workbook
Good day everyone, I have a small fleet of Excel apps who, sometime, need updating. For modules, I simply ThisWorkbook.VBProject.VBComponents(WhateverModule).Export tempFile DestWbk.VBProject.VBComponents.Import tempFile Kill (tempFile) But I can not use the same code to import into ThisWorkbook as I do for modules. ThisWorkbook.VBProject.VBComponents(ThisWorkbook).Export tempFile DestWbk.VBProject.VBComponents.Import tempFile Kill (tempFile) Instead of replacing (or adding) the code within ThisWorkbook, it creates a new Class Modules named ThisWorkbook1. Do you have any suggestion on how could I fix that? The only other solution is to manually set all my events to something static refering to a module. 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to copy ThisWorkbook events code into another thisworkbook module on another workbook
Good day everyone, I have a small fleet of Excel apps who, sometime, need updating. For modules, I simply ThisWorkbook.VBProject.VBComponents(WhateverModule).Export tempFile DestWbk.VBProject.VBComponents.Import tempFile Kill (tempFile) But I can not use the same code to import into ThisWorkbook as I do for modules. ThisWorkbook.VBProject.VBComponents(ThisWorkbook).Export tempFile DestWbk.VBProject.VBComponents.Import tempFile Kill (tempFile) Instead of replacing (or adding) the code within ThisWorkbook, it creates a new Class Modules named ThisWorkbook1. Do you have any suggestion on how could I fix that? The only other solution is to manually set all my events to something static refering to a module. 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ lookup function comparing 3 columns
Hello I have 3 columns with data and I need to make the following comparisons: 1. value exists in all three columns 2. value exists in ONLY the first column 3. value exists in ONLY the second column 4. value exists in ONLY the third column 5. value exists in column 1 and exists in only column 2 or 3 but does NOT exist in BOTH 2 and 3 6. value exists in column 1 but NOT in column 2 7. value exists in column 1 but NOT in column 3 8. value exists in column 2 OR column 3 but not in column 1 thank you in advance (I know it is a lot of parameters) -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help need in the fomula
Hi, Instead of Roundup try Round formula. Regards, Swapnil On Thu, Sep 23, 2010 at 3:49 PM, sudarshan rampe sidhu...@gmail.com wrote: hi friends hereby i am attaching a worksheet in which i need a addition in the given formula for getting the desired result. please help me out. -- Sidhu -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ vba excel understanding objects : worksheet
Hi, I'm looking for a more general answer about objects in vba like : dim ws as object set ws = worksheets For i = 1 To wkb.Worksheets.Count wkb.Sheets(3).Cells(i, 4) = wkb2.Worksheets(i).Name It's ok until the last line, i understand what little there is to understand (pointed notation?). But is there any reason why instead of wkb2.Worksheets(i).Name i can't have wkb2.ws(i).Name ? Thx On Sep 23, 12:08 pm, r robb@gmail.com wrote: On 23 Set, 12:28, roberto mensa robb@gmail.com wrote: For i = 1 To wkb.Worksheets.Count Fix this line regards r g :-) i'm sorry, so ... For i = 1 To wkb2.Worksheets.Count regard r -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help need in the fomula
hi swapnil... if i am using round formula then the resultant value is coming to nearest ten. but i need the resultant value to next ten only if the value is more than 1 rupee in the one's place. Eg for ---8350-00 result8600.50 in this case only 8600 should be displayed. but for---9460 result--9743.8 in this case i want the formula to round to next ten as the value is more than one rupee in the one's place. -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: lookup function comparing 3 columns
Kindly share the file for better understanding -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ help need in the fomula
use =IF(*MOD(ROUNDUP(C2*3%+C2,-1),10)5*,* ROUNDUP(C2*3%+C2,-1)-MOD(ROUNDUP(C2*3%+C2,-1),10)+10*,* ROUNDUP(C2*3%+C2,-1)-MOD(ROUNDUP(C2*3%+C2,-1),10*)) On Fri, Sep 24, 2010 at 9:12 AM, sudarshan rampe sidhu...@gmail.com wrote: hi swapnil... if i am using round formula then the resultant value is coming to nearest ten. but i need the resultant value to next ten only if the value is more than 1 rupee in the one's place. Eg for ---8350-00 result8600.50 in this case only 8600 should be displayed. but for---9460 result--9743.8 in this case i want the formula to round to next ten as the value is more than one rupee in the one's place. -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Srinivasan Ethirajalu, +919840544295 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Hi....
Hi Ayush, I'm sasikanth. I'm new joinee to your group. I want to learn excel macros (VBA). Could you please suggest me how to start because I don't know how to write VBA script. Please suggest me how to start with it. Thanks Regards, Sasikanth. -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ lookup function comparing 3 columns
Please clarify: Below are all possibilities: *** Possibilities: Value to be displayed *** ABC 1 A-- 2 -B- 3 --C 4 AB- 5 A-C 6 -BC 7 --- 8 *** On Thu, Sep 23, 2010 at 11:14 PM, OS osf...@gmail.com wrote: Hello I have 3 columns with data and I need to make the following comparisons: 1. value exists in all three columns 2. value exists in ONLY the first column 3. value exists in ONLY the second column 4. value exists in ONLY the third column 5. value exists in column 1 and exists in only column 2 or 3 but does NOT exist in BOTH 2 and 3 6. value exists in column 1 but NOT in column 2 7. value exists in column 1 but NOT in column 3 8. value exists in column 2 OR column 3 but not in column 1 thank you in advance (I know it is a lot of parameters) -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Srinivasan Ethirajalu, +919840544295 -- -- 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 HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe