| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the work sheet name in a formula by using cell reference | Excel Worksheet Functions | |||
| Paste Special and Linking | Excel Discussion (Misc queries) | |||
| Paste Special | Excel Discussion (Misc queries) | |||
| I get wrong dates when i paste from a different sheet into a new s | Excel Discussion (Misc queries) | |||
| Paste Special | Excel Discussion (Misc queries) | |||
Linear Mode
