Worksheet which summaries staff used leave and calculates reaming leave allocation, all values summarised on new sheet [sheet
name “SummaryLeaveSheet” ]
I would like help creating a method, formula or VB code which can
look through 12 worksheets [named “LARSheet1” to “LARSheet2” ]; find an employee’s pay number on a row (say B25) and return a
count of each attendance (“a”); lateness (“L”); holiday (“am or pm”) or Sickness (“S”) record on that row. The row may change
on different worksheets but the search method can always use (B25) as a starting point.
With the found values, I
would like a total count to be returned on a summary worksheet [“SummaryLeaveSheet”]
I would also like to list the
dates each leave was recorded on the various worksheets [i.e “LARSheet1” to “LARSheet2” ] in a table.
summery sheet could be used for all employees, the information would update and change based upon a pay number located in a
cell linked to a ‘data validation’ drop down list.
Tall order I know….. Any help out there???
Example of layout of [“LARSheet1”]
====== ======== ====== ============= ========== ============ ============ ===== ========= =======
This is a multi-part project which is collectively known as “Leave, Attendance Management” system using Excel”. . Other
parts are found on other treads. I hope to link the thread solutions together so others who wish to do a similar task can
hopefully learn from help I receive (and my mistakes).
The other parts of the system are:
attendance record’ worksheets (i.e months April 2012 through to March 2013). [I will refer to these sheets as
"LARSheet1" to "LARSheet12"]. http://www.excelforum.com/excel-gene...-each-day.html
validation’ worksheet which holds list and vlook-up info for formulas. [I will refer to these sheet “FormulaListSheet”
‘Database’ worksheet acting as a of staff details database. [ “StaffdBaseSheet”].
leave’ page (this thread) which shows a summary of staff used leave and calculates reaming leave allocation. [