I want to compare two excels and update the data in third sheet in excel where each sheet contains 100k line items

@Ranganathan_M

Yes even then we can still use it…

Once downloaded use copy sheet and copy both sheets to same excel where 3rd sheet is there and then use write cell to write the required formula…and then auto fill range to fill it till end

Cheers