software

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


In cell A2 in your Analysis worksheet put the following formula that
checks to see if cell A2 in 'Actual Weekly Units Ordered' worksheet is
blank. If it's blank then it puts the Projected amount. If it's not
blank it puts the Actual amount.

=IF('Actual Weekly Units Ordered'!A2=quot;quot;, 'Projected Weekly Units
Ordered'!A2,'Actual Weekly Units Ordered'!A2)

Hope that helps.
-Ikaabod

Gene Haines Wrote:
gt; I currently have a workbook with 3 worksheets: Actual Weekly Units
gt; Ordered,
gt; Projected Weekly Units Ordered and Analysis. I have 52 weekly columns
gt; dated
gt; 1/01/2006 thru 12/31/2006 in all 3 worksheets. I need to pull into the
gt; analysis sheet the projected units ordered by item for all 52 weeks,
gt; however
gt; when the actual units ordered by item for the current week are entered
gt; into
gt; the Actual Weekly Units Ordered sheet, I need to have that qty replace
gt; the
gt; projected qty in the current week of the Analysis sheet. Any help would
gt; be
gt; appreciated.
gt; Thank you
gt;
gt; Gene Haines--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: www.excelforum.com/member.php...oamp;userid=33371
View this thread: www.excelforum.com/showthread...hreadid=540741Ikaaboa: Thanks for your input. I will let you know how I make out.

Regards

Gene Haines

quot;Ikaabodquot; wrote:

gt;
gt; In cell A2 in your Analysis worksheet put the following formula that
gt; checks to see if cell A2 in 'Actual Weekly Units Ordered' worksheet is
gt; blank. If it's blank then it puts the Projected amount. If it's not
gt; blank it puts the Actual amount.
gt;
gt; =IF('Actual Weekly Units Ordered'!A2=quot;quot;, 'Projected Weekly Units
gt; Ordered'!A2,'Actual Weekly Units Ordered'!A2)
gt;
gt; Hope that helps.
gt; -Ikaabod
gt;
gt; Gene Haines Wrote:
gt; gt; I currently have a workbook with 3 worksheets: Actual Weekly Units
gt; gt; Ordered,
gt; gt; Projected Weekly Units Ordered and Analysis. I have 52 weekly columns
gt; gt; dated
gt; gt; 1/01/2006 thru 12/31/2006 in all 3 worksheets. I need to pull into the
gt; gt; analysis sheet the projected units ordered by item for all 52 weeks,
gt; gt; however
gt; gt; when the actual units ordered by item for the current week are entered
gt; gt; into
gt; gt; the Actual Weekly Units Ordered sheet, I need to have that qty replace
gt; gt; the
gt; gt; projected qty in the current week of the Analysis sheet. Any help would
gt; gt; be
gt; gt; appreciated.
gt; gt; Thank you
gt; gt;
gt; gt; Gene Haines
gt;
gt;
gt; --
gt; Ikaabod
gt; ------------------------------------------------------------------------
gt; Ikaabod's Profile: www.excelforum.com/member.php...oamp;userid=33371
gt; View this thread: www.excelforum.com/showthread...hreadid=540741
gt;
gt;

Thanks for your help Ikaabod. It works fine.

Regards
Gene

quot;Ikaabodquot; wrote:

gt;
gt; In cell A2 in your Analysis worksheet put the following formula that
gt; checks to see if cell A2 in 'Actual Weekly Units Ordered' worksheet is
gt; blank. If it's blank then it puts the Projected amount. If it's not
gt; blank it puts the Actual amount.
gt;
gt; =IF('Actual Weekly Units Ordered'!A2=quot;quot;, 'Projected Weekly Units
gt; Ordered'!A2,'Actual Weekly Units Ordered'!A2)
gt;
gt; Hope that helps.
gt; -Ikaabod
gt;
gt; Gene Haines Wrote:
gt; gt; I currently have a workbook with 3 worksheets: Actual Weekly Units
gt; gt; Ordered,
gt; gt; Projected Weekly Units Ordered and Analysis. I have 52 weekly columns
gt; gt; dated
gt; gt; 1/01/2006 thru 12/31/2006 in all 3 worksheets. I need to pull into the
gt; gt; analysis sheet the projected units ordered by item for all 52 weeks,
gt; gt; however
gt; gt; when the actual units ordered by item for the current week are entered
gt; gt; into
gt; gt; the Actual Weekly Units Ordered sheet, I need to have that qty replace
gt; gt; the
gt; gt; projected qty in the current week of the Analysis sheet. Any help would
gt; gt; be
gt; gt; appreciated.
gt; gt; Thank you
gt; gt;
gt; gt; Gene Haines
gt;
gt;
gt; --
gt; Ikaabod
gt; ------------------------------------------------------------------------
gt; Ikaabod's Profile: www.excelforum.com/member.php...oamp;userid=33371
gt; View this thread: www.excelforum.com/showthread...hreadid=540741
gt;
gt;