It's Ok and you are welcome to get back in case of any other quer(ies). Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062
On 1/3/10, San Pat <myitems2...@gmail.com> wrote: > > Hi Dilip, > > I understood now and it was my mistake. > > Really appreciate your help. > > Regards, > Sandip > > > On Sat, Jan 2, 2010 at 10:22 PM, Dilip Pandey <dilipan...@gmail.com>wrote: > >> Dear Sandip, >> >> This is because the original row does'nt have the formula in cells >> (Q7:U7). Macro is doing good as per you initial requirement which was to >> copy the formula from previous row to newly inserted row. Requirements are >> reproduced below:- >> >> *"After the addition of new row7, the old row7 will be row8 and the new >> row7 should have all the formula of old row7 (copy of all formula from >> previous cells)."* >> >> *Suggestion,* pls make sure the existing row (old row) should have the >> formulae, then only they will be carry forward to newly inserted row. :) >> >> Best Regards, >> >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> On 1/3/10, San Pat <myitems2...@gmail.com> wrote: >>> >>> Hi Dilip, >>> >>> Thanks for your help. >>> >>> This is what I wanted!!! >>> >>> But there is one issue in this sheet, when I add a new row, It is not >>> copying the formula in the new cells (Q7:U7). >>> >>> Regards, >>> Sandip >>> >>> >>> On Sat, Jan 2, 2010 at 3:26 AM, Dilip Pandey <dilipan...@gmail.com>wrote: >>> >>>> Dear Sandip, >>>> >>>> Workbook containing your desired macro is attached with this email. >>>> Click on the yellow icon in column A and that will do the needful. >>>> >>>> Best Regards n Happy New Year. >>>> -- >>>> DILIP KUMAR PANDEY >>>> MBA-HR,B COM(Hons.),BCA >>>> Mobile: +91 9810929744 >>>> dilipan...@gmail.com >>>> dilipan...@yahoo.com >>>> New Delhi - 110062 >>>> >>>> >>>> On 1/2/10, San Pat <myitems2...@gmail.com> wrote: >>>>> >>>>> Hi Dilip, >>>>> >>>>> I have sent the following request on the group. >>>>> >>>>> Could you please provide your help on this issue? I have attached the >>>>> file also. >>>>> >>>>> Regards, >>>>> Sandip >>>>> >>>>> >>>>> On Fri, Jan 1, 2010 at 2:00 PM, San Pat <myitems2...@gmail.com> wrote: >>>>> >>>>>> Hi All, >>>>>> >>>>>> I am using various formulas in different cells. Please see the >>>>>> attached file. I want to create a macro with the button which will add a >>>>>> new >>>>>> row on top of Row7. >>>>>> >>>>>> After the addition of new row7, the old row7 will be row8 and the new >>>>>> row7 should have all the formula of old row7 (copy of all formula from >>>>>> previous cells). >>>>>> >>>>>> Regards, >>>>>> San >>>>>> >>>>>> -- >>>>>> >>>>>> ---------------------------------------------------------------------------------- >>>>>> Some important links for excel users: >>>>>> 1. Follow us in TWITTER for tips tricks and links : >>>>>> http://twitter.com/exceldailytip >>>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>>>>> http://www.excelitems.com >>>>>> 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 >>>>>> If you find any spam message in the group, please send an email to: >>>>>> Ayush Jain @ jainayus...@gmail.com >>>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>>> HELP US GROW !! >>>>>> >>>>>> We reach over 6,500 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 in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 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