Hi
Remove old data.xlsx (11.7 KB)
In this excel sheet1 and Sheet 2 has some data. In that we need to find the last data of sheet1 is where in sheet2 and remove above data
But there r 3 column, data want to match in 3 column also
The correct output in output sheet
Hello @Aarthy1
Is data is repeated roll? You just have to find last row of first sheet to the last matching row of the second sheet.? am i correct?
Main.xaml (11.0 KB)
Try this one. provide proper naming and code. This is just a logic.
Hope this will solve.
Thanks and regards
Hi!
Here’s an alternative version, just in case. 
ICA_RemoveLinesFromExcel.xaml (11.1 KB)
To be improved with error handling, etc… but it should give you an idea.
Last row of the sheet1 want ti match in 2 sheet data
Ic the data is match we need to remove above data in sheet 2
@Aarthy1 yes. i got the same output as you want check the flow. give proper input and output path. here the excel which i got the ouptut. sheet name is result.
Remove old data.xlsx (12.2 KB)