Cut and paste a range of cells if two cells are duplicates [Closed]

Report
Posts
1
Registration date
Monday September 12, 2016
Status
Member
Last seen
September 12, 2016
-
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!