| Home |
| Search |
| Today's Posts |
|
#3
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. |
| 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) | |||
Threaded Mode
