Create a document from a spread sheet using data from another spre

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Hey!

I need a little help here. I'm trying to create a "contract" in a sread
sheet using data collected in a diferrent spread sheet. I have a few rows
filled with dates and others in blank in case I might write a new date if I
need to. I need to copy these rows to a diferrent spread sheet and when there
are dates in them the data is trasnfered well but when the rows are blank I
get a nasty 0 on the new sheet and I just want the space to come out blank.
Is there a formula to make this happen?

ex sheet 1 trasnfer to sheet 2
A B A B
1 1/1/09 1 1/1/09
2 2 0
3 2/3/09 3 2/3/09
 
Not really sure what you're doing there, but this may help. With 1 in A1,
and A in A2 and B in A3, put this function in B1:
=IF(ISNUMBER(A1),"Number","")

Fill down.

Does that give you some ideas?

HTH,
Ryan--
 
Back
Top