VBA Sorting Rows automatically

Hi guys,

I am a VBA noob and have been looking for something that might suit for days.
Basically I d like excel to automatically sort all used rows in a spreadsheet according to the value in, let's say, column B. It contains names from RSVP address book.
Values can be numbers (from 1 to i.e. 4), cancelled, declined and no reply.
I d like to have last three categories of rows be moved below so that i can have first rows with numbers, then all the others.

I d appreciate your kind help in this

Cheers

reyearthnexus,

I have made a spreadsheet that will automatically sort by RSVP when something new is added or changed in column C. I am not sure what the numbers are for. If you have a spreadsheet that you can post I will be more than happy to apply it to yours so it works the way you want it to.


Simeon

Hi Simeon

it seems to work perfectly indeed! thanks!
Please find attached a screenshot of the spreadsheet where I am working on.
Could please really adapt your code to that ?
thank you so much
exampl.png

So I have put the code into the new format. Whenever you enter a new person be sure to input the RSVP number in last. That is what triggers the macro. Hope this works for you!


Simeon

That's great, thank you very much!
I got just one question: I was looking at the code for the parameter which drives the array affected by the macro. What if i want to make more columns be interested?
I expected to find something like Range(A1:G10)

Many tha

Thank you very much Simeon, it is great!!

I was wondering one last (promise) thing: is it possible to eventually add a condition in the target range, like (if entry <>""), so that it would be possible to add eventually blank rows that are effected by the macro only when I put something in the relative cell B. Does it make sense?
I dd like to offer you a massive beer for that if we werent that far