Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible Macro Solution To My Problem
There are times when I have to dump financial information from the AS400 to
Excel. When I do, it comes down in the following format: ACCOUNT/JOB # DESCRIPTION 7618-000-00000 COMMISSIONS VL02527 MATHEWS GINA VL02527 MATHEWS GINA VL02537 MICHAELS MARG VL02537 MICHAELS MARG 8111-000-00000 DEPRECIATION APRIL 07 DEPR ENTRY AUG 07 DEPR ENTRY DEC 07 DEPR ENTRY FEB 07 DEPR ENTRY I need an easy way to move the account # and account name to the first two columns like this: 7618-000-00000 COMMISSIONS VL02527 MATHEWS GINA 7618-000-00000 COMMISSIONS VL02527 MATHEWS GINA 7618-000-00000 COMMISSIONS VL02537 MICHAELS MARG 7618-000-00000 COMMISSIONS VL02537 MICHAELS MARG 8111-000-00000 DEPRECIATION APRIL 07 DEPR ENTRY 8111-000-00000 DEPRECIATION AUGUST 07 DEPR ENTRY 8111-000-00000 DEPRECIATION DECE 07 DEPR ENTRY 8111-000-00000 DEPRECIATION FEBR 07 DEPR ENTRY I can do it manually, but there are 5,000+ lines and it takes a lot of time. Is there any way to automate this? Thanks. Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Could someone please help me with a solution to my problem? | Excel Worksheet Functions | |||
Possible Macro Solution To My Problem | Excel Discussion (Misc queries) | |||
Problem in excel - possible MACRO solution ? | Excel Programming | |||
Macro Solution for Link Problem? | Excel Worksheet Functions | |||
Problem vlookup -solution macro | Excel Programming |