auto populating multiple sheets with 1 data sheet

Hello everyone!

I apologize for attempting to ask this question again and I believe this query is already been answered. But as I tried using them it does not fit to what I need.

I have this work sheet of leave database records consist of multiple worksheets. Each month is accrued by an employee with a 1.25 per month or a total of 15 per year for the category of leave type sick leave and vacation leave. And for the emergency/special leave for the 1st 4 months, the accrued leave is .5 day per month and for the 5th month to 12th month leave accruals will be 1 day per month. So far what I have done is the drop down list. Am using excel 2007.

Hope someone could help me with this.

Any help and advise is appreciated.

Hi Gerard

I see what you have, but do not know what you are trying to achieve.

If you could explain further, perhaps with an example of what you are expecting, someone will be able to assist you.

Regards
Alastair