Get data in one sheet

[anto1510]

Hi All,
I have attached a sample work sheet.In the sheet Leave tracker i update employees leave or off request.
in the sheet Agent wise Leave or Off Tracker i want to get the values agent wise.
Once the auditor enter the agent id he should know the type of request employee maid for the mentioned periods and all the dates of leaves or offs.
the one highlighted in yellow is the field the auditor need to enter and the cells highlighted in green should be the output.
showed sample output.
Thanks in advance

[TWent]

I am having trouble deciphering the outcome you are looking for. Please try to better explain what the outcome of the issue should be. Also the sample helped a ton and I was able to sort out what you are explaining somewhat.

Thanks.

[anto1510]

sheet Leave tracker has all the data of leaves and offs request and in the sheet Agent wise Leave or Off Tracker. i should be able to find out id wise no of days agent applied for leaves and the dates he applied for leaves.

[mahju]

Hi

This may be solution

Try this
Enter AgebtID, From date, to date and Request type to see the respective dates. and count.

I have used some midterm calculation in sheet1.


You can use file on monthly basis or Yearly or even 10 Yearly as you like.

Copy the forlulae down as needed in all the sheet


Ask if any query


Regards

[anto1510]

Thank you.

[mahju]

You are welcome

One thing i want to mention that i forgot

This method can calculate up to 20 entries per agent i.e there should be max 20 entries of an agent in the given range in the leave tracker sheet.
e.g no. of entries of agent ID 101 is 2 in May 2011
So i suggest you go monthly

Regards