I have what is probably a simple question for someu, but not so simple for me. My unit has a total of 5 members who put weekly stats in an Excel worksheet.
At the end of the week those 5 sheets must be accumulated. This is done my manually adding them into a seperate worksheet that is identical to the sheet each member uses.
What is the easiest method of having this automated. Keep in mind these members work in the field and each has a laptop, but the laptop in not connected to the domain.
If it's possible I would like to place the master worksheet into a directory and configure it to pull data from each member's worksheet as it is dropped into the directory.
Is this possible?
At the end of the week those 5 sheets must be accumulated. This is done my manually adding them into a seperate worksheet that is identical to the sheet each member uses.
What is the easiest method of having this automated. Keep in mind these members work in the field and each has a laptop, but the laptop in not connected to the domain.
If it's possible I would like to place the master worksheet into a directory and configure it to pull data from each member's worksheet as it is dropped into the directory.
Is this possible?
