|If I am not mistaken, this is an example of what you are trying to do:|
Sheet1 has data in A1:A10, which are all visible.
Sheet2 has hidden rows, e.g. A1:A8 are visible, A9:A10 are hidden, A11:A12 are visible.
Therefore you want the data in Sheet1!A1:A10 to end up in Sheet2!A1:A8, Sheet2!A11:A12.
If that is true, the only way I know how to do it is with a macro. If that is the case, I'd need to know if this is a "variable" requirement (meaning it will not always be the same rows that are Sheet1!Copied, Sheet2!Visible) or if it will always be the same rows.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.