hi all,
I am creating an order spreadsheet which at one stage uses stock control. To produce the stock control i have used countif formulas and if formulas which identify whether or not the food is being ordered. as this will clear once the new order has been made, i have create a very simple macro which copies the cells and them pastes the special value, adding the deducted value into the main stock control worksheet. The problem i have is when i do this on the first 5 amounts the value is simple deducted, but on the other (around 20 cells) i recieve a formula pasted into the cell, which just keeps growing every time i use the macro; should this be happening?
example code of what is created after pasting special value, then adding the value:
=((((((((((((100+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+0)+0)+0
Thanks in advance for any help given.
I am creating an order spreadsheet which at one stage uses stock control. To produce the stock control i have used countif formulas and if formulas which identify whether or not the food is being ordered. as this will clear once the new order has been made, i have create a very simple macro which copies the cells and them pastes the special value, adding the deducted value into the main stock control worksheet. The problem i have is when i do this on the first 5 amounts the value is simple deducted, but on the other (around 20 cells) i recieve a formula pasted into the cell, which just keeps growing every time i use the macro; should this be happening?
example code of what is created after pasting special value, then adding the value:
=((((((((((((100+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+(Processing!L19-Processing!H38+IF(Processing!N10,-1,0)*Step1!H32+IF(Processing!N22,-0.5,0)*Order!G9+IF(Processing!N16,-0.5,0)*Order!G9))+0)+0)+0
Thanks in advance for any help given.
