+ Reply to Thread
Results 1 to 2 of 2

Automatically adding a row to a list

  1. #1
    Registered User
    Join Date
    06-15-2006
    Posts
    3

    Automatically adding a row to a list

    Hi

    I am using Excel 2002 and I am having a problem.

    I have a large form where I enter data against people over a weekly period. For each person, I have three rows per day where I can enter info. This is nomrally enough but ocassionally I need more rows for a particular person.

    What I would like happen is that when I type in the final row for that person, for another row to automatically insert itself below the row I am typing into. I have looked and I think there is a built in function to do this in version 2003 but not 2002.

    To be ultra fuzzy it would be even better if the row that is automatically inserted kept the same format as the row above it. This is becuase some of the columns have merged cells and some do not.

    Any help would be greatly appreciated...

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Response

    I would suggest a macro linked to the Worksheet_Change event. You could test if the row was the last of the three, insert a new row below and then copy/paste special formats from the original.
    Martin

+ 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