Change Event Multiple Sheets

**ckirkwalsh** · 03-18-2011, 11:41 AM

I have a workbook with functioning VBA to auto sort based on a change event in column 1 (thanks protonLeah!).

BUT, I realize that I actually don't want to sort based on a column that I will actually be inputting.

Column 1 is going to come from another sheet (labeled Master in the example attached). But I want to sort when it is changed in the destination sheet (position 1).

I appreciate any help you have to offer!

**royUK** · 03-18-2011, 11:56 AM

I'm not clear what you want to sort.

I've tidied th code up a little to make it easier to follow and avoid selecting

Please Login or Register  to view this content.

**ckirkwalsh** · 03-18-2011, 01:46 PM

Thanks Roy-
I'm going to be changing the "1"s in Column 1 on the Master page to "0"s.
I want that to change various other "1"s on other sheets (in column 1 on sheet Position 1, for example, but there will be multiple other sheets).
Then I want that those other sheets to be sorted automatically when the "1" changes to "0."