Results 1 to 18 of 18

Macro to insert # of row specific in a cell

Threaded View

  1. #1
    Registered User
    Join Date
    05-06-2011
    Location
    New York, US
    MS-Off Ver
    Excel 2007
    Posts
    25

    Smile Macro to insert # of row specific in a cell

    Hi All,

    hope someone can help to achieve the below.
    I am working on an excel file as attached file, tiger.xls
    this is what i am trying to accomplish to write in Marco.

    Part A:
    in the H column, i need to insert the # of row minus the number that is in the cell. for ex. when
    H2 = 3, to insert 2 blank row down
    H3 = 2, to insert 1 blank row down

    however, if the cell is 1, then do not add any row

    Inserting the blank row should come to a STOP whenit reaches [Total] on colunm A.
    when this is done, the file shouuld like file as attached: lion.xls

    Part B:
    Auto populate the number in an increasement format in the empty cells follow by the Max# in Column A.

    in this example, in Colunm A the max# is 10. so
    the first empty cell [A3]l should be listed as 11.
    The increasment should be carried on, unitl it reaches a smaller number.
    in this case:

    A3 = 11
    A4 = 12
    A5 = 2

    stop, and then

    A6 = continue to auto populate [increasement] from last Max #
    which means, A6 = 13

    auto populate number should be stopped when it reaches to the cell [Total]

    the final file should look like as attached, bear.xls

    Appreciate for any thoughts and comment.

    Regards
    Attached Files Attached Files
    Last edited by NBVC; 05-10-2011 at 02:20 PM. Reason: Sloved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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