I have an Excel 2013 spreadsheet that contains several hundred rows, and columns from A thru H. I manually select the rows and columns needed, but I would like to automate this process and put the data into another sheet. Best method?
In The Excel Spreadsheet:
In Column A, I will select all rows that contain number 10055 AND in Column B Text Starting with Letters "CA". All rows and columns are copied to a new sheet.
A second copy is done for Column A containing number 10055 AND Column B Text Starting with the Letters "PB". Again, All rows and columns are copied into an empty row in the new sheet.
The Excel spreadsheet is converted from a .txt file and opened in Excel.
The data is NOT continuous. Within the rows can be page heading information, where the report continued from page 1 to page 2, etc.
It's time consuming selecting the rows meeting the specific criteria.
Any ideas how this can be automated in Excel?