J
jturmel
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
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