Hi,

I need to find away to make a sandard template that create generate pivot tables and charts based on the results that are inputted in. So........

I have a spreadsheet with a specified header row that you can input various numbers based on external findings. Now some of the cells can be left blank, so I have set up a formula in another spread sheet to extract all the cells in the first spreadsheet that have values in them and to input a “0” where the cells are blank.

I have made a pivot table and chart based on the analysis that I need in a a third shreadsheet. However, I want this worksheet to be used as template so that on a daily basis when various numbers are inputted in the first spreadsheet, the pivot tables and charts will be automatically genterated.

Can this be done and if NOT, is there another way I can set up this template.

Thanks in advance to any one who can offer some help.

Calli