I currently have a workbook with 3 worksheets: Actual Weekly Units Ordered,
Projected Weekly Units Ordered and Analysis. I have 52 weekly columns dated
1/01/2006 thru 12/31/2006 in all 3 worksheets. I need to pull into the
analysis sheet the projected units ordered by item for all 52 weeks, however
when the actual units ordered by item for the current week are entered into
the Actual Weekly Units Ordered sheet, I need to have that qty replace the
projected qty in the current week of the Analysis sheet. Any help would be
appreciated.
Thank you

Gene Haines