Automatically sorting columns of names alphabetically

[taffmorgan7274]

Good morrow,

I have a list of names that need to be added to/subtracted from on a regular basis. The list of names run into the 200's and the sheet is formatted so that the names fit on the length of an A4 sheet.

Is there any way that I can use a formula, table, device that will allow me to add or subtract a name and the columns would automatically be organised in alphabetical order?

Thank you

I couldn't upload an image as the file 12kb was to large.

 

[kevin9999]

Difficult without some data to work with - did you try using the XL2BB add in, or alternatively perhaps you could share your file via Google Drive, Dropbox or similar file sharing platform? (You could easily disguise the names).
Anyhow, I see you have 365 listed on your profile, so if you're willing to use a second sheet to return your values then the Sort() function combined with the Filter() function could work for you.
Otherwise, you're probably looking at a VBA solution based on a worksheet change event. With a formula approach, if your 'sheet1' looked like this:

Book1
	A	B
1	Surname	First Name
2	Baker	Alex
3	Smith	Bob
4	Adams	Sue
5	Johnson	Wendy
6	Johnson	Amy
7	Adams	Amy
8
Sheet1

Your second sheet could look like this (use the formula in A2 if you only need to sort by surname - use the formula in D2 if you need to sort by First then surname). When you add additional names to sheet1, they will automatically appear on sheet2 in alphabetical order.

Book1
	A	B	C	D	E
1	Surname	First Name		Surname	First Name
2	Adams	Sue		Adams	Amy
3	Adams	Amy		Adams	Sue
4	Baker	Alex		Baker	Alex
5	Johnson	Wendy		Johnson	Amy
6	Johnson	Amy		Johnson	Wendy
7	Smith	Bob		Smith	Bob
8
Sheet2

Cell Formulas
Range	Formula
A2:B7	A2	=SORT(FILTER(Sheet1!$A$2:$B$301,Sheet1!$A$2:$A$301<>""),1,1)
D2:E7	D2	=SORT(SORT(FILTER(Sheet1!$A$2:$B$301,Sheet1!$A$2:$A$301<>""),2,1),1,1)
Dynamic array formulas.