Update text to a new sheet

  • Thread starter Thread starter Cory
  • Start date Start date
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.
 
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:
 
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
 
Yes, I always forget that =Sheet1!A1 returns 0 if Sheet1!A1 is blank!
Stefi


„Per Jessen†ezt írta:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
VLOOKUP refuses to automatically update 1
Help to create a macro 2
all sheets need the same first 6 columns - user friendly presentat 1
Change all text on Spread sheet 1
Creating a new sheet from specific data in existing sheet 3
Excel Move or Copy Stopped Working? 0
Summary sheet with text entries. 5

Back
Top