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
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
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)