Hello, In the attached file I have provided an example of what I am trying to accomplish via macros.
I import a report into excel that changes each time it's ran. I'm trying to put a space after each 'group' is ran. As an example we have locations set up as A-A-0 A-A-1 ect..to A-C-3 B-A-0 to B-F-3 more data in sheet to show. I would like to insert a row after each area. So A-A-0 to A-C-3 would be one group. B-A-0 - B-F-3 is another. Not all these locations will show when the report runs. If needed I can provide a list of every location that I need this data to sort by (and I can provide groups). Once the rows are inserted I will be running a macro to place page breaks after each blank row.. this I already have though. Regards, Jason -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
insert_rows.xls
Description: MS-Excel spreadsheet