Re: $$Excel-Macros$$ macro for copy down
Sub Test() Dim Rng As Range Lrow = ActiveSheet.Range(A65536).End(xlUp).Row ' Last Row in Column A. Set Rng = ActiveSheet.Range(B1) ' Cell where you have the vlookup formula Rng.AutoFill Destination:=Range(B1 :B Trim(Str(Lrow))), Type:=xlFillDefault End Sub On Tue, Jul 5, 2011 at 2:58 PM, Rash rashmiv.ni...@gmail.com wrote: Hi All, I have excel file with 12000+ rows, and 10 column where i have used Vlookup and sumif function in the second row, i need a macro which copy down the function till the last row with min. time frame. Appreciate your support in advance. Regards Rash -- -- 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 Vasant skype Id: vasantjob vasant...@gmail.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
Re: $$Excel-Macros$$ macro for copy down
Hi Dear, You can do this with the help of record macro easily. Please forward me your sheet i will try to help you. Thanks regards, Vikas verma On Tue, Jul 5, 2011 at 2:58 PM, Rash rashmiv.ni...@gmail.com wrote: Hi All, I have excel file with 12000+ rows, and 10 column where i have used Vlookup and sumif function in the second row, i need a macro which copy down the function till the last row with min. time frame. Appreciate your support in advance. Regards Rash -- -- 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, Vikas Verma Bank of America delhi.ve...@gmail.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
Re: $$Excel-Macros$$ macro for copy down
I think Default Fill option will take minimum time then User Define Macro. You can fill Down your Formula By Ctrl+D On Tue, Jul 5, 2011 at 2:58 PM, Rash rashmiv.ni...@gmail.com wrote: Hi All, I have excel file with 12000+ rows, and 10 column where i have used Vlookup and sumif function in the second row, i need a macro which copy down the function till the last row with min. time frame. Appreciate your support in advance. Regards Rash -- -- 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 Rajan verma +91 9158998701 -- -- 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$$ Macro to copy down/right and back up one line
Can anyone help with this? Not sure how well this copied but I have gl accts on the left with the months across the top. I need to copy only the acct data over to another tab and occasionally new accounts will be inserted so I don't want to lock in the range. I would like to go to Dec Actual for acct 60, shift end down/shift end right and then back up one so I DO NOT copy the subtotal row (Salaries, Wages and commission) on the first set of data. Thanks, David DecemberJanuary February Actual Actual Actual FY10FY10FY10 Salaries - Base Wages - 60 46682.76172 29865.39063 -76548.14844 Salaries - Overtime - 65468.9299927 0 -468.9299927 Salaries-Hourly - 660 0 0 Salaries - Vacation - 670 0 0 Salaries - Long Service Leave - 68 0 0 0 Salaries - Holiday - 69 0 0 0 Salaries - Sick - 6000100 0 0 Hourly-Overtime - 6000110 0 0 Salaries, Wages and commission 47151.69171 29865.39063 -77017.07843 Salaries - Severance - 600200 0 0 0 Salaries - Additional Compensation - 600210 4166.669922 4166.669922 -8333.339844 Salaries - Other - 600290 0 0 0 Other Compensation 4166.669922 4166.669922 -8333.339844 Pension Plan Expense - 600420 0 0 0 Retirement Savings Plan Expense - 6004250 0 0 Medical Insurance - 600430 0 0 0 Life Insurance - 600435 0 0 0 Taxable Fringe Benefits - 6004400 0 0 Relocation - 600445 0 0 0 Motor Vehicle Allowance - 6004500 0 0 Housing Allowance - 600451 0 0 0 WC/Employer Liab Ins - 600455 0 0 0 Union Fees - 600480 0 0 0 Statutory Payroll Deductions Employer - 600485 0 0 0 Statutory Payroll Deductions Employee - 600486 0 0 0 Other Employee Benefit Expenses - 60049016503.09961 10452.88965 -26955.99023 Expat - Family Tuition - 600491 0 0 0 Expat - Home Leave - 600492 0 0 0 Expat - Housing Utilities - 6004930 0 0 Expat - Medical - 6004940 0 0 Expat - Other Benefits - 600495 0 0 0 Expat - Tax - 6004960 0 0 Fringe benefits 16503.09961 10452.88965 -26955.99023 Thanks, df On Oct 11, 8:39 pm, Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com wrote: sample data pls On Tue, Oct 12, 2010 at 5:33 AM, DEF defl...@gmail.com wrote: I have a file that is gl accts and $$ amts with a subtotal at the bottom. I need to copy down and then over and then come back up off of the subtotal line. I tried offset and resize but couldn't get it to do a row instead of a cell. -- ------ 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/pages/discussexcelcom/160307843985936?v=wall;... -- Srinivasan Ethirajalu, +919840544295- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Macro to copy down/right and back up one line
Not sure how well this copied but I have gl accts on the left with the months across the top. I need to copy only the acct data over to another tab and occasionally new accounts will be inserted so I don't want to lock in the range. I would like to go to Dec Actual for acct 60, shift end down/shift end right and then back up one so I DO NOT copy the subtotal row (Salaries, Wages and commission) on the first set of data. Thanks, David DecemberJanuary February Actual Actual Actual FY10FY10FY10 Salaries - Base Wages - 60 46682.76172 29865.39063 -76548.14844 Salaries - Overtime - 65468.9299927 0 -468.9299927 Salaries-Hourly - 660 0 0 Salaries - Vacation - 670 0 0 Salaries - Long Service Leave - 68 0 0 0 Salaries - Holiday - 69 0 0 0 Salaries - Sick - 6000100 0 0 Hourly-Overtime - 6000110 0 0 Salaries, Wages and commission 47151.69171 29865.39063 -77017.07843 Salaries - Severance - 600200 0 0 0 Salaries - Additional Compensation - 600210 4166.669922 4166.669922 -8333.339844 Salaries - Other - 600290 0 0 0 Other Compensation 4166.669922 4166.669922 -8333.339844 Pension Plan Expense - 600420 0 0 0 Retirement Savings Plan Expense - 6004250 0 0 Medical Insurance - 600430 0 0 0 Life Insurance - 600435 0 0 0 Taxable Fringe Benefits - 6004400 0 0 Relocation - 600445 0 0 0 Motor Vehicle Allowance - 6004500 0 0 Housing Allowance - 600451 0 0 0 WC/Employer Liab Ins - 600455 0 0 0 Union Fees - 600480 0 0 0 Statutory Payroll Deductions Employer - 600485 0 0 0 Statutory Payroll Deductions Employee - 600486 0 0 0 Other Employee Benefit Expenses - 60049016503.09961 10452.88965 -26955.99023 Expat - Family Tuition - 600491 0 0 0 Expat - Home Leave - 600492 0 0 0 Expat - Housing Utilities - 6004930 0 0 Expat - Medical - 6004940 0 0 Expat - Other Benefits - 600495 0 0 0 Expat - Tax - 6004960 0 0 Fringe benefits 16503.09961 10452.88965 -26955.99023 On Oct 11, 8:39 pm, Srinivasan Ethirajalu srinivasan.ethiraj...@gmail.com wrote: sample data pls On Tue, Oct 12, 2010 at 5:33 AM, DEF defl...@gmail.com wrote: I have a file that is gl accts and $$ amts with a subtotal at the bottom. I need to copy down and then over and then come back up off of the subtotal line. I tried offset and resize but couldn't get it to do a row instead of a cell. -- ------ 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/pages/discussexcelcom/160307843985936?v=wall;... -- Srinivasan Ethirajalu, +919840544295- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
