Hi All
I am new to Mr. Excel and this is my first post. I have been following the forum for time now.
I have a question in regards to advanced excel. I am developing a automated system to generate a attendance report.
Here is the scenario :
1. There are 9 Team Managers, each will have a separate form in their name which are password protected and time bound.
2. These forms are in the shared drive of the company. So they can access each of their individual form and fill the attendance with in 1:30 PM to 4:30 PM of the same day and save.
3. I would have the access to all these forms.
What I want to do is collate these forms in one report with the same format and generate a report out of it.
Is there a way to do this?
Should I use Excel or Access for this?
I am new to Mr. Excel and this is my first post. I have been following the forum for time now.
I have a question in regards to advanced excel. I am developing a automated system to generate a attendance report.
Here is the scenario :
1. There are 9 Team Managers, each will have a separate form in their name which are password protected and time bound.
2. These forms are in the shared drive of the company. So they can access each of their individual form and fill the attendance with in 1:30 PM to 4:30 PM of the same day and save.
3. I would have the access to all these forms.
What I want to do is collate these forms in one report with the same format and generate a report out of it.
Is there a way to do this?
Should I use Excel or Access for this?
