+ Reply to Thread
Results 1 to 3 of 3

adding rows automatically

  1. #1
    Registered User
    Join Date
    05-09-2007
    Posts
    1

    adding rows automatically

    If I am developing a template for my boss to input information, is there a way that an additional row could be inserted after she enters information into a cell?

    Thanks.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Saintr,

    Copy the code below using CTRL+C. Right click the Worksheet tab you want to place the macro in. Click "View Code" on the popup menu, and Paste the code in using CTRL+V. Save the changes using CTRL+S. This is set to isert a new row if you change any cell in column "A". You can change the column by changing the letter in red to what you want.

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross
    Last edited by Leith Ross; 05-09-2007 at 05:39 PM.

  3. #3
    Registered User
    Join Date
    05-11-2007
    Location
    Perth, Western Australia
    Posts
    9
    I just tried this code, because I need it too, especially if specific text is entered in the cell (not just a change).

    code only added extra cells, not the whole row, and kept doing it till it eventually crashed.

    how do i:
    when "FD" or "STD" is chosen from the dropdown list in, say, L26, instead of changing entry in L26, it inserts a row below it (row 27), copies all the formatting (but only the formatting) from the row above or below or whatever, & inserts "FD" or "STD" into the new row (in L27).

    so sorry to piggyback on your original enquiry, saintr, terrible manners, but I was getting around to asking anyway...

+ 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