Use insert to move cell data.

[Alf Hill]

I have a table of addresses. 5 columns for address
divided by narrow blank columns and 13 rows also divided
by narrow blank rows.
This is to suit standard A4 adhesive address label
sheets. Total addresses per page = 65.
I wish to add(insert) or delete an address as updates
arise to keep surnames in alphabetical order.
I cannot find how to move existing data along and down to
leave empty spaces for the new address or how to delete
data in a cell and have the addresses move back
automatically so there are no empty spaces.
I do not want to move cells but to insert new text so all
existing addresses move along one address space.(ie 1
narrow empty cell and 1 address cell.

There must be an automatic method because this is what
computers should do but I could not find it in help??

Alf

 

[Anne Troy]

Alf: You would be far better off placing all names in one column, all
addresses in another, and so on, and then use a Word mail merge to create
the labels:
http://www.theofficeexperts.com/word.htm#MailMerge

**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************

 

[Suzanne S. Barnhill]

Where you should be managing the data is in a data source from which you can
create new label sets as needed using a mail merge. For more, see these
articles:

How to create a Mail merge
http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

Creating a mail merge Data Source
http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

 

[achyam]

Where you should be managing the data is in a data source from which you can
create new label sets as needed using a mail merge. For more, see these
articles:

How to create a Mail merge
http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

Creating a mail merge Data Source
http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm




Thanks everybody.

I have written to microsoft suggesting one simple command is needed so the
computer does all these tedious tasks.
Alf