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

Reply via email to