GOT IT - THANKS SO SO MUCH - i looked in help and placed a space between ""
and IT WORKED - I AM SO EXCITED THANK YOU.
--
claudia


"lilleke" wrote:

A1 did not come over to C1 like I understand your formula.
you said if b1 is "" (= blank, right), A1 else B1
B1 does copy over to C1 just fine.

when i copied C over to A special values only the blank lines in C overwrote
the filled cell

i have excel 2000 - i am soooo close
i see no reason for it not to work

--
claudia


"bj" wrote:

I misread your initial submission and I missed your earlier response
in the data base if there is anything in Column insert a helper column in
Column C
in C1
enter
=if(B1="",A1,B1)
copy C1 and paste in column C down to the end of your data
Select column c
and copy
select column A and paste special values
delete column C




"lilleke" wrote:

please respond to my clarification questions of 082307 thanks
--
claudia


"bj" wrote:

use a helper column in shhet one (c?)
in c1 enter
=if(iserror(vlookup(a1,Sheet2!A:B,2,0),b1,vlookup( A1,sheet2!A:B,2,0))
copy and paste down to the end of your data.
select column C
copy
select column B paste special values, delete column c


"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