How to input value after filter in excel?

[yangyq10 (IvanY)]

Dear Experts

I have a excel request as below

1. Filter relative columns in excel file first, then save it as [TestDT].
   PS:[TestDT] is a table after filter[“Auto Approved”]
   

   
   
   
   

2. There is a for each activity after it. Its about sending email according to the address in excel file. No issue at this part
   

   

3. I set up a if condition and use [WriteCell] to remark “Found” or “Not Found” base on the result
   

4. The problem is, if I simply use Excel.Sheet(“closed”).cell(“F”+countAP.ToString), it will input some value to the cell which is beyound the filter(like what I show as below)
   

I try TestDT. sth or row(“Status”).sth but there is not [cell] after [.]
Since this is a [WriteCell] activity, it must include [cell] in VB

May I know how I can make it happen?

Thank you for your guidance in advance

Ivan

[Gautham_Pattabiraman]

Hi @yangyq10 ,

Instead of using a filter try this approach,

Use a for each row in excel activity,

Check the value in column status is Auto approved.

If yes - Continue you write the value in F column of same row.

If no - skip and take the next row.

This would be much simple and easy for you to go about it.

Thanks,
Gautham.

[yangyq10 (IvanY)]

@Gautham_Pattabiraman
Thank you for clearing my mind
It should work. Let me test