Copying Multiple Rows
Posted by Ed Acosta on December 28, 2000 6:08 PM
What I need to know: is there an opposite function for the ROWSDIFFERENCE function? I match criteria in column A based on values in a different workbook. If a match is found the spreadsheet is copied to a new spreadsheet. I use ROWSDIFFERENCE function to highlight the rows that do not match the criteria and delete them. Is there a formula that will let me highlight all the rows that meet my criteria and copy /cut & paste those rows to a different spreadsheet? The data is sorted in ascending order. I now I can use a For Next Statement to find the starting Row and Ending Row that meet the criteria. Was just wondering if there was an easier way.