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!!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Status
Not open for further replies.

Forum statistics

Threads
1,214,773
Messages
6,121,475
Members
449,033
Latest member
Kcolwell16

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top