Create a production schedule from a different workbook using cell values.

[nathandavies]

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.

Book1.xlsx

[SamT]

If Year(A) = Year(B) And Week(A) = Week(B), Then 'All the Days in the week DateA are in the same week as DateB.

If your schedule is never 51 weeks behind, you don't need the Year check

[nathandavies]

SamT,

i'm not sure how this would work? could you explain in a bit more detail please?

[nathandavies]

Just bumping this back up the list for any help if possible?

[SamT]

could you explain in a bit more detail please?

Need more detail about your Workbook(s) layout

[nathandavies]

SamT,
I have a date value for "electrical test" which is in column AO, i want to use the date (if it is in the current week) from that range and paste the "job number - title" to the production sheet. on the production sheet the date value is in row 1. i have attached my work book so you can see what i'm trying to achieve.

[SamT]

I can't open either of your attachments. I use Excel XP, but I can read almost all versions. Try saving your file as an *xls(2003) file, then uploading it.

[nathandavies]

SamT

Please see the attached saved in 2003

[nathandavies]

Just bumping this back up the list for any help if possible?

[nathandavies]

Just bumping this back up the list for any help if possible?

[SamT]

No more bumps, please. Most of our real experts have seen this thread.

[nathandavies]

That's fine, if it cant be done then i will mark it as solved and leave it.

[SamT]

Sorry

[nathandavies]

No problem, I'll mark as solved.