Copy data from one grid to another

Is there a way to copy data from one grid to another? For example, one grid displays 1000 rows of data from a query. I’d like that data to display in a different table with the same fields. I’m thinking maybe have a button on the source table that runs a process to export into the other table. Open to any suggestions.

Thank you!

Maybe I don’t understand, but seems like you want to use a filter instead