Paste special into a filtered work sheet

S

SmithDelgado

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not incrementing cell reference 1
Page numbering with Merged Document and IF statements 1
to give numbers to rows as per your wish 2
Formula Based On a Check Box 2
Lookup Formula 3
Totaling Cells with Like Information 3
Special Sorting Need Advice... 3
Formula for Minimum/Maximum 2

Top