Keep formulas when copying data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
Back
Top