IF

Status
Not open for further replies.

adamswalwell

New Member
Joined
Nov 4, 2005
Messages
29
So I have used the formula that I was given so that if I was to click on a macro button it would add to a reciept and deduct the value from the stock sheet but now for my Fish and Chip Shop I would like to be able to have a warning pop-up when the stock reaches a certain level (50 for example)

So, to get onto the system you have to enter a password to get to the main menu and from there you select either sales or stock I would like it that after the correct password was entered there would be a warning window popping up saying that for example fish needs re-ordering. This would happen for all of the stock when it reached a certain level so that I know when i need to re-order.

If anyone is able to help me I would grately appreciate it!!
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,050
Messages
5,569,891
Members
412,298
Latest member
dietitiann
Top