Flag Rows to Automatically copy over to another Worksheet

[jmenzel30]

Hey Guys,

I was hoping to get a little help here with what I though would be a simple excel command, but turns out its out of my pay grade. Essentially I have a risk sheet that tracks ALL cases opened. Now out of those cases some are more concerning than other, so we watchlist them. I created a column with Data Validation of "yes" and "no". The idea is that when the user places yes on the report, it copy's and pastes that row (A2:J2) on to another worksheet titled "Watchlist". This is very sensitive data, otherwise I would Post the workbook on here. But for reference sake:

Case	MID	Hierarchy Name	Title	Column1	Amount	Outcome	Last Comment	Opened On	Closed On	Watchlist:
7660	XXXXXXXXXXX	XXXXXXX	Large Transaction		$1,234		Blah Blah Blah Blah	1/2/2020	1/13/2020	Yes

This sheet with all of the data is named:
'Aperia Risk Cases'!

The Watchlist page is named Watchlist!

I would want it to paste onto the watchlist starting on Row 2.

Can anyone help with this?

Thanks!

 

[mikerickson]

If you have unique headers, Advanced Filter has a copy to other location option that would be useful.
Its not automatic. But it will get the job done.