Hi,
I managed to make an excel work book with buttons to create multiple copies of a template.
Eg. A sheet (Template) call TIPT is copied and renamed number of times as required.
If No sites is 5, then I managed to make new sheets TIPT_Site1, TIPT_Site2 ..... TIPT_Site5
what i now want to do is make calculations using data in each sheet.
I again have a template call Bandwith Calculation. Its using the data from each TIPT site.
S0, when a new site is created say TIPT site 1, I want to make a copy of Bandwith_Calc_1 and it should automaticaly select data from only TIPT site 1, If TIPT site 2 is made, make a copy of Bandwit_Calc_2 and it should use data from TIPT Site2,
Any help is much appriciated
Thankyou
Bookmarks