L
Ladyrider
Hi there!
I have just started my new job and I have o set up a stock sheet.
What I want it to do is highlight with a warning if the amount from a new
stock take is lower than the previous stock take figure for a particular item
so that it can be re-ordered.
eg: (Column A) Item Detail , (column B) Previous Stock take figure, (Column
C) new Stock take figure
Green Side plate, 22, 14
When the amount of stock is less than the desired amount for holding in
stock I want it so that it will come up with a warning saying stock levels
are low. I would then like it to ask to continue to a purchase order sheet
from another book so that it will automatically set up an order.
Is this possible and how do I go about setting up the necessary forumlas?
Many thanks and Merry Christmas!
Ladyrider
I have just started my new job and I have o set up a stock sheet.
What I want it to do is highlight with a warning if the amount from a new
stock take is lower than the previous stock take figure for a particular item
so that it can be re-ordered.
eg: (Column A) Item Detail , (column B) Previous Stock take figure, (Column
C) new Stock take figure
Green Side plate, 22, 14
When the amount of stock is less than the desired amount for holding in
stock I want it so that it will come up with a warning saying stock levels
are low. I would then like it to ask to continue to a purchase order sheet
from another book so that it will automatically set up an order.
Is this possible and how do I go about setting up the necessary forumlas?
Many thanks and Merry Christmas!
Ladyrider