# Copy and paste

#### Peter1973

##### Well-known Member
I have a cell Sheet1A1 which equals sheet2A1, in Sheet1A2 i want this to equal Sheet2 A10.

This trend will then continue i am trying to find a way to copy and paste this down, the interval is always 10 ie
Sheet1 equals Sheet2
A1 A1
A2 A10
A3 A20
A4 A30

Is ther an easy way to do this as the sheet is over 4000 lines so don't really want to do it individual.

ANy help appreciated.

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### dafan

##### Well-known Member
If you use
Code:
``=INDIRECT("Sheet2!"&ADDRESS((ROW(A2)-1)*10,1))``
youll get the desired output,

You can only start this on A2 as A1 won't give Sheet2!A1 as a result. You could workaround this with an IF-statement:

Code:
``=IF(ROW(A1)=1,INDIRECT("Sheet2!"&ADDRESS(1,1)),INDIRECT("Sheet2!"&ADDRESS((ROW(A1)-1)*10,1)))``
But thats a bit of a hassle.

You can just drag these formulas down as they will adjust to 10-20-30 etc.

#### Peter1973

##### Well-known Member
I have used the first formula yet this returns the #REF! not sure why.

#### dafan

##### Well-known Member
Are you sure your second sheet is called Sheet2? You'll have to edit that name to fit your 2nd sheet exactly.

#### schielrn

##### Well-known Member
It works fine for me? How exactly are you entering the formula and into what cells?

#### Peter1973

##### Well-known Member
Thanks got it the sheet name had a space

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,167,941
Messages
5,856,425
Members
431,812
Latest member
Elastomers

### 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