-
I'm afraid this is not as simple as it seems. The worksheet change code works when a cell is changed and you would need to select each sheet then select a cell and then change something to make the code fire. I'm sure this can be done but it will take me some time. Maybe someone sharper will come along in the meantime.
I would suggest you look at the last file I uploaded and try to figure out what you want it to do as you seem intent on changing the criteria once the sheet is set up. If you set it up correctly and don't change the criteria there would be no problems. Its only if/when you change the criteria that it messes it up right?
-
JustinDevine has pm'd me to help him with this code.....I am facing a deadline and have no time to spare and this is a little more complicated for his needs than I originally anticipated.
Bumping this thread hoping for someone to take a look at it with us.
-
Thanks
Yeah, I am definitely counting on changing them. Working with "clients" and I am sure they will. Who knows when... but I am sure.
