copy and paste after filtering

Hi. i'm trying to find a solution for this problem. after filtering on a certain column, I'm trying to copy and paste the subset of values from column a into column b. when I unfilter I see that all the values from a are in b, not just for the filtered records. Some of my co-workers have seen this, some have not.

Can you help?

Thanks.

The advanced filter lets you carry out the filter and copy to another area of
the spreadsheet at the same time. It is a little more complicated as you have
to set the criteria up separately. HIf you need help with this post back

HTH - SHeila
www.c-i-m-s.com
MS Office training - London

"wab_77" wrote:

>
> Hi. i'm trying to find a solution for this problem. after filtering on a
> certain column, I'm trying to copy and paste the subset of values from
> column a into column b. when I unfilter I see that all the values from
> a are in b, not just for the filtered records. Some of my co-workers
> have seen this, some have not.
>
> Can you help?
>
> Thanks.
>
>
> --
> wab_77
> ------------------------------------------------------------------------
> wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875
> View this thread: http://www.excelforum.com/showthread...hreadid=561443
>
>

If you're really copying from column A to column B of a filtered range (and your
range to copy or paste is discontiguous), maybe you can do this instead.

Do your filter
select the range in column b that should get the new values (include any hidden
rows).

Then edit|Goto|Special
visible cells only
type an equal sign and point at that cell in column A of the same row
hit ctrl-enter

This will fill the visible cells with a formula that retrieves the values from
column A.

=======
Another option.

Sort your data before you filter.
Group all the the rows together that need to be visible when you filter.

Since the range is contiguous, it should work ok.



wab_77 wrote:
>
> Hi. i'm trying to find a solution for this problem. after filtering on a
> certain column, I'm trying to copy and paste the subset of values from
> column a into column b. when I unfilter I see that all the values from
> a are in b, not just for the filtered records. Some of my co-workers
> have seen this, some have not.
>
> Can you help?
>
> Thanks.
>
> --
> wab_77
> ------------------------------------------------------------------------
> wab_77's Profile: http://www.excelforum.com/member.php...o&userid=33875
> View this thread: http://www.excelforum.com/showthread...hreadid=561443

--

Dave Peterson