Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update a autofilter sheet from another sheet | Excel Discussion (Misc queries) | |||
update text from ons sheet to another. | Excel Worksheet Functions | |||
Update from different sheet | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
update sheet on the web | Excel Discussion (Misc queries) |