Exel Template wizard
 

Hey everyone,
I am having trouble with the Exel Template wizard. I have a fairl compex
spreadsheet that i want to use weekly to input data into, which the equations
in the sheet caculate other information. the problem i have is i want to
store the results of the calculations cumulatively so that the data at the
end of the month shows the combined result. I hoped that the template wizard
would help me do this but i cant figure out how to do it. Can anyone help?

Thanks,
Alan

Exel Template wizard
 

I think you would need to setup some 3D references and link workbooks. Maybe
someone else can offer another suggestion. Is there a Master template and
then others will have the same template but input data? If so linking is good
for that.


"Alan" wrote:

Hey everyone,
I am having trouble with the Exel Template wizard. I have a fairl compex
spreadsheet that i want to use weekly to input data into, which the equations
in the sheet caculate other information. the problem i have is i want to
store the results of the calculations cumulatively so that the data at the
end of the month shows the combined result. I hoped that the template wizard
would help me do this but i cant figure out how to do it. Can anyone help?

Thanks,
Alan

Exel Template wizard
 

I Have a workbook with 5 sheets and every day our employees time and sales
along with other info is entered. I have columns for M,Tu,W,Th,F,Sa,Su, and a
cumulative of those. each time the data is entered it is saved and at the end
of the week each sheet for each emloyee is printed and filed. then the sheets
must be delete item by item so the info for the next week can be entered. but
after a month of doing this i still must manually caculate the cumulative
info for the month. I want to be able to store the info some way so that i
can get a cumulative result of about 10 calculations for each employee at the
end of the month, quarter, and year. do you think i can do that with excel?

Thanks again,
Alan

"sp3cialist" wrote:

I think you would need to setup some 3D references and link workbooks. Maybe
someone else can offer another suggestion. Is there a Master template and
then others will have the same template but input data? If so linking is good
for that.


"Alan" wrote:

Hey everyone,
I am having trouble with the Exel Template wizard. I have a fairl compex
spreadsheet that i want to use weekly to input data into, which the equations
in the sheet caculate other information. the problem i have is i want to
store the results of the calculations cumulatively so that the data at the
end of the month shows the combined result. I hoped that the template wizard
would help me do this but i cant figure out how to do it. Can anyone help?

Thanks,
Alan