Formula problems

D

dew244

I am trying to subtract the 'to shelf' cell from the 'beginning qty' cell and
I want to display the result in the 'beginning qty' cell as the new
'beginning qty' for a later calulation. thanks

BEGINNING QTY. TO SHELF
12 5
 
P

Pete_UK

Assume these are in columns A and B. You can add a third column C -
REMAINING QTY - with this formula:

=A2-B2

and copy down.

Then at the start of the next day you can highlight column C, click
<copy> then Edit | Paste Special | Values (check) | OK then <Enter>.
This will have fixed the values in column C. Then copy from C2
downwards and paste over cells A2 downwards, and delete all the values
in column B ready to start again for that day.

Hope this helps.

Pete
 
D

Darkwah

Assuming 'BEGINNING QTY" is in cell A1, 12 in A2 and 5 in B2, below 12 i.e.
A3 write A2-B2 and copy down as far as you want. The beginning qty will be
displayed as soon as you enter a figure in the "To Shelf" column.
 
Top