Keep formulas when copying data
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 |
Keep formulas when copying data
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) Ronnie wrote: 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 |
All times are GMT +1. The time now is 09:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com