Hello
I would like to pull in the fields "Name" and "Comments" from one worksheet into another based on the criteria "where Active = X").
So John Smith and his comments would get pulled into the new worksheet.
Thank you
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Name[/TD]
[TD]Comments[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]lorem ipsum[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]Sam Smith[/TD]
[TD]kajdlkajdlkfjlkdjlak[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I would like to pull in the fields "Name" and "Comments" from one worksheet into another based on the criteria "where Active = X").
So John Smith and his comments would get pulled into the new worksheet.
Thank you
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Name[/TD]
[TD]Comments[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]John Smith[/TD]
[TD]lorem ipsum[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]Sam Smith[/TD]
[TD]kajdlkajdlkfjlkdjlak[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]