deep.pro09
New Member
I have one excel workbook (abcd.xlsx) with 3 worksheets (x,y and z). x worksheet have some data in it and y,z worksheet are empty.
x worksheet:
name|age|married
john|21|yes
max|22|yes
david|32|no
y worksheet:
name|age
z worksheet:
name|age
Based on married status (yes or no), i want to update the y and z worksheet. For eg if married is "yes", then update the y worksheet and if married is "no" , then update the z worksheet.
Output
y worksheet:
name|age
john|21
max|22
z worksheet:
name|age
David|32
Is it possible to use data collection for such business logic? Is there any other alternative for the same?
x worksheet:
name|age|married
john|21|yes
max|22|yes
david|32|no
y worksheet:
name|age
z worksheet:
name|age
Based on married status (yes or no), i want to update the y and z worksheet. For eg if married is "yes", then update the y worksheet and if married is "no" , then update the z worksheet.
Output
y worksheet:
name|age
john|21
max|22
z worksheet:
name|age
David|32
Is it possible to use data collection for such business logic? Is there any other alternative for the same?