nathandavies
10-25-2017, 06:35 AM
Hi all,
I'm after a bit of help writing some code to create a new workbook (production sheet) based on cell values (dates) in an different workbook (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.
20746
I'm after a bit of help writing some code to create a new workbook (production sheet) based on cell values (dates) in an different workbook (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.
20746