Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel query for a stock sheet.
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 -- There''''''''s always a lot to be thankful for if you take the time to look for it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Web Query With Multiple Stock Symbols & Stock Scouter | Excel Worksheet Functions | |||
stock quote lookup query for Excel 2000 | Excel Worksheet Functions | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) |