Copy data from Visible cells to visible cells

[Hrishi]

Hello,
I need help in two scenarios. 1) when working on data in normal tabular form. 2) when working on data which is in "TABLE"

in both cases, some rows I wanted to keep hidden and copy only visible data and paste it to another sheet only in visible cells where too some rows are hidden.
So data should be pasted only in visible cells. Plz guide.

Regards,