Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter, Cut and Paste Problem
I'm filtering then cutting and pasting, and when I paste to the new area,
data that I filtered out is being pasted. Is there a way to prevent this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter, Cut and Paste Problem
Try this two step selection method:
1st selection: EditGoToAdvancedCurrent area 2nd selection: EditGoToAdvancedVisible cells only Now copy and paste! Regards, Stefi €˛ManhattanRebel€¯ ezt Ć*rta: I'm filtering then cutting and pasting, and when I paste to the new area, data that I filtered out is being pasted. Is there a way to prevent this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter, Cut and Paste Problem
Stefi, are there any other options you can think of? I have to cut and paste
different data numerous times so I'm not sure your recommendation will work? Thanks for the help. "Stefi" wrote: Try this two step selection method: 1st selection: EditGoToAdvancedCurrent area 2nd selection: EditGoToAdvancedVisible cells only Now copy and paste! Regards, Stefi €˛ManhattanRebel€¯ ezt Ć*rta: I'm filtering then cutting and pasting, and when I paste to the new area, data that I filtered out is being pasted. Is there a way to prevent this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter, Cut and Paste Problem
Maybe you should create a macro for that purpose, e.g. something like this one:
Sub filtercopy() Selection.CurrentRegion.Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.Copy Sheets.Add ActiveSheet.Paste End Sub Regards, Stefi It copies the filtered data on the active sheet to a new sheet. €˛Stefi€¯ ezt Ć*rta: Try this two step selection method: 1st selection: EditGoToAdvancedCurrent area 2nd selection: EditGoToAdvancedVisible cells only Now copy and paste! Regards, Stefi €˛ManhattanRebel€¯ ezt Ć*rta: I'm filtering then cutting and pasting, and when I paste to the new area, data that I filtered out is being pasted. Is there a way to prevent this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter-Copy-Paste Problem | Excel Discussion (Misc queries) | |||
Copy Paste in Filter | Setting up and Configuration of Excel | |||
Auto-Filter copy/paste problem | Excel Discussion (Misc queries) | |||
Copy & paste special under a filter | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |