Macros

[Sri Harsha]

Hi,

I have a resource utilization template that captures the time spent on
various tasks by my team. I want to know if it is possible that i have
another sheet, like a master sheet or something, and at the end of the month,
if the associates click submit in his/her sheet, i get the collated
information from that sheet.

Thanks and Regards,
Sri Harsha Kiran.P

 

[Patrick Molloy]

this sounds like quite a task, so no surprises in the lack of response.

Teh answer is yes, of course thats possible. There are many ways to achieve
this.
Using a template is probably the simplest method.

There's plenty of material on this ng covering pulling in files etc.