omitting blank cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Sarantidis - 07 Mar 2007 22:33 GMT

I need to copy cell from a list, which has been sorted, to another worksheet.
The problem I run into is that the sorted cells are not contiguous and the
source cells fall out of the target range.

Example; the cells in the following two columns need to be copied only if
column A is not blank.
A B A
B
Brian Harrison 13
Steven Porter
    Brian Scott 12 James Porter
13    Steven Porter
    Corky Colwell
    Danny Sasser
    Darren Carver
12    James Porter
    Don Olson

Reply to this Message

Martin Fishlock - 07 Mar 2007 23:32 GMT

Use auto filter or sort on the addtional column.

Signature

Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.

> I need to copy cell from a list, which has been sorted, to another worksheet.
> The problem I run into is that the sorted cells are not contiguous and the
[quoted text clipped - 13 lines]
> 12 James Porter
> Don Olson

Reply to this Message

Pete_UK - 08 Mar 2007 01:38 GMT

Set up autofilters to cover A and B and in the filter drop-down of
column A select "Non-blanks" from the bottom. Then you can highlight
the visible cells and click <copy>, move the cursor elsewhere and
paste. When you select "All" from the filter pull-down you will have
copied only the cells with an entry in column A.

Hope this helps.

Pete

On Mar 7, 10:33 pm, Peter Sarantidis
<PeterSaranti...@discussions.microsoft.com> wrote:

Reply to this Message