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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formla that refers to another worksht down
To keep the row constant try:
Instead of A2 put A$2 in the formula Placing a $ sign in front of either the row or column will make it stay the same when copying or dragging. -- JNW "STAR263" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy formla that refers to another worksht down
I think you might want to use the OFFSET function for this. Without knowing
what cell references you're using, I'll just assume your data starts in A1 on both sheets. On Sheet2 enter: =OFFSET(Sheet1!$A$1,0,ROW()-1)+OFFSET(Sheet1!$A$2,0,ROW()-1) By using the ROW function in the column reference of the OFFSET function, you should get your desired incrementation results when the formula is copied down Sheet2. HTH, Elkar "STAR263" wrote: 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! |
Reply |
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) |