How to creat a reference to a cell in another worksheet and keep f

P

PhilRobinson

I am creating a reference to a cell in another worksheet in the same work
book but cells that are blank in the original workshhet are returned with a 0
in the new worksheet. How do I prevent this. I need to keep the same formats
in the second sheet as in the first sheet

Usinx Office Home & Student 2007 on Windows VISTA
 
P

Pete_UK

Use this approach:

=IF(Sheet2!A1="","",Sheet2!A1)

Note that a formula cannot return a format, so you will have to set
these manually. You can use Paste Special | Formats to copy a range of
formats from one sheet to another.

Hope this helps.

Pete
 
P

PhilRobinson

Sorry, it still doen't work

Pete_UK said:
Use this approach:

=IF(Sheet2!A1="","",Sheet2!A1)

Note that a formula cannot return a format, so you will have to set
these manually. You can use Paste Special | Formats to copy a range of
formats from one sheet to another.

Hope this helps.

Pete
Click to expand...
 
P

Pete_UK

I don't see why it didn't work, unless you typed it in incorrectly. In
what way did it not work? Did you get an error message?

Pete
 

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

Reference a cell to a worksheet?????????? 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How can I reference a worksheet in a formula based on a cell value 2
How do I reference a cell to another in the preceding worksheet 8
setting one worksheet cell range reference to another worksheet 1
How do I use the text content of a cell as a worksheet reference? 9
How to Auto Reference Worksheet Tab ID's in Formulas? 9
reference worksheet name in cell in another worksheet 4

Top