Copy cell contents from 1 row on sheet 1 into 2 rows in sheet 2

[mbristow]

I have 300 rows of data on sheet one in my file. I am copying each row into two rows on sheet two. So, Sheet1!A1 = Sheet2!A1 and Sheet1!B1 = Sheet2!A2, Sheet1!A2 = Sheet2!C1 and Sheet1!B2 = Sheet2!D1, and so on. The problem I have is that when I copy the cells on Sheet 2 from rows 1 and 2 into the 598 rows below that, the cell references in each row increment by 1. However, I need the two consecutive rows (rows 3 and 4 for example) to point to a single row on Sheet 1 (row 2 for example). Then rows 5 and 6 on sheet 2 would point to row 3 on sheet 1. How can I copy the rows on Sheet 2 so these increments are done automatically? Thank you in advance for your help.

 

[John Davis]

I have 300 rows of data on sheet one in my file. I am copying each row into two rows on sheet two. So, Sheet1!A1 = Sheet2!A1 and Sheet1!B1 = Sheet2!A2, Sheet1!A2 = Sheet2!C1 and Sheet1!B2 = Sheet2!D1, and so on. The problem I have is that when I copy the cells on Sheet 2 from rows 1 and 2 into the 598 rows below that, the cell references in each row increment by 1. However, I need the two consecutive rows (rows 3 and 4 for example) to point to a single row on Sheet 1 (row 2 for example). Then rows 5 and 6 on sheet 2 would point to row 3 on sheet 1. How can I copy the rows on Sheet 2 so these increments are done automatically? Thank you in advance for your help.

Do you mean like this?

Sheet2
A1
A2
B1
B2
C1
C2
D1
D2
E1
E2
F1
F2
G1
G2
H1
H2


Sheet1
A---------B
A1 A2
B1 B2
C1 C2
D1 D2
E1 E2
F1 F2
G1 G2

 

[mbristow]

Here is what I am trying to do:

Sheet 1
|------------------------|
| A1 | B1 | C1 | D1 | E1 |
|------------------------|
| A2 | B2 | C2 | D2 | E2 |
|------------------------|
etc...

Sheet 2
|--------------------------------------|
| | =Sheet1!B1 | =Sheet1!D1 |
| =Sheet1!A1 |-------------------------|
| | =Sheet1!C1 | =Sheet1!E1 |
|--------------------------------------|
|--------------------------------------|
| | =Sheet1!B2 | =Sheet1!D2 |
| =Sheet1!A2 |-------------------------|
| | =Sheet1!C2 | =Sheet1!E2 |
|--------------------------------------|
etc...

So, cells A1 and A2 on Sheet 2 are merged together, as are B1 and B2, etc. I need to be able to copy the two rows on Sheet 2 and paste them into the next two rows while having their cell reference numbers only increment by 1, as shown above. I hope this is more clear. Thanks.

 

[mbristow]

Well, my previous post did not format correctly at all. Here is what I am trying to do. I hope this formats better...

Sheet 1
|------------------------|
| A1 | B1 | C1 | D1 | E1 |
|------------------------|
| A2 | B2 | C2 | D2 | E2 |
|------------------------|
etc...

Sheet 2
|--------------------------------------|
|............| =Sheet1!B1 | =Sheet1!D1 |
| =Sheet1!A1 |-------------------------|
|............| =Sheet1!C1 | =Sheet1!E1 |
|--------------------------------------|
|--------------------------------------|
|............| =Sheet1!B2 | =Sheet1!D2 |
| =Sheet1!A2 |-------------------------|
|............| =Sheet1!C2 | =Sheet1!E2 |
|--------------------------------------|
etc...

So, cells A1 and A2 on Sheet 2 are merged together, as are B1 and B2, etc. I need to be able to copy the two rows on Sheet 2 and paste them into the next two rows while having their cell reference numbers only increment by 1, as shown above. I hope this is more clear. Thanks.