How do I enter new data alphabetically into a workbook w/o scroll.

  • Thread starter Thread starter Jillian S.
  • Start date Start date
J

Jillian S.

I have a list of information and periodically I have to add information into
this list. The easiest way I found so far to do this is by scrolling through
the list of information I have and finding the person I need to add to and
inserting a new line. Is there a form that can be easily built that inserts
information into its spot alphabetically?
 
Hi Jillian:-

Please check out:-

http://www.pierrefondes.com/

- item number 42 (done in EXCEL 2007).

This won't add it alphabetically but it does present you with an easy way to
get data into a Workbook.

If there is anything you don't understand either email me or post back.

Please hit Yes if my comments have helped.

Thanks.
 
Jillian

If your list is in one column...............

Insert a row anywhere, enter your new item then sort that column.


Gord Dibben MS Excel MVP
 
Back
Top