Need help with Excel to link cells across multiple tabs?

[ExcelRookie102]

Hi, I need to link cells over multiple sheets but they must be allocated to a specific sheet according to certain criteria.

So in Sheet1 <Renamed to 'General'> I have Columns : A(Farm Code) B(Inc/Exp code) C(Description) etc etc.

Row example

1 101 Milk Income etc etc

Now in sheet 2 <Renamed R1> In this sheet all rows must be copied if Farm Code =1.

so the formula I have entered in sheet R1!A2 is :
=IF(General!A2=1;R1!A2=1;"")

The result is a "FALSE" in R1!A2

Please Help!!!

 

[123rickfear]

are you using excel? if so you need a comma, not semi colon.