Using the Change Event to sort data

[marreco]

Hi.

I'd like to use this code

Please Login or Register  to view this content.

With the Private Sub Worksheet_Change (ByVal Target As Range), as I do?

[arlu1201]

What do you mean? Your question is not very clear.

[marreco]

Sort the data in the range A2: D10, each time you change a value in the worksheet cell.

[arlu1201]

I tried the code in your 1st post and it works fine. What is the issue you are facing?

[marreco]

I'm a fool, I thought it does not work.
But it works!

How do I sort the code after I fill in the lines of each column in the range A2: D10?

Example.

I typed in A2, B2, C2, D2. after digitaar D2. oh yes the code classifies A2: D10.

I typed in A3, B3, C3, D3. after digitaar in D3. oh yes the code classifies A2: D10.

And so on!


Thank you!

[arlu1201]

You can specify a condition if D10 is to be your last cell of entry - code like

Please Login or Register  to view this content.

and then the sort code.

[marreco]

Look.

Imagine the range A1: D10 empty, and you have to fill it, from time to time.
In the range A2: D10.

the first line A2: D10 is A2: D2.

the second line A2: D10 is A3: D3.

the third line A2: D10 is A4: D4.

So if you type in the first row of A2: D10, only then sorts the data range A1: D10.

Now you 1st and 2nd row with data. After typing in the last cell (D3) of the 2nd line (A3: D3).
Only then sorts the data range A1: D10.

Now you 1st, 2nd and 3rd row with data. After typing in the last cell (D4) of the 3rd line (A3: D3).
Only then sorts the data range A1: D10.

[arlu1201]

Ok, so ideally the D column should be checked if its filled and then only the sort should be done right? Nothin should be triggered if A, B & C are filled and D is left empty?

[marreco]

yes, it is just that.
correct

[arlu1201]

Try this...there could be other ways of doing this, but this is just one way...

Please Login or Register  to view this content.

[marreco]

Very good!
this is amazing!
you know a lot of Excel and VBA.

Thank you.