PDA

View Full Version : [SOLVED] Create a production schedule from a different workbook using cell values.



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

SamT
10-25-2017, 01:55 PM
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
10-26-2017, 12:40 AM
SamT,

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

nathandavies
10-27-2017, 12:45 AM
Just bumping this back up the list for any help if possible?

SamT
10-27-2017, 05:32 AM
could you explain in a bit more detail please?Need more detail about your Workbook(s) layout

nathandavies
10-27-2017, 06:38 AM
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
10-27-2017, 07:09 AM
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
10-27-2017, 07:28 AM
SamT

Please see the attached saved in 2003

nathandavies
10-30-2017, 03:49 AM
Just bumping this back up the list for any help if possible?

nathandavies
10-31-2017, 04:59 AM
Just bumping this back up the list for any help if possible?

SamT
10-31-2017, 08:48 AM
No more bumps, please. Most of our real experts have seen this thread.

nathandavies
10-31-2017, 08:55 AM
That's fine, if it cant be done then i will mark it as solved and leave it.

SamT
10-31-2017, 05:33 PM
Sorry :sad2:

nathandavies
11-03-2017, 08:25 AM
No problem, I'll mark as solved.