Set listobject as ADODB object and use sql on this.

hi CK76,

thank you.

It's known to cause memory leak and can cause issues.

Where did you get to know this?

You could work around it by making a temp copy of the open workbook and querying from that.

Ok. I am comparing 2 workbooks, previous version and current. I can create new temp workbooks and base on them.

I'd recommend using PowerQuery (Get & Transform) instead of ADO

I do not like this solution because:
1. All users have to have PQ
2. This is for manual querying, not creating automations

You can instead do single SQL query and join 2 in one shot and return single recordset.

ok this is dofficult. How to write SQL with join?

and my output is within sheet Result.

So for Added SQL is:
SELECT t_current.*
FROM t_current LEFT JOIN t_previous ON t_current.Order= t_previous.Order
WHERE t_previous.Order Is Null

For deleted SQL is:
Select t_previous.*
from t_current right join t_previous on t_current.Order= t_previous.Order
where t_current.Order

I do not know how to write syntsax of SQL for each statements above.

Best,
Jacek