I am using Excel 2003. I have a worksheet called "RawData" which has a continuous list of invoices, I need to separate off the first invoice from the rest of the invoices into a new worksheet and call it "sheet1". The number of rows from cell A1 at the top left corner varies and is never constant from invoice to invoice however the last row of the invoice I need to move always includes the text string "NET PAYABLE TO". So I need to copy all rows from "A1" to the row that has the text to a new worksheet called "sheet1", I then need to delete those rows only from the original "RawData" worksheet, leaving the remaining invoices in "RawData" intact. If it is helpful to you, the first row on every invoice has the text string "TAX INVOICE". There are no empty rows between the "NET PAYABLE TO" row at the end of an invoice and the "TAX INVOICE" row at the start of the next invoice, so it is literally a continuous list.
Can this routine then be continued on all the other invoices in "RawData", copying them to new worksheets in the same workbook "sheet2","sheet3" etc until there is no data left in RawData, bearing in mind that there may be 10 invoices or 100 invoices in the "RawData" sheet.
I hope I explained this OK, I am only just dipping my toe in the water in Excel programming and I am discovering that Excel can be amazingly powerful....in the right hands!
Thanks for any assistance offered, I have spent hours looking at different code examples on the net and attempting to make them work for me but to no avail.
Regards Andy
Cairns, Australia
Can this routine then be continued on all the other invoices in "RawData", copying them to new worksheets in the same workbook "sheet2","sheet3" etc until there is no data left in RawData, bearing in mind that there may be 10 invoices or 100 invoices in the "RawData" sheet.
I hope I explained this OK, I am only just dipping my toe in the water in Excel programming and I am discovering that Excel can be amazingly powerful....in the right hands!
Thanks for any assistance offered, I have spent hours looking at different code examples on the net and attempting to make them work for me but to no avail.
Regards Andy
Cairns, Australia