"auto sorting"

[roboteacher]

I've tried the VB for my auto sort but I guess I'm making mistakes somewhere. Any help would be appreciated.

I would like to sort col a, b, c in decending order using col b as my data entry col. I only want to sort the 3 columns to row 6.

Thanks

[Richard Buttrey]

I wasn't sure what you meant by col b as the data entry column, but try the following:

Please Login or Register  to view this content.

HTH

[roboteacher]

A B C
1 NAME VALUE RELATIVE FREQ
2 poop 90 60%
3 listening 30 20%
4 spelling 10 7%
5 broken 10 7%
6 other 10 7%

what i'd like to do is auto sort as the value under column B changes and I would like to sort columns A, B and C only down to row 6

Thanks

[shg]

Maybe like this.

Please Login or Register  to view this content.

Code goes in the Sheet module:

Adding Code to a Sheet module
1. Copy the code from the post
2. Right-click on the tab for the relevant sheet and select View Code. This opens the Visual Basic Editor (VBE) and shows the module for the selected worksheet.
3. Paste the code in the window
4. Close the VBE and return to Excel

[roboteacher]

It works great!

Thanks soooo much

[shg]

You're welcome.

Richard would have given you about the same answer -- please try to make your questions clear and complete. Thanks.