Hi guys! I need some help with my template. I have a problem with my template, you may take a look on the attached file, spclab.xlsx. Every time I copy the first sheet and make a new one on a new sheet, all the values in the chart would still refer to the first sheet being copied. So I have to edit again the source data and it's just too tedious for me especially that I'm gathering lab data every day. Now to make my work easier, I want to make my template "smarter" by placing a macro Action Button to be placed in cell Q2, so clicking it will automatically copy the entire sheet, the formulas and formatting, etc. and be pasted on a new sheet in the same file only AND with the charts referring only to the data in the new sheet. Can anyone help me on this? Please... A big thanks in advance..

James...