Stocking Report help

  • Thread starter Thread starter Ben
  • Start date Start date
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
 
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
 
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.
 
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...
 
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...
 
Back
Top