I have invoices that are stacked vertically, the only way to determine the point of seperation from one the the next is they all start with the word "Bill" (located in columb A) and end with the word "copyright" (located in columb A). The range is A1:H1609 and I need to automatically copy each invoice from the current sheet to a sheet called "invoices."
Is this possible using a macro? If so, how?
Bookmarks