Paste special into a filtered work sheet
 

Hi

I'm trying to "paste link" from one work sheet to another. the problem
is the sheet i'm copying from has no filters and the sheet i'm copying
to does have a filter so the data when copied does not match. eg.
1st work sheet is
1
2
3
4
the second is
1a
1b
2a
2b
3a
3b
4a
4b
but has all the b's filtered out. when i paste the 1st sheet into the
second i get

1a - 1
2a - 3
3a - 5 etc

Any help appreciated, TIA

SD