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.