I have a macro that I adapted to what I needed, but only to a certain degree. The macro searches column "A" for certain numbers (nothing hard, it's like: 10, 12, 14, 16 etc.) and then copies the respective row to another sheet in the same workbook. It works great, except that the report it is scanning has two lines in between certain groups of data and once this macro hits a blank line, it ends. I'm pasting the code below in hopes of finding a way to ignore the blank lines and continuing to run. Maybe I can get something that will find the last line so it knows where to end? I'm not really sure, i'm pretty stumped here. Any help would be greatly appreciated.
Bookmarks