Autofilter/Sorting Copying Wrong records
 

I have a spreadsheet that is imported into Excel. I sort the information then
turn the autofilter on to filter out the information that I want to copy.
When I copy the information, for some reason it keeps copying additional
records that I am not needing.
I thought that by sorting the information first then autofiltering, I would
eliminate the additional records. Is this not the correct way to accomplish
this?
--
Sandi Gardner

Autofilter/Sorting Copying Wrong records
 

My first guess is that you're not filtering all the records.

I won't let excel guess at the range to filter (or sort). I'll select my range
first, then apply data|filter|autofilter.

On the other hand, maybe you're applying the filter incorrectly????

Is it simple text that you want to see--or could it contain a wildcard (? or *)?

Sandi wrote:

I have a spreadsheet that is imported into Excel. I sort the information then
turn the autofilter on to filter out the information that I want to copy.
When I copy the information, for some reason it keeps copying additional
records that I am not needing.
I thought that by sorting the information first then autofiltering, I would
eliminate the additional records. Is this not the correct way to accomplish
this?
--
Sandi Gardner

--

Dave Peterson

Autofilter/Sorting Copying Wrong records
 

Try copying visible cells only, select visible cells only. (The button is
located in View - Customise - edit - select visible cells. Drage it onto a
tool bar and try it!

Woody

"Dave Peterson" wrote:

My first guess is that you're not filtering all the records.

I won't let excel guess at the range to filter (or sort). I'll select my range
first, then apply data|filter|autofilter.

On the other hand, maybe you're applying the filter incorrectly????

Is it simple text that you want to see--or could it contain a wildcard (? or *)?

Sandi wrote:

I have a spreadsheet that is imported into Excel. I sort the information then
turn the autofilter on to filter out the information that I want to copy.
When I copy the information, for some reason it keeps copying additional
records that I am not needing.
I thought that by sorting the information first then autofiltering, I would
eliminate the additional records. Is this not the correct way to accomplish
this?
--
Sandi Gardner

--

Dave Peterson

Autofilter/Sorting Copying Wrong records
 

Hi Sandi

Having applied your filter, mark the table then type Ctrl +; (that's
Control + semicolon)
This will select just the visible cells.
Then Copy and Paste and it will take just your filtered data.

--
Regards

Roger Govier


"Sandi" wrote in message
...
I have a spreadsheet that is imported into Excel. I sort the
information then
turn the autofilter on to filter out the information that I want to
copy.
When I copy the information, for some reason it keeps copying
additional
records that I am not needing.
I thought that by sorting the information first then autofiltering, I
would
eliminate the additional records. Is this not the correct way to
accomplish
this?
--
Sandi Gardner