Run formula automatically

  • Thread starter Thread starter kimmiesings
  • Start date Start date
K

kimmiesings

I have an inventory list of air filters for different locations. When I"
enter a date indicating the filter has been changed, I would like it to
automatically take that out of inventory so I know what to order. Can anyone
help me on this topic?
 
You can use a worksheet_change event macro to do this or maybe even a
vlookup formula. More detail.
 
Thanks for answering Don! I'm fairly new to this level to computation on
excel. Here is what my worksheet looks like:

Quantity Size Date Changed On-hand In-stock Order
Kitchen 3 20 X 20 X 1 7/11/2008 6 3 0
Dining Hall 1 14 X 20 X 1 7/11/2008 7 6 0
1 16 X 20 X 1 7/11/2008 6 5 0
2 16 X 25 X 1 7/11/2008 5 3 0
Tray Room 1 16 X 25 X 1 7/11/2008 4 3 0

When I change the date changed cell, I want the in-stock column to
automatically update so that I know how many to order. The in-stock amount
would be the on-hand amount minus the quantity. Can you tell me how to do
that?

Thanks-
kimmiesings
 
Back
Top