Auto Sort Macro Based on Two Columns

**Zabalba** · 08-14-2012, 05:35 PM

Hear me out. I spent the better part of my day trying to figure out how to get the all the different variations of the possible solution in question. On this site and others. My brain is basically mush at this point. For some reason I can not get the macro to work on it's own. I would tell you which macro I used but it must have been close to 10 different kinds. The only one I was able to get working, you needed to hit play in order to get it to sort.

Basically I was looking to have the data in tab "programmer 01" column K automatically sort based on its value as soon as a value is entered in column J. Column J is the input for a vlookup in column K. After it sorts on K I need it to then sort on column A. And of course the the hope is I can get this sort as soon as a value is entered in J.

I've attached a sample of the sheet. Hope someone can help me because I'm stumped atm.

**protonLeah** · 08-14-2012, 06:06 PM

Title changed as requested.

**Zabalba** · 08-14-2012, 06:24 PM

Thread title was updated. Apologies for not reading the rules. Did I at least post this in the right section?

**protonLeah** · 08-15-2012, 12:42 AM

Why do you have the worksheet change event in a standard module instead of the sheet module where it belongs?

**Zabalba** · 08-15-2012, 08:40 AM

Originally Posted by protonLeah

Why do you have the worksheet change event in a standard module instead of the sheet module where it belongs?

When I was attempting to get the macro to work I would right click on the tab and view code. That is where I was placing the code. Is this the incorrect place?

**Zabalba** · 08-15-2012, 12:47 PM

small bump

**Pichingualas** · 08-15-2012, 01:44 PM

Event macros, which are automatically triggered when an event happens, have to go on the standard module which refers to the object where the event is supposed to happen. Your event macro is a worksheet change one, so it needs to be placed on the worksheet module it refers to, meaning when you open to view code you need to paste it on "Sheet2 (PROGRAMMER_01)" (double click on that on the left menu).

**Pichingualas** · 08-15-2012, 01:53 PM

You can see how on here.

**Zabalba** · 08-22-2012, 12:04 PM

Originally Posted by Pichingualas

You can see how on here.

Thank you protonLeah, and Pichingualas for your replies. I have not had a chance to come back to this project since I was swamped with my normal duties. I moved the code into the specific sheets and the automatic sorting works like a charm. I just picked up Excel VBA for Dummies. I hope I learn much more from that and give back to the forum as you guys did.

Thanks again!