linking data from sheet to sheet

[MacDee]

Thank you all for taking the time to be here!

I am trying to link the data from the first sheet to the second sheet. The formula I used to link the two B2's worked but when I copied it to B3 and B5 it doesn't
Here is what I have in B2
=IF('Work Hrs'!$B$2="","",'Work Hrs'!$B$2)
and B3
=IF('Work Hrs'!$B$3="","",'Work Hrs'!$B$3)
and B5
=IF('Work Hrs'!$B$5="","",'Work Hrs'!$B$5)

But B3 and B5 simply populate the formula in the cell.
untitled.JPG

[Pete_UK]

The dollar symbols in the cell references mean that those do not change when the formula is copied into another cell. Try it this way in B2:

=IF('Work Hrs'!B2="","",'Work Hrs'!B2)

then you can copy across and/or down as required.

Hope this helps.

Pete

[MacDee]

thanks a million Pete