Update text to a new sheet

C

Cory

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.
 
S

Stefi

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:
 
P

Per Jessen

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
 
S

Stefi

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


„Per Jessen†ezt írta:
 
Top