Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Split Macro
Hi All,
Seems I got no response to my earlier post, I have decided to rephrase my question as rereading it back I find it wasnt to clear on what I wanted to do. Basically the background is, suppliers provide me with stock detials (product codes, order number, lead time, price, amount in stock etc etc) in a excel speadsheet. The problem is sometimes these suppliers use the same product code for what we would define as two difference products. For example: Some suppliers would define a blue BMX bicycle and a red BMX bicyle as the same product, thus it would have the same product number on our suppliers price lists. Yet within our organisation we would need some method to differentiate between a red BMX and a blue one. So what I wish to do, is create a macro that will effectivly split the product into two (or more) individual products. Colours will be seperated with a / so in the case of the following row: ProdID Desc Price 2374 BMX Bicycle Red/Blue £99.99 It would then become: ProdID Desc Price 2374-1 BMX Bicycle Red £99.99 2374-2 BMX Bicycle Blue £99.99 Does anyone have any ideas how I could automate this through a macro? Kind Regards |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Split Macro
You have a response there now.
Materialised wrote: Hi All, Seems I got no response to my earlier post, I have decided to rephrase my question as rereading it back I find it wasnt to clear on what I wanted to do. Basically the background is, suppliers provide me with stock detials (product codes, order number, lead time, price, amount in stock etc etc) in a excel speadsheet. The problem is sometimes these suppliers use the same product code for what we would define as two difference products. For example: Some suppliers would define a blue BMX bicycle and a red BMX bicyle as the same product, thus it would have the same product number on our suppliers price lists. Yet within our organisation we would need some method to differentiate between a red BMX and a blue one. So what I wish to do, is create a macro that will effectivly split the product into two (or more) individual products. Colours will be seperated with a / so in the case of the following row: ProdID Desc Price 2374 BMX Bicycle Red/Blue £99.99 It would then become: ProdID Desc Price 2374-1 BMX Bicycle Red £99.99 2374-2 BMX Bicycle Blue £99.99 Does anyone have any ideas how I could automate this through a macro? Kind Regards -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy, split and transpose a range of values | Excel Programming | |||
macro to split text in columns | Excel Discussion (Misc queries) | |||
Excel not responding. Only works if I run split macro in 2. | Excel Programming | |||
Split or copy records n-times as excel scans the value of a colum | Excel Programming | |||
I want to split containt of a cell and copy in seprate cells | Excel Worksheet Functions |