dear friends,

I have an xls workbook with 100 worksheets, each named for one employee. All the worksheets have 5 similar tables with data. whilst the tables and headers are similar, the data varies from employee to employee. I wish to insert similar column charts besides each table - across all 100 worksheets. Is there a way of doing this at one go - ie without having to insert charts manually into each worksheet, beside each table?
While I can use 'ctrl' to change tables across all sheets simultaneously, same function is not active for 'insert - chart'. Please help.

yours