Help reuired to make excel sheet for leave tracker

[shahzad074]

HI

i am just average in excel , my boss has requested to make a sheet for employees annual leave track, And i have tried last 7 days , but failed.
there should be separate tabs for each employee having detail for employee on top and below different column with leave request date , leave start and end date approve date and approve by, and reaming balance from his leaves.
+ 1 summary sheet showing all employees leave requests.

problem is how to make summary sheet from all these separate tabs , or i should work on summary sheet and it will extract data to separate tabs.

one more thing very important , at same time only one employee can take the leave, if we receive request with in same dates when other employee is on leave it should give error......

Thanks if you can help me in any way to save my job...

 

[ranman256]

this is hard to do in Excel.
You want a database. (which Access is perfect for this) It can keep track if individuals, the time off and can compute the intersection of 2 people wanting the same dates.
Learn Access. Its a great tool.

 

[ranman256]

send me an email, and I'll send you an example database.

 

[Declamatory]

Hi,

You can have one I made. It's not fancy though. You just need to change the tab names then highlight the contents of each person's tab and ctrlH and replace the current name with the name you want.

I'm not sure how to attach it to a reply though.