Record ID

[billgyrotech]

I have a 'Customers' worksheet that has assigned ID numbers for each customer in column 'A'. These ID numbers are used on the Invoice worksheets to fill in the customer information. My question is once these are assigned to that customer can they remain with them even after sorting the records? I have had issues with duplicate entries with customers is why I am asking.

If that is possible then could the 'Last NM' column be automatically sorted from A to Z when adding new records (customers)?

This seems to be a tricky issue for me so I appreciate the step in the right direction.

Any suggestions for my format is appreciated also.

[Richard Buttrey]

Hi,

It's not clear which of your macros 'adds new records'. But wherever it is the answer is Yes. Have you tried recording a macro to sort by last name. That will give you the guts of the code required which can then be modified and generalised as necessary.

[billgyrotech]

I do not have a macro to add new customer records yet. That would be a better way though. I have not tried any macros to sort by last name yet.

[billgyrotech]

Okay this has me thinking now. Perhaps what I need is a macro that will lookup if the customer exists and if not add new row in 'Customers' worksheet.

Not sure what lookup to have since there could be multiple customers with the same last names.

Either way I do really appreciate the help thank you in advance.