I am working with 3 worksheets between 2 workbooks. The information in Workbook A is also in Workbook B sheet 1. I need to identify the the records on Workbook A in workbook B sheet 1. Then I need to remove those identified records (4000 rows) on Workbook 2 sheet 1 and put them on Workbook B sheet 2. I don't know if it matters but its 4000 rows in Workbook A, 30,000 rows on workbook b sheet 1, and 17,000 rows on workbook b sheet 2. The records would be identified using ID#'s in column A. Thanks in advance.
Bookmarks