Prev: Protecting worksheet
Next: sorting array formula
From: kimmiesings on 6 Jul 2008 01:31
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?
From: Don Guillett on 6 Jul 2008 09:00
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
dguillett1(a)austin.rr.com
"kimmiesings" <kimmiesings(a)discussions.microsoft.com> wrote in message
news:3A611C08-12C0-4483-8E62-9AA244617F44(a)microsoft.com...
>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?

From: kimmiesings on 7 Jul 2008 01:22
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
> dguillett1(a)austin.rr.com
> "kimmiesings" <kimmiesings(a)discussions.microsoft.com> wrote in message
> news:3A611C08-12C0-4483-8E62-9AA244617F44(a)microsoft.com...
> >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?
>
>
From: Don Guillett on 7 Jul 2008 08:04

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1(a)austin.rr.com
"kimmiesings" <kimmiesings(a)discussions.microsoft.com> wrote in message
news:719B0173-156A-414C-B136-6F533B69A858(a)microsoft.com...
> 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
>> dguillett1(a)austin.rr.com
>> "kimmiesings" <kimmiesings(a)discussions.microsoft.com> wrote in message
>> news:3A611C08-12C0-4483-8E62-9AA244617F44(a)microsoft.com...
>> >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?
>>
>>

 | 
Pages: 1
Prev: Protecting worksheet
Next: sorting array formula