Sorting after my worksheet has input I want to save

  • Thread starter Thread starter suzie
  • Start date Start date
S

suzie

(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
 
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.
 
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
 
Back
Top