Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've exported data from one accounting software package into a
tab-delimited txt file that I can use in Excel. I'd like to format the txt file in Excel so that it is in the proper format to be imported into a different accounting software package. I've gotten things to a point and now I need a macro that will insert 2 blank line between each row. I've been able to find a macro that inserts 1 blank line, but I need two rows and I don't know how to read the code. Now I've got the records formatted with 1 line of data followed 2 blank rows inserted, I need the data in cells B,C, and F copied to the first blank row and I need the data from column E cut and pasted into the first blank row. There is an entirely blank row inbetween each record. A B C D F B C E F (blank row) I need this macro to perform this modification on every record in the worksheet, and I don't know how to write a loop within an Excel macro. Any help out there? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |