Help Please- How to offset Date to correct column for Ageing

[Roger Swinderman]

Hi All,
I have a stock ageing sheet for finished goods, which uses a vlookup table,
on entry of the Product code (last 3 Digits), this populates the next three
columns with description, FG cost and Quantity of product. the quantity of
product is entered again manually into the appropriate column, there are
five columns these are banded <3 Months 0%, 3 to 6 Months 25%, 6 to 9 months
50%, 9 to 12 Months 75% and > 1 Year 100%, the percentage is liability
provision.
What I would like to do is on entry of the product code as above the
quantity is automatically inserted into the correct column by age (date)
either entering the date manually or from the vlookup table. I hope I have
explained this well enough.
TIA
Regards Roger.

[Bob Phillips]

Roger,

Can you give some sample data and what the results might be?

--
HTH

Bob Phillips

"Roger Swinderman" <[email protected]> wrote in message
news:%[email protected]...
> Hi All,
> I have a stock ageing sheet for finished goods, which uses a vlookup
table,
> on entry of the Product code (last 3 Digits), this populates the next
three
> columns with description, FG cost and Quantity of product. the quantity of
> product is entered again manually into the appropriate column, there are
> five columns these are banded <3 Months 0%, 3 to 6 Months 25%, 6 to 9
months
> 50%, 9 to 12 Months 75% and > 1 Year 100%, the percentage is liability
> provision.
> What I would like to do is on entry of the product code as above the
> quantity is automatically inserted into the correct column by age (date)
> either entering the date manually or from the vlookup table. I hope I have
> explained this well enough.
> TIA
> Regards Roger.
>
>

[Roger Swinderman]

Hi Bob,
Column
A B C D
E F G H
I J K
L M
Code Description FG Cost Qty Date <3
Months 0% 3 - 6 Months 25% 6 - 9 Months 50% 9 - 12 Months 75%
>1 Year 100% Total Liability Qty Value
1 313 T48793 T40 Fan £0.47 200 15-09-05
200 (Manual entry)
0.00 200 93.25
2 313 T48793 T40 Fan £0.47 200 06-06-05
200 (Manual entry)
23.31 200 69.94
3
I hope this explains it a little clearer
Thanks again
Roger

"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> Roger,
>
> Can you give some sample data and what the results might be?
>
> --
> HTH
>
> Bob Phillips
>
> "Roger Swinderman" <[email protected]> wrote in message
> news:%[email protected]...
>> Hi All,
>> I have a stock ageing sheet for finished goods, which uses a vlookup
> table,
>> on entry of the Product code (last 3 Digits), this populates the next
> three
>> columns with description, FG cost and Quantity of product. the quantity
>> of
>> product is entered again manually into the appropriate column, there are
>> five columns these are banded <3 Months 0%, 3 to 6 Months 25%, 6 to 9
> months
>> 50%, 9 to 12 Months 75% and > 1 Year 100%, the percentage is liability
>> provision.
>> What I would like to do is on entry of the product code as above the
>> quantity is automatically inserted into the correct column by age (date)
>> either entering the date manually or from the vlookup table. I hope I
>> have
>> explained this well enough.
>> TIA
>> Regards Roger.
>>
>>
>
>