+ Reply to Thread
Results 1 to 3 of 3

How to make my rows update automatically when inserting new ones?

  1. #1
    Registered User
    Join Date
    03-03-2018
    Location
    london
    MS-Off Ver
    2016
    Posts
    1

    How to make my rows update automatically when inserting new ones?

    I have a pretty large excel file with 1000+ rows of customer data. I have a "Number" column for each customer. I'm trying to update this list by inserting row in between this list but the sequence of number breaks. Is there a way to insert a row in between so it doesnt break the sequence and the other numbers / columns get updated accordingly?

    Example:

    Row 54 has the following: No.54 / Jack / DOB / Address
    Row 55 has the following: No.55 / Tom / DOB / Address

    When I insert between Row 54&55, that new row becomes 55 and row 55 becomes row 56.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: How to make my rows update automatically when inserting new ones?

    You can use the ROW or ROWS function to return the row number, instead of typing the row number yourself.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-05-2018
    Location
    Lexington, KY
    MS-Off Ver
    2007
    Posts
    28

    Re: How to make my rows update automatically when inserting new ones?

    If I understand correctly, you can do this a couple of ways.

    You can do it manually, after inserting whatever rows you want, select the top cell of the column, click and hold the black square in the lower right of the cell, and drag to the bottom of the data. Excel will automatically fix the sequencing.

    If you want to do it automatically with a formula, you first need the data to be in a named range or table, and use:

    Please Login or Register  to view this content.
    where the -1 is optional to however many rows your data is offset from the actual row number.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 15
    Last Post: 08-20-2016, 02:30 AM
  2. Update table Automatically by inserting into another
    By jmcconville18 in forum Excel General
    Replies: 1
    Last Post: 06-02-2014, 09:50 PM
  3. [SOLVED] Automatically update links in Excel 2003 after inserting rows in .
    By Peturpin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2006, 11:55 AM
  4. How can a formula in a cell automatically update when inserting a.
    By Peo Sjoblom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM

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