Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy/paste data across filtered rows
I have a worksheet that contains an autofilter across columns A-E. If a user
filters column B, for example, they may decide to enter a value in one of cells, then copy/paste that value across all of the "filtered" rows. The issue is that when you remove the filter, all of the rows in between (that had been 'filtered out') also have the pasted value. I can't figure out why this is happening or how to correct. Any insights? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy/paste data across filtered rows
While you can copy non contiguous rows/columns you cannot paste into non
contiguous rows/columns -- Regards, Peo Sjoblom "jday" wrote in message ... I have a worksheet that contains an autofilter across columns A-E. If a user filters column B, for example, they may decide to enter a value in one of cells, then copy/paste that value across all of the "filtered" rows. The issue is that when you remove the filter, all of the rows in between (that had been 'filtered out') also have the pasted value. I can't figure out why this is happening or how to correct. Any insights? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and Paste Format in filtered rows | Excel Discussion (Misc queries) | |||
Copy and paste - filtered data | Excel Discussion (Misc queries) | |||
copy and paste filtered data | Excel Discussion (Misc queries) | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
Issue with copy/paste dates from filtered data | Excel Discussion (Misc queries) |