| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - Please Help
Hi,
Please help with the below macro. I have two tabs: Sheet1 & Sheet2 Sheet1 contains the below information: Columns: A B C D E Code From To Amount Group A1050 1/06/2007 5/06/2007 $ 50,000 ABC B1060 1/06/2007 5/06/2007 $ 50,000 ABC C1070 1/06/2007 5/06/2007 $ 50,000 ZZZ I need to organise these data to Sheet2 in the below format Columns: A N Q S Code Amount Group Date A1050 $ 50,000 ABC 1/06/2007 A1050 $ 50,000 ABC 2/06/2007 A1050 $ 50,000 ABC 3/06/2007 A1050 $ 50,000 ABC 4/06/2007 A1050 $ 50,000 ABC 5/06/2007 B1060 $ 50,000 ABC 1/06/2007 B1060 $ 50,000 ABC 2/06/2007 B1060 $ 50,000 ABC 3/06/2007 B1060 $ 50,000 ABC 4/06/2007 B1060 $ 50,000 ABC 5/06/2007 C1070 $ 50,000 ZZZ 1/06/2007 C1070 $ 50,000 ZZZ 2/06/2007 C1070 $ 50,000 ZZZ 3/06/2007 C1070 $ 50,000 ZZZ 4/06/2007 C1070 $ 50,000 ZZZ 5/06/2007 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
| Start Macro / Stop Macro / Restart Macro | Excel Programming | |||
Threaded Mode
