ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   how to copy formulas to other cells in excell (https://www.excelbanter.com/setting-up-configuration-excel/5089-how-copy-formulas-other-cells-excell.html)

eugene

how to copy formulas to other cells in excell
 
am having problems copying formulas from one cell to another using relative
cell references,i have tried several techniques and still does not work,like
EDIT,COPY,PASTE SPECIAL,FORMULAS and DRAGGING THE FILL HANDLE but it still
refers to the address used in the copied.I want to be able to copy formulas
to other cells without encountering this problem.

Jack in the UK


Have you tried this with a VBA solution for a selected range ?

JAck



--
Jack in the UK
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1352492.html





All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com