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