Place a an autofilter from the Data Menu, then select non blanks
select the columns you want the data from and then hit F5, click on
Special select visible cells only and do your copy and paste if you get an
error stating that the selection already visible cells only, then skip the F5
method select the cells you want and do a copy and paste

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"lilleke" wrote:

Excel 2000 - this is under help - keyword-null and doesn't work and I need it
to work or am I reading wrong?

I hv 2 databases w 2 col 1 for owner name and 1 for financial ofcr name

I need to cut/paste fin ofcr name into owner name cell if there is a
financial officer name because I would rather mailer go to fin ofcr. There
isn't always name in fin ofcr col. I scroll until I find fin ofcr name,
cut/paste to col to the left and overwrite the owner's name with fin ofcr
name. about 10 fin ofcr names per visable screen.

Painful on mouse hand.

I want to highlight maybe whole fin ofcr col or at least visable page
cut/paste and overlay col to left with fin ofc name but not make other cells
blank. currently when I do this fin ofcr name is pasted and all other blank
cells are pasted as blanks also.

If copied blank cell overlays not blank cell I want blank cell not copied.
Please help.
--
claudia