Help with copying cells from a different worksheet.

[Live2Dive]

I'm looking for help with pulling cells from another worksheet. I have a few hundred rows in worksheet2, and want to change how they appear in the worksheet1. See attached.

There are 5 cells that I want to continue to copy, but when I do, it changes the cells from 1 to 5, and not from 1 to 2 like I want. In the cells copied down in the image, they should be: B2, A2, C2, D2, and F2 ... and not B5, A5, C5, D5, and F5.

Is there a way to make this copy/paste to not skip those three lines? If it were just a few lines, I'd fix them manually, but like I said, I have a few hundred lines I'm going to be copying.

Thanks for any help someone can give.

 

[Coding4Fun]

This is maybe a bit much but you can do it like this.

Start in Column K and run a Count starting at 1 and go until you have the number of records you want to return.

Then in Column M I am copying that range and pasting it below the previous set, do this 4 times in this case.

Then in Column O, I have sorted the numbers I just created which leaves me with a one next to the first 4 rows (O2:O5). In your screenshot you have a space between each one thus we need the extra 1.

Then looking at Columns H and I we create our shell, you will copy and paste this down as far as needed.

Then in Columns E and F we are combining the text and the number to make the Z_=Sheet2!B turn into Z_=Sheet2!B1

We then copy and paste Columns E and F and put the Data into Columns B and C and make sure to Paste as Values

You should then be able to simply highlight Columns B and C and use Find / Replace to change Z_ to "" (blank).

Hopefully that makes sense

Still a bit of work but alot easier than manually doing it.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1
2		=Sheet2!B1			=IF(H2<>"",CONCATENATE(H2,O2),"")	=IF(I2<>"",CONCATENATE(I2,O2),"")		Z_=Sheet2!B			1		1		1
3		=Sheet2!A1	Z_=Sheet2!C1		=IF(H3<>"",CONCATENATE(H3,O3),"")	=IF(I3<>"",CONCATENATE(I3,O3),"")		Z_=Sheet2!A	Z_=Sheet2!C		2		2		1
4		=Sheet2!D1	Z_=Sheet2!F1		=IF(H4<>"",CONCATENATE(H4,O4),"")	=IF(I4<>"",CONCATENATE(I4,O4),"")		Z_=Sheet2!D	Z_=Sheet2!C		3		3		1
5													1		1
6													2		2
7													3		2
8													1		2
9													2		2
10													3		3
11													1		3
12													2		3
13													3		3
14

<tbody>
</tbody>

 

[Coding4Fun]

I4 in my example should be Z_=Sheet2!F NOT Z_=Sheet2!C

Sorry