Hi Ashish, You are the man!!! This works great! After I had a backup get posted to the wrong location while updating a computer in the shop, our operators suddenly started complaining that thier tables were wrong that they had been manually updating each time they saved thier work. This will allow me to recreate thier tables without manually searching through a couple of thausand files one at a time. Thanks Again John
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel