Layout/Sorting of Spreadsheet

**Karen615** · 10-30-2012, 10:14 AM

Using Excel 2007
I have a spreadsheet that has a list of ~ 300 customers that I want to keep in alphabetical order.
Currently the list is split up into 3 columns on 2 pages with A-M on page one and N-Z on page two. The problem with this is that, when I have to add a new customer, I have to shift everything around. Is there a way to have all the customers in column A so it's easier to add a new customer and then be able to sort and then have it print on 2 pages and 3 columns? Not sure the best way to do this.
Your help is GREATLY appreciated.
Karen

**Pete_UK** · 10-30-2012, 10:33 AM

Take a look at this thread from a few days ago:

http://www.excelforum.com/excel-form...html?p=2956449

It shows how you can take those names in column A and put them into 3 columns, so, Yes, you could put them all in one sheet.

Hope this helps.

Pete

**Karen615** · 10-30-2012, 11:06 AM

Take a look at this thread from a few days ago:

Thank you very much! I'll check this out a little later and see if it works for me.
Thank you again!
Karen

**Karen615** · 10-30-2012, 12:50 PM

Thanks Pete!

This is an excellent solution! Although, how would I modify the formula if I have the headings in:
A2: Customer
B2: Discount
C2: Amount

The first cells of data in:
A3, B3, C3

I would want the 3 columns of data to be ABC, EFG, IJK

Thanks again for your help!

**Pete_UK** · 10-30-2012, 05:14 PM

Hi Karen,

I've set this up in the attached workbook so that you can just copy your data into columns A, B and C, and then just copy the formulae in columns E to O down as far as you need them (until you get zeros.

Hope this helps.

Pete

**Karen615** · 10-31-2012, 10:03 PM

Pete,

This is great! Thank you so much for doing this for me. You have helped me tremendously!

Is it best to hide columns A:C?
If you have time, it's not necessary since you were so kind to set this up for me, but would you explain the formula in layman's terms?

Thank you again Pete!

Karen