copying between cols using autofilter

Giganews Newsgroups
Subject: copying between cols using autofilter
Posted by:  Gaurab (gaur…@ebi.ac.uk)
Date: Tue, 21 Oct 2003

Hi,
I am relatively inexperienced with Excel 2k autofilter option.  I have
a very large worksheet, with approx 20k number of rows, and 8 cols. I
am interested in 2 cols which are adjacent to each other on the
worksheet.
The first col has data (text only), the 2nd col has a certain no. of
blank fields. It is the blank cells that I am interested in.

I use the auto filter option and using the pull-down list on the 2nd
col select and select only the blank cells. I now wish to copy the
contents of the the first col to the 2nd col, where there are blank
fields, so in effect renaming that cell with the contents of the cell
in the first col.

Currently, I cannot do it as Excel only lets me copy contents of rows
which are directly next to each other.

Any help would be appreciated and thanks in advance.

Gaurab

Replies