Can I stop linked cells updating if the source cell is null 1

[thefear]

Hi folks,

I hope someone can help. I keep getting caught out by things that seem evidently logical, but then aren't!

I've rewritten this question several times to get it as clear as possible, but please let me know if you'd like any more information.

In a nutshell: I have two linked worksheets: 'Source' and 'Target'. Is there a way to have it so that if a cell in 'Source' that 'Target' links to is Null, the cell in 'Target' doesn't update and keeps its current value?

I'd fooled myself into thinking I could do this with some strange IF statement, but I can't figure it out. I'm coming to suspect I'm going to need VBA, which I initially wanted to avoid because I won't be supporting this system after its finished, but if that's the only way, that's the only way.

Very Best Regards,

Mark

p.s. the bold above is just to draw attention to my question amid my rambling. If it means I'm shouting, sorry. Didn't mean to shout

 

[lionelhill]

In my hands it works perfectly OK if in spreadsheet "B" you put the following formula:
=if([fileA]Sheet1!A1<>"", [fileA]Sheet1!A1, A1)

This means that if there is something in A1 of file "A", it will be placed in A1 of file "B". If there isn't, A1 of file B will be replaced by itself (i.e. unchanged).

If Excel objects to a circular reference, go to Excel options and turn on iterative calculations.

 

[SkipVought]

Hi,

VBA. Forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[thefear]

That's perfect, Mr Lionelhill! Thank-you so much!

Best Regards

Mark

 

[thefear]

Seriously, this works so well it's spooky!

Ta again