Creating a Annual Leave tracker spreadsheet

**char12** · 10-25-2012, 06:02 AM

Hi, Im new here.

I need to create a Annual Leave tracker spreadsheet.

Can anyone help me?

I need columns for
Annual Leave - 1 day
Annual leave - 0.5 day
Sick Leave
Unpaid Leave
Special leave

**dilipandey** · 10-25-2012, 07:02 AM

Hi Char12,

Welcome to the forum.

It will be helpful if you could provide more details.. may be a sample workbook.. . thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**JoCraig** · 11-02-2012, 10:28 PM

Hi there

I too am new to this forum so sorry if this is answered elsewhere.

I have created a spreadsheet already, but it needs tweaking.

I have added filters and I click these to select the facility the employee works at so I'm not looking at hundreds of rows. Is there a way I can click the Filter and then that Filter (name only) appears at the Top, ie. in a Header or something like that?

Also, and the above is just on one Tab, I have created other tabs for the facility the employee works at. Is there a way that when I add the Leave dates, that this populates across into those Tabs, ie. kinda like a Gantt Chart.

Any advice you could give would be appreciated.

Thanks, Jo.

**dilipandey** · 11-06-2012, 02:52 PM

Hi JoCraig,

Welcome to the forum.

Suggest you to not to post under another person's thread.. rather start your own thread.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>