Inventory Control
I have over 1000 small parts and need some sort of control showing when parts
are runing out and need to be reordered. |
Hello Glenn
Do something like this. If you have your parts quantity in D1, in E1 type in the quantity when you want to reorder tha part then highlight cell D1. Go to format then choose conditiona formatting, choose cell value less than e1 then format it the way you want. Ola "Glenn" skrev i meddelandet ... I have over 1000 small parts and need some sort of control showing when parts are runing out and need to be reordered. |
All times are GMT +1. The time now is 05:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com