Automate a Sort

  • Thread starter Thread starter Mikk
  • Start date Start date
M

Mikk

I have a worksheet with 10 fields and 100 records. I
would like to have a second worksheet that sorts this
data automatically. So when I enter data into worksheet
#1 the data will automatically sort in worksheet #2. Is
there a way to do this without macros or code?
 
Hi Mikk

Myrna is actually wrong, there is infact a way to do
this... what you need to do is the following. If you have
10 conditions you need to sort by then do the following

- start recording a macro
- highlight your 100 entries
- then go to sort and sort ONLY by the 10th condition in
which ever order you require (ie. ascending or descending)
and press OK
- go to sort again and then sort by the 7th, then 8th,
then 9th conditions in the order you require and press OK
- go to sort again and then sort by the 4th, then 5th,
then 6th conditions in the order you require and press OK
- lastly go to sort again and then sort by the 1st, then
2nd, then 3rd conditions in the order you require and
press OK
- stop recording the macro and assign it to a button and
you are done!

good luck

Nick



-----Original Message-----
Click to expand...
 
NICK said:
Myrna is actually wrong, there is infact a way to do
this...
Click to expand...

No, actually, Myrna's right. The OP specified that the second
worksheet must sort the data automatically...without macros or code.
She correctly told the OP that that couldn't be done. Your solution
requires a macro.
 
Thank you all for your suggestions.
-----Original Message-----


No, actually, Myrna's right. The OP specified that the second
worksheet must sort the data automatically...without macros or code.
She correctly told the OP that that couldn't be done. Your solution
requires a macro.
.
Click to expand...
 
Back
Top