Running macro when cell changes?

Hello! New to the forum!

I wanted to know if there is any way of making this macro run automatically whenever "G53:G60" changes?

I am new to macros and don't really know if I am doing this correctly.

Thanks in advance!

Please Login or Register  to view this content.

Hi, and welcome to the forum!

There sure is a way to do that. In the Worksheet module for the correct worksheet, just copy and paste this code:

Please Login or Register  to view this content.

An alternative (and probably cleaner way) would be:

Please Login or Register  to view this content.

I hope this helps

Hi ajryan88! Thank you for the quick response. Sorry I couldn't get back to you faster.

Anyway, I am so sorry for the troubles but I just cannot get it to work, I would greatly appreciate it if you could help me out. I will attach the worksheet I am working with. In the sheet "home" I want to sort the tables I have from biggest percentage to lowest percentage automatically when I input new data. Basically, sort column F with the percentage of column G.

rendimiento.xlsx

Thanks in advance once again.

Try this.

The code is in the Worksheet_Calculate event of the Home worksheet

Thank you so much! This is exactly what I needed!

You're welcome

Please don't forget to click on the * next to my post to say thanks and add to my reputation