Create a new workbook from a template worksheet using information from main workbook.

Hi all,
I'm after a bit of help writing some code to create a new workbook from a template (production sheet) based on cell values (dates) in an different worksheet(WIP)

What i require is the code to look at a column AO and see if any of the values (dates) in that column are in the current working week, it will then copy the information from WIP to Production Sheet and input the information into the a cell based on the value (date). it will also have to take into account the number of hours allowed (column BI). a working day is based on 16 hours so it will have to deduct 5 hours from 16 which will leave it with 11 hours for the day. if there are not enough hours in the day it will go to the next available day.

I have created a workbook with an example all all this information already inputted.

Just hope someone could help me with the code.

Thanks
ND.

Bumping up the list for any help if possible?

Can anyone help with this before i mark it as solved?

Bump to raise in the list?