Add number line count to match inserted lines
Posted on 2013-12-29
The attached report has a macro that was something I received previous help on, but now I have a secondary issue. The Macro reads the amount of recordings in Column C, it then copies and inserts the number of lines.
My question is, is there a way to have Column E read column C as well and then after the lines are inserted it inserts into numeric order. So if column C reads three, in Column E after the Macro is done or during it, it would enter into Column E, 0010, 0020, 0030, or if more than 9 lines would do 0090, 0100, 0110, etc.
Please let me know if this is possible, and any help is always greatly appreciated.