Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2015, 12:28 PM
Ruth East Ruth East is offline Insert data in alphabetic list without disturbing order. Windows 7 64bit Insert data in alphabetic list without disturbing order. Office 2000
Novice
Insert data in alphabetic list without disturbing order.
 
Join Date: Mar 2015
Posts: 2
Ruth East is on a distinguished road
Default Insert data in alphabetic list without disturbing order.

I have an alphabetic list of names & addresses in Excel and I want to insert a new entry. How can I insert this information and have the existing info "move down".
Reply With Quote
  #2  
Old 03-21-2015, 01:06 AM
gmayor's Avatar
gmayor gmayor is offline Insert data in alphabetic list without disturbing order. Windows 7 64bit Insert data in alphabetic list without disturbing order. Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Add the address to the end then sort the list.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 03-21-2015, 05:15 AM
Ruth East Ruth East is offline Insert data in alphabetic list without disturbing order. Windows 7 64bit Insert data in alphabetic list without disturbing order. Office 2000
Novice
Insert data in alphabetic list without disturbing order.
 
Join Date: Mar 2015
Posts: 2
Ruth East is on a distinguished road
Default Insert data in alphabetic list without disturbing order.

THANK YOU so much. You have just made my weekend
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting in alphabetic order Dimsok Word VBA 5 09-10-2014 02:58 AM
Insert data in alphabetic list without disturbing order. List Style Numbering picks up out of order number from LATER list spthomas Word 12 12-16-2013 05:23 PM
Insert data in alphabetic list without disturbing order. Resorting macros in alphabetic order? New Daddy Word VBA 1 02-06-2012 06:05 AM
How to sort word text in alphabetic order . crossing Word 8 01-20-2012 09:51 AM
Insert data in alphabetic list without disturbing order. Find in alphabetical order list 14spar15 Word 1 12-03-2011 03:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft