Paste Link usage on a filtered spreadsheet

Question

I have a worksheet (1) that is reading info from another worksheet (2).  I am trying to copy and "special paste links" from (1) to (2).  Worksheet (1) is filterd and I would like to be able to copy the info that belongs in the filtered sheet from (2) but when I paste the rows, it fills the rows that are hidden.  Since the worksheets are very different just "unhiding" them will not work.  Any help at all would be greatly appreciated.

Thanks!

Answer 1

I'm loosing track of what's filtered and whats not.  "Worksheet (1) is filtered" and "belongs in the filtered sheet from (2)"?

Are you trying to do a paste line from a filtered sourse to a filtered destination?  If so it doesn't matter that you are doing a paste link its the fact that the destination is filtered.  This will not work! Excel will always copy the cells into adjacent rows, hidden or not.  You would need to use vba to bypass this problem.

Of course there is a real danger here in that each range must correspond exactly.

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire