| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy formulas
I want to copy a formula from one cell and paste it into another cell that is
3 cells below the orginal cell copied. I need to do this several times, down a worksheet. In the orginal cell I have a formula that pulls data from another worksheet. What I need to be able to do is when I paste the formula in to the new cell that it will increase the ref number by one, right now when I paste it changes the ref number by 3 because I am moving down three cells, but I want it to only change by one number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Formula's | Excel Worksheet Functions | |||
| I want to copy only the layout and formulas and not the exisiting | Excel Discussion (Misc queries) | |||
| How to copy formulas from one workbook to another | Excel Discussion (Misc queries) | |||
| How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
| how do i copy vertical formulas to horizonal and keep same cell r. | Excel Discussion (Misc queries) | |||
Threaded Mode
