Optimizing bot

Help Studio
, ,
1

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
2

Linq querying should work. You may try that please…

1 Like
3

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

4

pls help…!! @Nithinkrishna

5

I’d use LINQ queries: Intro to LINQ - Visual Basic | Microsoft Learn

They’re very fast and easy to understand.

6

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