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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kimmiesings" wrote in message
...
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?

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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kimmiesings" wrote in message
...
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?

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kimmiesings" wrote in message
...
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" wrote:

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kimmiesings" wrote in message
...
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?