two sheets

[That's Confidential]

I need to calculate the following:-

If the value of a specific cell in Sheet 1 = "1", then copy information from
A1 in sheet 1 to A1 in sheet 2. If the value of a specific vell in sheet 1 =
"0", then don't copy information from A1 in sheet 1 to A1 in sheet 2.

Any suggestions?

 

[JulieD]

Hi

in A1 of Sheet 2

if(Sheet1!x1=1,Sheet1!A1,"")

where x1 is the "specific cell in sheet1"


Cheers
JulieD

 

[That's Confidential]

Thanks Julie

Hi

in A1 of Sheet 2

if(Sheet1!x1=1,Sheet1!A1,"")

where x1 is the "specific cell in sheet1"


Cheers
JulieD

1