recognize the text within a cell and copy/paste whole line to nex.
 

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

recognize the text within a cell and copy/paste whole line to nex.
 

Yes justyna, it can be done. But first you must decide where you will add
the customer ID and the discounted price on the current list, then provide
the format with column names, numbers or letters that each set of data
resides in before anyone can develop a meaningful macro for you.

"justyna" wrote:

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