Copying select cells via a button on to another sheet

[janger]

Hi All

This is a little bit beyond me and I require your expertise . I believe this will properly have to be VBA code.

On the attached workbook, the tab called 'book holiday' will allow the user to select department , employee names, start dates and finish dates and once all the information has been entered, the user click the button and it copies the information onto the relevant rota.

However, in cell H15 on the book holiday tab there are different types of day types to select, these relate to the information on the data sheet and the abbreviations. Its the abbreviations I want to use when copying the data from the book holiday tab to the relevant rota I.E GH , Days, Nights .

The start date is entered in H9 and finish date in H11 on the book holiday date, I not sure whether to enter the date manually or select from a drop down list.. your thoughts ?

I hope this makes sense.

Many Thanks In advance

[jolivanes]

I don't have an answer for you but you should get rid of the "Merge & Center" cells. They are an accident waiting to happen.
In your attachment it is simple enough to make your columns as wide as they need to be..

[jolivanes]

Is the attached a start?