I have a workbook with 3 worksheets: Actual Weekly Units Ordered, Projected
Weekly Units Ordered and Analysis. My column headings are set up by dates
for all 3 worksheets, 1/2/2006 thru 12/25/2006. In the analysis worksheet, I
need to pull in the Projected Weekly Units Ordered, however as the current
dated week comes up and the Actual Weekly Units Ordered is entered, I need to
have the Analysis Worksheet pull in the Actual Weekly Units Ordered for the
then current week in lieu of the Projected Weekly Units Ordered for that
week. I hope I made myself clear. Any help would be appreciated. Thank you.

Gene Haines