I have over 50 items with multiple price points. I can not seem to figure out
how to make the price automatically fill in once I either import or type in
the product name. To confuse things even more, my prices change every so
often. Is there a way that i can do this or must i continue to input the
prices in manually.
Below is the column headings. It might be of some assistance.
Customer Category Product Quantity Price Extended Price Date Week

Any help?

Also, Is there a way i can convert a date into a specific week number. My
week begins on Wednesdays.