Hi ,
We have one existing template and each time user select one cost centers and sending data to data base .
We have 50 cost centers and and single owner for all cost center .
User will select cost center and time and version from CV .
We have nearly 100 rows and each row has separate calculation in this template .
Ex:
GL1 .----
read last year revenue * escalation factor for selected cost center (each cost center has separate escalation factor enter by user in another template ) ..........up to 12 periods .
Now user wants single run for all cost centers with out select each time one cost center and send .
Through script logic it possible but if user wants to change formula frequently , then excel formula is better .
Pls let me know any suggestions run template for all cost centers with single click with out script logic .
regards,
PSR