hi forum

I always get help on this forum!
my biggest problem is to try to explain what i'm trying to achieve!

The story
i have this rotation of jobs sheet and everyday i have about 8 people on holiday
so i have to find them in the sheet copy and paste in between cells
worksheet (ex11.5) .range ("B42:B52").


my problem today is that I have created a combo box in one of my sheets of my workbook,

what i need now is some code ,so every time i make a selection on the combo box this code will find on (sheet (ex11.5)and sheet (A LINE) within certain range where is the value.

once find the value return it to sheet(EX11.5) .RANGE("B42:B52")
once the value found and appended to new Range clear contents.


i have appended a copy of my workbook . many thanks !
and sorry about my mistakes in grammar because English is not my first language





Copy of EX DAYS DEBONE ROTATION SHEET(this one).xls