I'm new to excel and preparing an accounting model for my office use. I request the members to help me to solve the copying of formula to all other cells.
The detail is here:
Sheet 1:
1) I've entered a number 1000 in L2
Sheet 2:
1) I've entered a values in columns D,E,F,G
2) Calculations :
at G2 : the formula is =D2*Sheet1!L2
The problem is when I Copy the formula in G2 through G3, G4, G5............... it changes to =D3*Sheet1!L3, =D4*ValidData!L4, =D5*ValidData!L5 and so on......
but it should be =D3*Sheet1!L2, =D4*ValidData!L2, =D5*ValidData!L2, so that the L2 value shall be constant for calculations in all cells.
Please help me to resolve this, Thanks in advance.............!
Bookmarks