# Paste value to another worksheet

#### tnjim

##### New Member
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.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### earlyd

##### Well-known Member
Anytime you work with cell references in macros, name the cells and use the range names in the macro where possible. Then you can insert rows and columns without worry. For example if you name cell A5 MyValue then you can reference Range("MyValue").value.

#### tnjim

##### New Member
Thanks. I appreciate the help.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,019
Messages
5,856,843
Members
431,836
Latest member
jj0911

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back