Update text to a new sheet
 

I have a sheet that I fill out with a specific format but when I print it out
I need it to look different. Is there a way to have the information I enter
one one sheet update to a new sheet so I do not need enter double.

Update text to a new sheet
 

Maybe enter in the new sheet A1 formula =firstsheetname!A1, fill it tothe
right and down as required, and format new sheet as you need!

Regards,
Stefi


€žCory€� ezt Ã*rta:

I have a sheet that I fill out with a specific format but when I print it out
I need it to look different. Is there a way to have the information I enter
one one sheet update to a new sheet so I do not need enter double.

Update text to a new sheet
 

Hi

Suppose sheet1 is your original sheet, you can use sheet2 as print out
sheet. In sheet2 cell A1 enter this formula and copy it to the desired
range:

=IF(Sheet1!A1<"",Sheet1!A1,"")

Best regards,
Per

"Cory" skrev i meddelelsen
...
I have a sheet that I fill out with a specific format but when I print it
out
I need it to look different. Is there a way to have the information I
enter
one one sheet update to a new sheet so I do not need enter double.

Update text to a new sheet
 

Yes, I always forget that =Sheet1!A1 returns 0 if Sheet1!A1 is blank!
Stefi


€žPer Jessen€� ezt Ã*rta:

Hi

Suppose sheet1 is your original sheet, you can use sheet2 as print out
sheet. In sheet2 cell A1 enter this formula and copy it to the desired
range:

=IF(Sheet1!A1<"",Sheet1!A1,"")

Best regards,
Per

"Cory" skrev i meddelelsen
...
I have a sheet that I fill out with a specific format but when I print it
out
I need it to look different. Is there a way to have the information I
enter
one one sheet update to a new sheet so I do not need enter double.