I have a worksheet with filtered rows. I want to copy values from cells in a single column into another worksheet but it just copies the unfiltered data. To clarify I have many rows hidden by the filter but when I copy, all the hidden data get pasted. I have say, 25 cells but they become 250 when I paste.
I am using paste special->paste special with Selection:Text, Numbers, Data and Time; Operations:None; Options:None; Shift Cells:Dont shift. I have tried Values only and Values and formats but all attempts just paste the unfiltered data.
The source worksheet is filtered using Data-MoreFilters-StandardFilter on values in a single column.
The help for “Only copy filtered cells” says Cells were filtered by AutoFilters, standard filters or advanced filters.Result= Only the visible cells of the selection are copied, deleted, moved, or formatted.
What am I doing wrong?