| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formla that refers to another worksht down
I want to add two cells on worksheet 1 to sum in a cell on worksheet 2 in the
same workbook. Then I want to copy that formula down a few cells on whsht 2 letting the columns change and the row remain static. However, when I copy down the formula it changes the rows and keeps the column. If I anchor the row, it copies the exact formula changing nothing. I need an answer in a hurry! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to set up a cross reference chart, best way to copy formulas? | Excel Discussion (Misc queries) | |||
| How to copy several wkshts into one worksht with formulas? | Excel Worksheet Functions | |||
| Disable Cut & Copy then restore on exiting | Excel Discussion (Misc queries) | |||
| copy between worksheets does not copy formulae just values | Excel Discussion (Misc queries) | |||
| Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
Threaded Mode
