First of all I would like to give a huge shout out to natefarm who created this awesome code for me and tweaked several of my formulas as well. I would also like to thank those who had a part in building this worksheet even though you may not have known it.
Now, if you look at the posted workbook you will see that everything in column M matches a colored tab; this allows the code to transfer the 'show days' to the appropriate pages. My problem is that you can clearly see Merry ordered his ticket for the wrong day and now will be viewing the show by himself. In the 'Changes' tab I have made a note of that but in order for me to make sure that he gets to enjoy the evening with his friends I must then manually change it on the actual 1Fri page. This is not a problem except when I rerun the macro it will force him back to 2Fri.
So, is there a way to modify the code taking into account the 'Changes' page?
Cheers
Tom
Bookmarks