S
soopial
Please see attached spreadsheet that has its trigger as the date at the
very top of the list (artwork approval date). Of course, now that I
have this working as I wanted (and thanks to your kind help), I have
been challenged to re-create this using the SHIP TO CUSTOMER date as
the trigger.
I have spent the better part of this past weekend trying to do just
that, but I am stumped! I can reverse the process by subtracting but
it doesn't seem to work the same when I tested it using the same ship
to customer date (as in column C-4/28/04).
In addition, the purpose of the worksheet is to be able to manipulate
the various leaditmes (such as B20-arrive at warehouse or B13-fabric
leaditme) and I can't seem to get this to go in reverse.
Any help/suggestions would be welcome and GREATLY appreciated.
Attachment filename: 2ship to customer worksheet.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=404556
very top of the list (artwork approval date). Of course, now that I
have this working as I wanted (and thanks to your kind help), I have
been challenged to re-create this using the SHIP TO CUSTOMER date as
the trigger.
I have spent the better part of this past weekend trying to do just
that, but I am stumped! I can reverse the process by subtracting but
it doesn't seem to work the same when I tested it using the same ship
to customer date (as in column C-4/28/04).
In addition, the purpose of the worksheet is to be able to manipulate
the various leaditmes (such as B20-arrive at warehouse or B13-fabric
leaditme) and I can't seem to get this to go in reverse.
Any help/suggestions would be welcome and GREATLY appreciated.
Attachment filename: 2ship to customer worksheet.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=404556