View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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.