Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Help
Hi All,
I have a very large sheet, which covers a suppliers range of products. The format is as follows: ALDL/A/R Glass/Nkl 75 25.51 51.02 £51.02 Where the first column is the product code, the second relates to the colours of the product available. What I need to do, is loop through the sheet, and create individual rows for each available product. So instead of the above, I would have something like: ALDL/A/R-1 Glass 75 25.51 51.02 £51.02 ALDL/A/R-2 Nkl 75 25.51 51.02 £51.02 The product code has now changes, to reflect an individual product. I am very new to excel programming and have only covered the simplest of things, but the way I see it working is the user would specify a column which in this would be B to indicated which column the various colour codes are in. Then they would have to specify a seperator character which in this case would be "/" (these are not always the same) then the macro would loop through the sheet, making the alerations. Could anyone give me a few pointers on how I could do this please, as I said before, I am not to good with writing macros. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro not showing in Tools/Macro/Macros yet show up when I goto VBA editor | Excel Programming | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |