I am relatively new to excel so please pardon if this is silly question. I have a worksheet (Sheet1) that has formulas to pull in numbers from another worksheet (Sheet2)based on certain criteria. I want to copy the results of the formulas to a third worksheet (FR2002-03). However, when I copy the formula results from sheet1 to the FR2002-03 worksheet I have to put the actual value in the cells because this sheet is then sent to another agency and they will not allow formulas to be in the cells (they require it to be values). I have recorded a macro to copy, pastespecial, values which will work but it leaves me with a disadvantage if I ever insert a row, etc..., I will have to modify the range.
Example:
Sheet1: Cell F11 contains this formula
=INDEX(Sheet2!$D$1:$D$2500,MATCH(J11,Sheet2!$G$1:$G$2500,0))
This formula returns a result of = 222,364
I want to get the value of 222,364 into cell F11 on worksheet FR2002-03.
I appreciate any help I can get. Thanks.
Example:
Sheet1: Cell F11 contains this formula
=INDEX(Sheet2!$D$1:$D$2500,MATCH(J11,Sheet2!$G$1:$G$2500,0))
This formula returns a result of = 222,364
I want to get the value of 222,364 into cell F11 on worksheet FR2002-03.
I appreciate any help I can get. Thanks.