I have a spreadsheet of documents that are in revision along with their status and other criteria that change daily. Row B contains the individual document numbers starting with cell B2 as B1 is a row title. rows C through G have other criteria. I want to put updated data either at the bottom of the worksheet or in a different worksheet in the same workbook. Then if a document number from the updated data set matches a document number value in row B of the original data set I want it to cut the range of cells BX-GX in the row where the updated data exists and paste them into the original data set.
Cut and paste a range of cells if two cells are duplicates