[Solved] Excel Template for employee uniform issues

[sanjfer]

I am the HR Manager of one company. I have around 100 employees. I want to create an Excel format for issuing staff uniforms. I want the following things in the template.
1. Total uniform purchased according to the sizes like L, M, XL etc..., date of purchase, qty. items like, a T-shirt, cargo pants, cap etc..
2. I want to add the names of the employees to whom issued the uniform and qty, date of issue and size
3. Finally, the remaining qty. how many is balance

Note: once the qty finished, again we will purchase a new qty so that also to be added

If you have a template for this, please share it with me. I am ready to pay for that.

Thanks.

 

[agongpor]

Hi sanjfer...

I'm Agung, a newbie in ExcelDemy.
I've tried to make a very simple basic template You may can use.
I'm sorry if it is too simple for Your needs.

Thanks in advance.

 

[Lutfor Rahman Shimanto]

Hi sanjfer...

I'm Agung, a newbie in ExcelDemy.
I've tried to make a very simple basic template You may can use.
I'm sorry if it is too simple for Your needs.

Thanks in advance.

Hello Agongpor

Welcome to ExcelDemy Forum! Thanks for your time and for sharing your expertise within the ExcelDemy community.

Though simple, we hope this template will reduce Sanjfer's difficulties. We thank you both (Agongpor & Sanjfer) for contributing to the ExcelDemy Forum.

Regards
ExcelDemy