I inherited a large excel workbook, which has about 10 tabs each containing many charts. I new workbook is created for each customer by dumping data into it from access. Long story short, its seems like a big waste of time time to keep changing the new customer name on each chart. Has anyone done this in 2010? or in 2007 (assuming the code is close). Googling it results in downloading programs, seems like there was to be a simple way of doing this
-- ---------------------------------------------------------------------------------- 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