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

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 S." wrote:

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?

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

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


On Wed, 3 Feb 2010 12:47:02 -0800, trip_to_tokyo
wrote:

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 S." wrote:

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?