Address book with input fields and auto sort

[mmarsico84]

So I got a new job as a aide at a medical office. They have a number of Doctors that they need to fax, but their current address book is just a bunch of post it notes. I want to make an excel sheet, but want to make it easy for anyone to use.

I want someone to input a name and fax number then have it automatically add to the sheet and sort alphabetically. I can't use Access or any other database (company policies), so I'm thinking Excel with some well placed macros.

Any thoughts or templates out there? Thanks

[mrice]

Congratulations on the new job.

If you have two columns, name (A) and fax (B), try pasting the following into the appropriate sheet tab in the VBA editor Alt F11 (e.g. Sheet1)

Please Login or Register  to view this content.

The sheet will auto sort when both column A and B are complete.