Hello guys, long time didnt post here. So here we go again with my problem and hopefully some can guide me to get through this.
Long story short.

1. I got this set of table which i query from web.

e9EW5ME.png

2. Column a, b, c, d, e and f from query web address.

3. Column g and h. I will manually insert input into this.

My question is, after I insert some input into column g and h, how to get this row "remove" together when rows from query removed?

For example after I refresh Item Barcode 230128 (refer picture) no more, then I want input at same row on column g and got remove together. Is it possible?

I try using "add custom column" but it only limited to certain coloumn.

Anyone can help much appreciated. and TIA.