Tamblyne wrote:
I'm trying to copy certain cells from one sheet to another. If the
first cell is empty, I want the second cell to be empty, too, or,
ideally, just have a space in it. Right now, I get "0". I tried an
"IF" statement, but I can't seem to make it happy. Now I'm getting
Err:511 or #NAME?.
This is for a template where the first sheet may have 2 or more rows.
I don't want to have to go into the second sheet and delete all the
extra rows that won't have anything in them every time I use the
template.
Also, if there are hyperlinks in the cell in the first sheet, only the
link text appears in the cell in the second sheet -- not the hyperlink
that's supposed to go with it. Is there anything that can be done
about that?
Thanks
Your IF statement should have the following form (without the beginning
and ending quote marks):
for instance in cell B1 put " =IF( (A1="") ; A1 ; "") ."
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
