Pulling data from one cell to another

[Ivan Koh]

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

 

[Eduardo]

Hi,
your explanation comparing with the formula is a little confusing, as per
your explanation you should enter in sheet B cell A1
=if(sheetA!A1=0,sheetA!B1,sheetA!A1)

Please if that is not the answer you are looking for please explaing what is
in each cell of the formula given and what you want to achieve. thanks

 

[Ivan Koh]

Hi Eduardo,

Thanks for offering to help out.

It's actually a 2 part problem.

1st part is where

IF information from cellA of sheetA is X, then information relating to cellA
of sheetA is then transferred to sheetB.

2nd part:

But if cellA of sheetA has no information, it results in sheetB returning a
0, then information from cellB of sheetA will be transferred to same cell in
sheetB.

So the formula
=if(sheetA!A1=0,sheetA!B1,sheetA!A1) is not really correct, cos it means
that i have if sheetA!A1 not = 0, then sheetA!A1. But what im trying to
achieve is to trigger a 2 part ONLY if sheetA!A1=0.

Ivan

 

[Eduardo]

Hi,
I assume if cell A is X you don't want to populate anything so

=if(sheetA!A1="x",sheetA!A1,if(sheetA!A1=0,sheetA!b1,""))

Change the range where you want to pull the information if A1 i="X" to fit
your needs