Hello everyone. I have a problem that I have not been able to resolve. I have a series of spreadsheets. They all have the same column headers. In particlar column 8 contains account numbers. I would like to loop though each worksheet and after each new account number insert a specific number of rows, say 5 of them.
I have piece mealed some code that can be seen below. It sort of works but 1.) It fails to loop through each worksheet and 2.) Does not properly insert rows after each new account number.
Note I do not want to run this macro o the first three worksheets of the work book. Only starting with worksheet 4 and onwards.
Please Login or Register to view this content.
Bookmarks