Copy Data from Sheet1 to Sheet2 on condition

[RPAPJ]

Hi,

I want to build a process where data of sheet1 will be copied to sheet2 on certain condition (where address is "India") using MS EXCEL VBO. Currently it is coping entire data. Please find attached the process and properties of stages i have used. Kindly advise what I am doing wrong. Your response is greatly appreciated.

 

[VJR]

Hi RPAPJ,

You can just use Filter collection and need not loop through the collection.

Input Collection:

View attachment 1530600369627.png

Filter Collection:

"ColumnB = 'INDIA'"

View attachment 1530600166289.png

Output Collection parameter:

View attachment 1530600213422.png

Final Output Collection:

View attachment 1530600270267.png

You can now write this collection to the Excel file.

 

[RPAPJ]

Thank you so much VJR. It is working now. your help is much appreciated.

 

[RPAPJ]

Another small doubt - can we have multiple conditions in VBO 'Utility - Collection Manipulation' - 'Filter Collection' like "Address='INDIA"AND"Gender='Male'"?

 

[RPAPJ]

I found the answer on Web. It will be "Address='India AND Gender = 'Male'". I was giving "" in wrong place. thanks again.

​