I've inherited an Excel document that is used to keep track of where materials are located within out facility. Recently they asked me to include quantity counts and mark them red when quantity gets low. This part wasn't hard, simply used a <count-if> function, then set conditional formatting based on threshold.
We'd like to move the quantity counts to another tab (Dashboard) which isn't a big deal. However, a couple of other request is over my head:
I'm not 100% I've explained this well, but am more than happy to answer any questions.
We'd like to move the quantity counts to another tab (Dashboard) which isn't a big deal. However, a couple of other request is over my head:
- Would it be possible to include the locations of that part number that are low on the dashboard?
- Would be possible to send an email when an inventory count reaches a certain point?
I'm not 100% I've explained this well, but am more than happy to answer any questions.