The comparison needs to be done on unique id between sheet 1 and sheet 2. Both the sheet have id as a column. Need to compare this column. And delete the row in sheet 2 if there is no row for a particular id in sheet 1.
Thanks!
The comparison needs to be done on unique id between sheet 1 and sheet 2. Both the sheet have id as a column. Need to compare this column. And delete the row in sheet 2 if there is no row for a particular id in sheet 1.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks