Hi all,

Thanks for your help the last time round. Got yet another problem.

Would like to pull data from cell A from worksheet A to cell A of worksheet
B when a certain condition is met.

However, when if information from cell A to worksheet B is 0, then i would
automatically like to pull information from cell B of worksheet A to cell A
of worksheet B.

Thus, i was wondering if the formula of cell A for worksheet B would be
something like
'=IF('A'!G14="X",'B'!F14,"")=IF(E7="",'B'!E14,","-")

But i get a error on circular reference. Any idea?

Ivan