ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HR data Table (https://www.excelbanter.com/excel-discussion-misc-queries/140300-hr-data-table.html)

Will

HR data Table
 
Hi,

I am in a Human resource team and I have problem tablulate my teams' leave

Am I able to list down my teammates leave in details which day they on leave
in a different worksheets?

lets say:

one worksheets where my team will input their leaves date.

On another worksheets shows the summary of each teammates' date they on
leave. Something like tat.


Plum

HR data Table
 
Yes, you could have an input page where you enter the staff details and then
a worksheet which links to that and summarises the data.
If you give me your email address I can send you an example. (post it here
or email me via my website).
Regards,
--
www.plumsolutions.com.au.xxx
Specialists in Financial Modelling


"Will" wrote:

Hi,

I am in a Human resource team and I have problem tablulate my teams' leave

Am I able to list down my teammates leave in details which day they on leave
in a different worksheets?

lets say:

one worksheets where my team will input their leaves date.

On another worksheets shows the summary of each teammates' date they on
leave. Something like tat.


Will

HR data Table
 
Plum,

My email was

thks very much

"Plum" wrote:

Yes, you could have an input page where you enter the staff details and then
a worksheet which links to that and summarises the data.
If you give me your email address I can send you an example. (post it here
or email me via my website).
Regards,
--
www.plumsolutions.com.au.xxx
Specialists in Financial Modelling


"Will" wrote:

Hi,

I am in a Human resource team and I have problem tablulate my teams' leave

Am I able to list down my teammates leave in details which day they on leave
in a different worksheets?

lets say:

one worksheets where my team will input their leaves date.

On another worksheets shows the summary of each teammates' date they on
leave. Something like tat.



All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com