Combo box & automatically update/display data from another sheet based on selection

[srmp07]

Dear All...Could anyone please help.
I have an excel sheet to track staff holidays, bank holidays, paid & unpaid holidays sick days etc (Sheet : Holidays).
Have another sheet (Sheet: personal) where I can see and print for each individual/Staff. Currently I am changing manually the details of each staff. I inserted a combo box which is linked to the staff names (A to Z) in sheet “Holidays” which I can presently scroll down to select the employee/staff name only.

1. Is there any possibility when I select a staff name from the scroll down option in combo box all the below details changes automatically based on the name selection (rather than me changing manually for each individual)??)

The holidays etc: are updated in sheet “Holidays” in long rows (as it’s related to date April 1st 2013 to 31st March 2014, starts from cell “M” and end in cell “NY”. So in sheet “personal” have made rows and columns to view this as a form of calendar (basically to view in one place/print). This is also linked/copied for each individual/staff from sheet “Holidays” each time when I print it.

2. Is there any possibility when I select a staff name from the scroll down option in combo box all the below calendar/consolidate cells change the value/copy automatically based on the data/text from sheet “holidays” corresponding to name selection??.
I have attached my sheet. Anyone please help..

Many thanks in advance

[Tinbendr]

Welcome to the board!

In Personal!Q4

Please Login or Register  to view this content.

I moved the linked cell to Q4, underneath the form control, as to hide it.

I don't understand #2. It seems your direct cell link already complies.

[srmp07]

Dear David,

Thank you!!!. Yes question #1, this was what exactly I was looking for.

Now question #2,
The rows and Colum below “financial year: 2013-2014” in sheet "personal" are updated/linked manually now based on staff name “A” in sheet "Holidays" (ie: copies contents from cells “M7” to cell “NY7” from sheet “Holidays”).

However if I select/change staff name to “B” in the combo box, the rows and Colum below “financial year: 2013-2014” remains unchanged.
I am looking for a way to change it automatically based on the staff name selection from combo box (ie: if I select the staff name to “B” in the combo box, the cells should automatically replace the contents from cells “M8” to cell “NY8” from sheet “Holidays” and so on... based on the name selection.


Sorry I did not made my question #2 clear in my earlier post.

Could you please help me with the above too.

Many thanks for your help.

Raj

[Tinbendr]

OK, I think I've got it. It's not very dynamic, meaning you'll have to reset all the ranges the next fiscal year.

If you would have 31 days for every month, even on those that do not have 31 days, then it's a simple matter of multiplication and the formulas will all be the same.

[srmp07]

Many thanks...you are a star*****
Exactly what I was looking for...
I really appreciate your help!!!

Raj

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.