Linking Sheets value returning as 0

[n18]

Hi,

I need to have linked sheets in the same work book I want to link Sheet B to Sheet A, I have the rows limited to 300, i.e. if the linked data goes over 300 rows it will not update as that is all I need.

The sheets link well, the first 84 rows are populated, the remaining rows are displaying 0 though when i link them. What I want to do is link the sheet and replace any 0's with blanks, I'm using the following formula but it is not working

=IF(A85=0," ","Test'!B85")

my result at the moment is that I am getting the data for the 84 rows which are populated but for every row after that up to 300 I am getting the value of 0.

Would appreciate any help,
Thanks

 

[Comfy]

Remove the quote from your sheet reference:

=IF(A85=0," ",Test!B85)

 

[RichardMGreen]

And remove the space between your first set of quotes.

 

[n18]

Thanks for the reply, I still have the same issue not sure why, still get 0. the error help says 'Im referring to blank cells', which I am but I want them to be blank when linked and displaying in sheet 2 not display a '0'. I'm linking from sheet 2 to sheet 1. My core data is in sheet 1. Both columns are formatted as 'General'.

Thanks for the help anyway.

 

[RichardMGreen]

What is the actual value on Sheet 2 in one of the cells you are having problems with?
Try using =len(A85) to get the amount of data in the cell. If it's empty you will get a value of zero.
Also, post your update formula on the cells that are currently giving 0 when you want them blank.