Keep formulas when copying data

[Ronnie]

I have a spreadsheet where I need to link cells from 1 worksheet to another.
Worksheet DHL needs to link with cells on worksheet Box Label.

I have linked the 2 worksheets with the following formulas.

B2 =IF(DHL!C5="","",DHL!C5)

B5 =IF(DHL!C6="","",DHL!C6)

B7 =IF(DHL!C7="","",DHL!C7)

B9 =IF(DHL!C8="","",DHL!C8)

B11 =IF(DHL!C10="","",DHL!C10)

B13 =IF(DHL!D1="","",DHL!D1)

The question I have, is how I keep the formulas when I copy the information
from both worksheets to further cells down the worksheets. This information
needs to be replicated many times. Is there an easy way to achieve this
without manually entering the formulae again? Hope this makes sense.

Ronnie

 

[Dave Peterson]

If you use absolute references, then the addresses won't change when you
copy|paste.

=IF(DHL!C5="","",DHL!C5)
becomes
=IF(DHL!$C$5="","",DHL!$C$5)