How to shift cells down with new entry in sorted list

[robert41]

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

[patel45]

attach a sample file for testing

[kvsrinivasamurthy]

This problem arises only column A is selected and sorted.
Dont select the column , insted select any cell within the data range and sort on column A.
You will get desired result.

[robert41]

attach a sample file for testing

Thanks for your reply. Here is a sample file: Attachment 185911 . Hidden Columns A to H of the "Customer Record" worksheet auto sorts and remove duplicates from the customer names in the "Loan Record" worksheet. You can see what happens in the Customer record worksheet if you type "Bob" or "Dan" in the Loan record worksheet. Is there a macro/vba that can fix this?

[patel45]

You attached a file with Hidden Columns, how can I understand how it works ?

[robert41]

Thanks again patel45, here is the file with all columns unhidden: Attachment 185989

[jindon]

Is this what you wanted?

[robert41]

Is this what you wanted?

YES!!! THIS IS WHAT I NEEEDED!!!! THANK YOU VERY MUCH! And your code was so elegant and simple...THANKS AGAIN!

[jindon]

Thanks for the feedback and please mark this thread as "SOLVED".