Ok kewl,

Thanks for posting this. So just to clarify do you want the After sheet to look exactly as your sample book, or do you just need column T updated? If you want it to look just like the after sheet it will take a little bit more time but it will get done.