Syncing Excel Daily Task reports

[Rey721]

Hi
I am trying to see is there an easy way to create a process (I think), where all the Employes have the same form to fill daily and that this information to load into a master form without having to load one form individually.

 

[Rijnsent]

Hi Rey, welcome to the forum. Your question is a bit cryptic imho, but trying to answer it: I assume you want a solution in Excel? What you could do is make one "master workbook" that has external links to the excel workbooks of the individuals, where everyone has his/her own workbook in a pre-defined format. An alternative is to have a master-workbook that has some macros to import all the individual files when a macro is run.

 

[Rey721]

thank you I did as suggested and it working great thank you, and sorry for the late respond