Create your first price sheet. Then right click on the tab at the bottom and
create a copy of that sheet. Double clikc on the tab of the ecopy sheet and
rename it to a unique identifierv (like "5% Discount"). Now aopply the
discounted prices to this sheet. Keep doing this for each price level you
have.

Now when a customer wants a prcie list, just select the appropriate sheet
price level tab and print it.

"Keith D.B." wrote:

Im fairly new to Excel but, Im wondering if I can create a price sheet that
is adjustable per customer. I want to print and give them to my customers
but, adjust the price by different percentages depending on their buying
history. My pricelist has several (about 12) sheets and about 400 items.