Optimizing bot

Hi @Nithinkrishna @ermanoj3101

PFA code.

is there any possibility to process bot fast.
as there are approx 4000 line items in excel
ExcelColoringForDataMismatch (2).zip (512.5 KB)

1 Like

Linq querying should work. You may try that please…

1 Like

how can i use this pls append that thing in code attached & also share ss

pls help…!! @Nithinkrishna

I’d use LINQ queries: Introduction to LINQ - Visual Basic | Microsoft Docs

They’re very fast and easy to understand.

4000 rows in Excel are not so much - a VBA script should do it in seconds.
What you want to achieve?