Need help to sort my sheet automatically

[RAFI]

Hi all,

hope you are doing well.
i am sharing one thing here but dont know is it possible or not.
i have a worksheet and i have to sort it manually all the time.
so its painful sometimes.
now what i m trying to do is, is there any scope in excel that i will give a criteria and based on that excel will automatically sort my rows based on my criteria??
i have have attached a file for your convenience.
i want to sort it based on dyeing status like first knitting balance,dyeing balance etc.
is it possible,whenever i add a new row,based on dyeing status of that row,it will be placed below that row
__________________________________________________________________

Mod edit : thread moved to appropriate forum !​

 

[vletm]

Could this help Your pain?
It works then number of rows will change ...

 

[RAFI]

I have entered a new row whose status is "knitting balance".
nothing happened..
could you pls explain a lil bit???

 

[vletm]

Yes. It seems that 'table' has one challenge...
but not it works better
... it will check number of rows
after You have changed/filled 'DYEING STATUS'
if number of rows is different than before
then 'table' will SORT as You wanted.

 

[RAFI]

DO i have to refresh it or somethin like that after inserting a new column???
still not working...

 

[vletm]

Inserting new column, so far You have written about inserting new rows ...
Send Your file which You use here.

 

[RAFI]

extremely sorry.
its actually row, not column.
i inserted a new row but nothing happened..

 

[RAFI]

Its really great....
works completely good..
could you explain a little bit how you just did it..
but one thing,if i add a row below the last row it doesn't work immediately;when i add another row between 1st and last row then both changes simultaneously...but even though its really awesome..
could you just elaborate..

thanks

 

[vletm]

Eleborate as #4
it will check number of rows
after You have changed/filled 'DYEING STATUS'
if number of rows is different than before
then 'table' will SORT as You wanted.
'Sorting' won't give any message ... it just sort!
Sometimes after 'sorting' view could be same than before sorting.
(as above the key is 'DYEING STATUS'-column's number of rows have to change)
If You need any message/note after 'sorting' .. it's possible to do too.

 

[RAFI]

thanks for your feedback..
it was really awesome..
did you use macro or something???
as my excel skill is poor() i want to learn the trick..
is it possible???

 

[vletm]

Tools -> Marco -> Visual Basic Editor => Right side - double click 'Sheet1 ...'
=> You will see 'something'.

 

[RAFI]

TOOLS OPTION is not in my ribbon..

 

[YasserKhalil]

Tools option is in old versions .. You will have to get Developer tab

 

[vletm]

No matter of Your ribbon.
You should try to find MACROS someway!