Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autosum doesn't recognize cell values after I cut and paste valuesfrom web page | Excel Discussion (Misc queries) | |||
Trying to copy and paste line of text into multiple cells | Excel Discussion (Misc queries) | |||
want to copy entire text box and paste in new cell | Excel Discussion (Misc queries) | |||
Copy Text from cell to paste on New Web Query | Excel Discussion (Misc queries) | |||
copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes | Excel Discussion (Misc queries) |