+ Reply to Thread
Results 1 to 10 of 10

Inset rows & fill that rows base on formula.

  1. #1
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Post Inset rows & fill that rows base on formula.

    dear friend in my document column "L" has some numbers & formulas.if any cell has formula base in that i need to inset rows below that formula cell & that formula need to spread on that new rows.i have 4 type of formulas.each formula has (1.5).that part is common. it 's like this...

    (01.)ex- L1 cell =150*2*1.5 ,need to inset one row below this cell & after running the macro it should change like this..
    L1 cell =150*1.5
    L2 cell =150*1.5

    (02.)ex- L1 cell =150*2*1.5+50*1.5 ,need to inset two rows below this cell & after running the macro it should change like this..
    L1 cell =150*1.5
    L2 cell =150*1.5
    L3 cell =50*1.5

    (03.)ex- L1 cell =150*2*1.5+130*3*1.5 ,need to inset four rows below this cell & after running the macro it should change like this..
    L1 cell =150*1.5
    L2 cell =150*1.5
    L3 cell =130*1.5
    L4 cell =130*1.5
    L5 cell =130*1.5

    (04.)ex- L1 cell =150*2*1.5+130*3*1.5+20*1.5 ,need to inset five rows below this cell & after running the macro it should change like this..
    L1 cell =150*1.5
    L2 cell =150*1.5
    L3 cell =130*1.5
    L4 cell =130*1.5
    L5 cell =130*1.5
    L6 cell =20*1.5

    pls any body can make this macro it's very big help for me.thanks.
    Last edited by johncena; 02-15-2010 at 05:05 AM.

  2. #2
    Registered User
    Join Date
    01-23-2010
    Location
    Moscow
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Inset rows & fill that rows base on formula.

    Try this code
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Smile Re: Inset rows & fill that rows base on formula.

    Quote Originally Posted by IgorSharov View Post
    Try this code
    thank u very much i will check....

  4. #4
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Post Re: Inset rows & fill that rows base on formula.

    Quote Originally Posted by IgorSharov View Post
    Try this code
    dear friend according to my samples it's work very well.but i change one formula like below.that time it's not work properly pls check...

    =150*15*1.5+130*2*1.5+25*1.5
    Last edited by johncena; 02-15-2010 at 03:55 AM.

  5. #5
    Registered User
    Join Date
    01-23-2010
    Location
    Moscow
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Inset rows & fill that rows base on formula.

    I know a reason of this. I will correct this mistake in a few minutes.

  6. #6
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Post Re: Inset rows & fill that rows base on formula.

    Quote Originally Posted by IgorSharov View Post
    I know a reason of this. I will correct this mistake in a few minutes.
    thanks u very much.u done great help for me.i need small changes.that column "L" newly inserted values can copy to same row column "M" also.i don't wont to copy whole "L" column to column "M".i need which we change using this macro that cells only i need to copy.if any dates in column "M" overwrite it,thanks u very much.

  7. #7
    Registered User
    Join Date
    01-23-2010
    Location
    Moscow
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Inset rows & fill that rows base on formula.

    Here it is.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Re: Inset rows & fill that rows base on formula.

    Quote Originally Posted by IgorSharov View Post
    Here it is.
    wow it's work great friend.u genius.......

  9. #9
    Registered User
    Join Date
    01-23-2010
    Location
    Moscow
    MS-Off Ver
    Excel 2007
    Posts
    27

    Smile Re: Inset rows & fill that rows base on formula.

    I was glad to help

  10. #10
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Re: Inset rows & fill that rows base on formula.

    Quote Originally Posted by IgorSharov View Post
    I was glad to help
    sorry for disturbing,i have try to send pvt message,but it's not working.can i ask another help here...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1