Export columns based on alphabetical order

Hi rpetty,

I'd suggest to not put your master on separate sheets. You can do an AutoFilter on the master sheet and not duplicate your data. If you copy it to more places it becomes less useable for you. Leave it all in a single big table and make sure the info is correct there.

https://support.office.com/en-us/art...6-27B932E186E0

Look at "Begins With" on:
http://www.contextures.com/xlautofilter01.html

This is a customer is always right type reply, because I agree with Marvin that this is more complicated than need be.
This proposed solution employs an array entered formula* as well as variations on a regular formula.
There is a chance, pretty good depending on the number of employees, that you'll find some last names duplicated, therefore the following array entered formula will index the list of employee numbers, which I assume to be unique values:

Formula:

Please Login or Register  to view this content.

The basic formula that populates the rest of the information is:

Formula:

Please Login or Register  to view this content.

*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.

Best advice I could give is to make 23 more sheets, Label them and then copy from one of the existing sheets and paste to the new sheets.
Remember to change the letter in the array formula to match the sheet.
Also remember, after changing the letter, to simultaneously press the Ctrl, Shift and Enter keys before copying down.
Let us know if you have any questions.
(Please do not quote entire posts, if there is a question about a specific part just quote that part, however for in general quoting is not needed)

This may help a bit. I placed a formula in cell H1 that will display the sheet name. I then changed the array entered formula to reference cell H1. That means that you can make your 26 sheets, one for each letter of the alphabet, then copy the range of cells, A:H and as far down as needed, from your first sheet, presumably sheet A and paste to cell A1 of each subsequent sheet. If you do this changes to the array entered formula will not need to be made after each copy.
Note: Select to paste keeping column widths.
The formula for cell H1 is: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
Let us know if you have any questions.