I have searched the web for this and everything i see involves writing code. I have done anything like this so i need some help. I have a inventory sheet that has formulas in it to count down as items are used, these numbers are inserted. then the calculations take over. Here is a sample:
item quantity took reorder at left
THREADING LUBE STL8 12 TUBE 6 TUBE 12
Dark THREADING OIL 2 JUG 1 JUG 2
TAPPING OIL 2 TUBE 1 TUBE 2
Zinc 12 can 6 can 1
So as you can see they add in what they took, it will subtract from reorder column and the column will decrease. When the number left gets to the reorder number it will turn red, thats when i need a email sent out to three people to make sure that the new reorder goes in. Please help me in writing the right code and sticking it in the right locations.