I need to clear contents of multiple rows of data on the Wood Total sheet if the number in column A of the Wood Total sheet does not match the same number in column A of the Cabinet Total sheet.
There will be about a thousand rows of data on the Wood Total sheet. When the rows are cleared I would like the data below the cleared row to move up so that there are no rows without data. Thanks in advance.
I really dont want to delete the data because there is other data to the right. Thanks
Wood Parts.PNGCabinet Total.PNG
Bookmarks