Automated Attendence

roy00a4

New Member
Joined
Mar 15, 2016
Messages
14
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?
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Watch MrExcel Video

Forum statistics

Threads
1,123,535
Messages
5,602,217
Members
414,513
Latest member
junbuggle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top