i have a long price list, it looks more or less

art.code ; art.description; price

now i also have a list of customers who get some of the goods at a special
price... the problem: not all customers order all articles... and there is no
rule for the discounts they get.

i would like to enlarge the price list by adding coulumn customers price and
create new price list for each customer...

ist there a possibility of a makro which recognizes the art.code in one
sheet and copies the whole line to the new sheet...

it's so difficult to explain ,.. hope sb will understand me...

thanks in advance