Here is what I'm trying to do.

I sell things online on a very small scale and I've made a spreadsheet
to enter each sale that way I can track costs, inventory, profit, etc.

What I want to do is be able to enter a product code and quantity, and
have all the other fields entered in automatically from a lookup table.
The problem is, if I just do a normal lookup from one of the fields,
then if shipping prices increase at USPS and I change the shipping
value in my lookup, all my PAST sold products would have incorrect
data, so it may have cost $2.00 to ship something back then but now it
would change to $2.50 because I had to update my lookup table. So I'm
wondering if there is a way to make a field automatically populate but
then no longer populate if data in the lookup table is updated later
on.

I hope this makes sense, if it doesn't I can try to explain it a little
differently.

Maybe I should be doing this in Access instead... just wondering if
there is a way in Excel?

Thank you,
Josh Turmel


--
jturmel
------------------------------------------------------------------------
jturmel's Profile: http://www.excelforum.com/member.php...o&userid=27883
View this thread: http://www.excelforum.com/showthread...hreadid=473867