Results 1 to 9 of 9

How to shift cells down with new entry in sorted list

Threaded View

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    11

    How to shift cells down with new entry in sorted list

    Hi everyone. I have a list of customer names that auto updates with new names from another worksheet and auto sorts in column A. The customer's address are in column B and telephone numbers are in column C as follows:


    Don DonAddress Telephone1
    Sam SamAddress Telephone2
    Zadie ZadieAddres Telephone3

    But when column A inserts a new name and updates, the rows below the new name in columns B and C does not shift down and the data becomes misaligned from left to right as shown below:

    Don DonAddress Telephone1
    Fred SamAddress Telephone2
    Sam ZadieAddres Telephone3
    Zadie

    Any VBA/macro ideas as to how to automatically shift the data down in column B and C leaving blank, formatted cells beside the new name as shown below?

    Don DonAddress Telephone1
    Fred
    Sam SamAddress Telephone2
    Zadie ZadieAddres Telephone3
    Last edited by robert41; 10-09-2012 at 06:50 PM.

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