Copy Multiple row fomula from 2 sheets

[gzhaha]

Hello all,

there are three sheets in an excel file.

- S2
- S3
- Sheet1

S2:
002.png

S3:
001.png

Sheet1
003.png

The data in Sheet1 is from S2 and S3

For example, formula in A2 is ='S2'!A1, when I try to copy three cells (A1, A2, A3) and paste to below, A5 show S2-4, but A5 should be S2-2 (A2 in sheet "S2")

I tried the OFFSET =OFFSET('S2'!$A$1,ROW()-2,) but not getting the right value.

Please advice
Thanks a lot

[shukla.ankur281190]

Welcome to Excel forum.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[gzhaha]

I have attached a sample excel file for testing.
Thanks a lot

[Olly]

In Sheet1, A1:

Please Login or Register  to view this content.

In Sheet1, A2:

Please Login or Register  to view this content.

In Sheet1, A3:

Please Login or Register  to view this content.

Now you can copy and paste these formulas below...

[Olly]

Or with just one formula - enter in Sheet1 A1, and copy down:

Please Login or Register  to view this content.

[gzhaha]

thanks a lot Olly, works like a charm