We have it working perfectly ..
Welcome, good to hear that.

I want to be able to sort the jobs by 'Actual Delivery Date' in the
'Monthly
Schedule' but when I hit the sort button it only moves the row but not the
information in it, ie: if I add a comment in the cell that will move but
information in the cell stays where it is? Any suggestions?
What's good about having the actua delivery dates in order
is that the weekly changes with it which is what I want.

It won't sort that way because the extract formulas will still
evaluate/return independently regardless. To get it to sort, you would need
to freeze it (the formulated lines) as values prior to sorting, but that
will then negate the modelled dynamics.

For what its worth, there is however scope to tweak it to auto-sort in this
manner (albeit I'm not sure if it'll fit in with your desired data/process
flows):

Implemented here for easy reference:
http://freefilehosting.net/download/40h9l
AutoDistr by Date Range n AutoSort by Date.xls

(a) To get the extracted source lines from Quote Log to appear in
auto-chrono, ie in ascending order by Est Delivery dates in Jan08's top
range part:

Make these tweaks:

In Quote Log's U4, filled across/down:
=IF($G4<"yes","",IF(TEXT($K4,"mmmyy")=U$2,K4+ROW( )/10^10,""))

Then In Jan08's A3, filled across/down:
=IF(ROWS($1:1)COUNT(OFFSET('Quote Log'!$T:$T,,MATCH(WSN,'Quote
Log'!$U$2:$IV$2,0))),"",INDEX('Quote Log'!B:B,MATCH(SMALL(OFFSET('Quote
Log'!$T:$T,,MATCH(WSN,'Quote Log'!$U$2:$IV$2,0)),ROWS($1:1)),OFFSET('Quote
Log'!$T:$T,,MATCH(WSN,'Quote Log'!$U$2:$IV$2,0)),0)))

(b) And to get the top range lines in Jan 08 to then appear in auto-chrono
order by Actual Delivery dates within each weekly ranges part

Make these similar tweaks:

In Jan08's U3, filled across/down:
=IF($F3<"Yes","",IF(AND($M3=U$2,$M3<=U$1),$M3+RO WS($1:1)/10^10,""))

Then in Jan08's A91, filled across/down:
=IF(ROWS($1:1)COUNT(OFFSET($T$3:$T$66,,MATCH($D$8 9,$U$2:$Y$2,0))),"",INDEX(A$3:A$66,MATCH(SMALL(OFF SET($T$3:$T$66,,MATCH($D$89,$U$2:$Y$2,0)),ROWS($1: 1)),OFFSET($T$3:$T$66,,MATCH($D$89,$U$2:$Y$2,0)),0 )))

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600, Files:362, Subscribers:60
xdemechanik
---