Run formula automatically

[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?

 

[Don Guillett]

You can use a worksheet_change event macro to do this or maybe even a
vlookup formula. More detail.

 

[kimmiesings]

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

 

[Don Guillett]

If desired, send your workbook to my address below and I'll take a look.