Copying data between sheets with static and un-static cell references

Hi All,

I'm trying to copy cells between 2 sheets, 1 named ESTIMATEDB and 1 named ESTIMATETEMPLATE.

So far I have the following formula:

=IF(ESTIMATEDB!Q3="N",ESTIMATETEMPLATE!$F$28=ESTIMATEDB!H3,"ERROR")

The ESTIMATEDB! cell references need to be row dependent, Q3, Q4, Q5 ect - whilst the ESTIMATETEMPLATE! cell references need to remain static (as shown above).

This formula seems to look right to me but all I'm getting is 'FALSE' - I'm really starting to pull my hair out! :-P

Thanks in advance, this forum is a HUGE help!

Thanks for the speedy reply.

The cell H3 of ESTIMATEDB has content i need to copy to ESTIMATETEMPLATE.

Thanks again.