Stocking Report help

B

Ben

Hi I have a simple Inventory stocking program in excel
that includes.
Min. Qty.--Qty In Stock---Recieved---Shipped--Available--
Qty. to Order.

The Available column is derived from QtyInStock+Recieved-
Shipped. Every Day at the end of the day I need to take
the numbers from the Available column and enter them as
the next days QtyInStock number. Currently I cant copy
and paste the Available column becuase it is formula's.

What is a better way to do this?

Also I would like the Recieved & SHipped columns to be
zerod out when a new entry QtyInStock field is entered.

Thanks
 
J

jeff

Hi,

Your first problem is easy: simply when pasting,
use the "paste special" and select "values" - this
will put the values - not the formulas in your pasted
area.

Your 2nd problem would require some macro code to zero
those fields.

jeff
 
F

Frank Stone

yes you can paste. pastespecial values. that changes the
formula to hard numbers. the rest smacks of macro. you
need a do loop or for next loop. you only gave 6 fields
and i suspect there are more(part number?). it's hard to
write code when you don't know all the data.
 
B

Ben

Thanks

-----Original Message-----
Hi,

Your first problem is easy: simply when pasting,
use the "paste special" and select "values" - this
will put the values - not the formulas in your pasted
area.

Your 2nd problem would require some macro code to zero
those fields.

jeff
.
Click to expand...
 
B

Ben

Thaks
-----Original Message-----
yes you can paste. pastespecial values. that changes the
formula to hard numbers. the rest smacks of macro. you
need a do loop or for next loop. you only gave 6 fields
and i suspect there are more(part number?). it's hard to
write code when you don't know all the data.

.
Click to expand...
 
Top