Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transfering data in another column entering more sorted data
I have an Excel spreadsheet containing cities and regions, sorted by
alphabetical order into 6 columns. I am trying to keep the layout to fit on a LEGAL paper. I am wondering if a function exists to enter new data *which will also be sorted out alphabetically* into the worksheet, without breaking the eveness of the columns. I would like the spreadsheet to automatically transfer the last city/region onto the top next column, and so on until the last column. Is it possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to keep column headings from being sorted with data? | New Users to Excel | |||
Transfering data from worksheet to another | Excel Discussion (Misc queries) | |||
how to move the cursor to column A after entering data column F | New Users to Excel | |||
How do you Stop Entering Duplicate Data in a Column? | Excel Worksheet Functions | |||
How attach data in a row so it can be sorted by the date column? | Excel Discussion (Misc queries) |