Inserted table is causing Macro to fail

I have been working on this workbook for a long time with MUCH help from many of you. It is very close to what I need (as near as I can tell without using it for a full year) but upon adding in tables for sorting purposes everything starts to unravel.

In my example you will see that I input all data into the Sales sheet from which it then transfers to several other sheets based upon several criteria, the most important of which is the 'Day'. everything works great to this point. With much help the code was modified to allow me to input names into the 'Attended' columns of the Day Sheets (1Fri, 1Sat, 1Sun...ect.) which copies back into the Sales sheet so I can see who attended each show. Still works great.

Here is where it goes south. You will see that the Lord of the Rings gang chose to purchase tickets for the 1Fri show but silly old Tom Bombadil accidentally purchased his for the 1Sat. If you copy his ticket number into the Change page and rerun the code it causes the 1Fri page to get all weird...if you rerun it again things really start getting out of hand.

Now, the real reason for the Change page is because people are asked to choose a day for which they wish to attend each play, but we don't know the future so down the line when cousin Bob gets married and you realize that your show date is that day you can call box office and change your third play to a different date, so that is a very important part of this process.

Honestly the tables are not critical but they do make things substantially easier so if there is a good way to fix this I am in need

Thanks for all your help thus far and thanks in advance for any more I receive!

Tom

In the change page you have to enter Tom's ticket number in the C column then input 1Fri into G.

Sorry, that was not clear.

Tom

Any ideas on what would cause this? I thought that it was perhaps where the 'Table' started in relation to the code but upon modifying the code everything just started duplicating. I have changed the code back to the original so that it works without tables but I am still stumped.

Tom

Hi, I was wondering if anyone had a chance to look this over. I have tried everything I know and all I have been able to do is mess things up worse. :S

Tom

Is there some way that I can explain my problem a little better? I apologize if I have not been detailed enough.

Tom

Hi, can anyone tell me what is going on with this? I have studied the code but cannot tell what would make the table scramble.

Thanks
Tom

Hello Folks. I was just wondering if anyone had the opportunity to look into this. I have messed around with it but all I succeed in doing is really messing things up.

Thanks
Tom