Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting after my worksheet has input I want to save
(part 1) I have a simple worksheet. I want to sort just one column the very
1st column, but the info to the right are addresses and such that need to stay with the correct input on the right? It's miss placed when I sort. (part 2) After I find a way to sort what has already been input, how can I keep my spreadsheet to sort with out doing it everytime I input. Thank you! Suzie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting after my worksheet has input I want to save
Part 1:
Select all of your data before sorting, and use the Data - Sort command. Select appropriate column. Part 2: While this is *technically* feasible using a worksheet_Change event (VBA) I'd recommend against it. Otherwise, if you mistyped and left the cell, BAM! there goes your data, and you have to search for it. It's much easier to just input all your data and sort when you're down, IMO. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "suzie" wrote: (part 1) I have a simple worksheet. I want to sort just one column the very 1st column, but the info to the right are addresses and such that need to stay with the correct input on the right? It's miss placed when I sort. (part 2) After I find a way to sort what has already been input, how can I keep my spreadsheet to sort with out doing it everytime I input. Thank you! Suzie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting after my worksheet has input I want to save
hi
1. select ALL the columns when you sort and use the first column as the primary sort key. 2. you will need to sort each time you enter data. but you can make it easy by recording a macro and perhaps assing the macro to button on a tool bar. that way the sort would be just a button click. regards FSt1 "suzie" wrote: (part 1) I have a simple worksheet. I want to sort just one column the very 1st column, but the info to the right are addresses and such that need to stay with the correct input on the right? It's miss placed when I sort. (part 2) After I find a way to sort what has already been input, how can I keep my spreadsheet to sort with out doing it everytime I input. Thank you! Suzie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to save as a data input by user file name from a designated | Excel Discussion (Misc queries) | |||
Require mandatory info input in order for Exel to save changes. | Excel Worksheet Functions | |||
Input original save date | Excel Discussion (Misc queries) | |||
Disallow File Save if No Input in Cells? | Excel Discussion (Misc queries) | |||
Worksheet Buttons (Save, Save As, Cut, Paste, etc.) Not Working | Excel Worksheet Functions |