sorting products

Hello
Im currently making a list of products. I've been manually sorting the products per price, weight and product name but after a few days this was getting very click sensitive and takes to much time. I was wondering if someone here could help me out?

Here is what I have. see picture below
product niet gesorteerd.png

I want excel to sort this automatically like this:
as you can see it sorted the products and removed those AH ba-na-as etc.
just to clarify Those number "125 g" "225 g" "600 g" etc are the weights of te product and the numbers eg "4.00" "2.00" "2.89"etc are the price.
product gesorteerd.png


To be honest I dont mind If you did something like this as I can delete those "AH product" names in column A (picture below) by myself.
Please do what is easier.
product gesorteed 2.png

It would really speed up and help me a ton if someone could create some macro for this

Please Login or Register  to view this content.

Try this Macro:

If you do not know how. Then follow these instructions.

Select the Developer tab and click on record Macro.
Click on Cell A1.
Click on Stop Recorder.

Click on Macros, Select your Macro, possibly Macro1, and select edit.

Delete your macro and replace it with this code:-

Close the Macro Module.

Select the Developer Tab, Click on Macros

Select the Macro and click on run.

Please Login or Register  to view this content.

hey thanks for the post. Ive been ill for a few days so I havent tested it out yet but ill let you know,

I already thought of paying a small amount (I aint rich but at least something than nothing) but I didn't add it on purpose just to avoid mass replies. Please be patient as Im very busy at the moment.
reply back so I know you've seen this comment. I wont charge back or refund.

Edit, send me a private messsage

Get well soon. I am happy to help you with this. So take your time in testing it.