After change value auto sort

[Bennasy23]

Hello,

I have two tables with two user forms.

1 "Create order" user form is for blue table
2 " Add articlle" user form is for red table.

Problem 1:
So in blue table is order with status column. Status column, change when in column "Left made GKR" value <= 0.
It is possible then column status is "Start" auto sort up?

problem 2:

In red table : after fill form "add artivle" all new data sort up.

[PCI]

It is possible then column status is "Start" auto sort up?

How do you want to sort Status: A to Z , Z to A, how do you do it manually ?

[PCI]

See next code
in a module put

Please Login or Register  to view this content.

in the sheet's code

Please Login or Register  to view this content.

[Bennasy23]

Do i need change something in these code ?

[Bennasy23]

See next code
in a module put

Please Login or Register  to view this content.

in the sheet's code

Please Login or Register  to view this content.

I inser this code. But you can see what i get. Not all values sorted.

[PCI]

There is some difficulties with the file you sent: Cell protection
Can you point out what is not correct
How do you do it manually
Is it OK with the file sent: Project1.xlsm

[Bennasy23]

There is some difficulties with the file you sent: Cell protection
Can you point out what is not correct
How do you do it manually
Is it OK with the file sent: Project1.xlsm

Ok In table1 i would like that all orderst with status "start" would be on top.

In table two. all new rows would be on top.

My sent file pass "baldai"