View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lilleke lilleke is offline
external usenet poster
 
Posts: 14
Default prevent copied blank cells from replacing existing data

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