Looping through a specific number of cells then paste in their own column

drop05

Board Regular
Joined
Mar 23, 2021
Messages
113
Office Version
  1. 365
Platform
  1. Windows
Hello, I am curious if this is possible if in VBA it can loop through a X number of rows in a column, copy the data, then go through the same X of rows, in the same column, after going through that first batch and paste into the next column, the pasting will be in a sheet2 not the same sheet (sheet1)
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,986
Office Version
  1. 365
Platform
  1. Windows
I think it should be able to do that, though I am not certain I follow all the specifics.

It may be better if you can post us a few images, showing us the before and after images of what you have and what you want.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.
 

drop05

Board Regular
Joined
Mar 23, 2021
Messages
113
Office Version
  1. 365
Platform
  1. Windows
I think it should be able to do that, though I am not certain I follow all the specifics.

It may be better if you can post us a few images, showing us the before and after images of what you have and what you want.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.
Okay hope i did this right, i have pasted it below. You will see that the yellow cells are where values will go, now i want to loop through each row and for each test, which i included two but there is up to 20, each test has about 64 rows to copy data from 65 if you include the header cell starting at row 6/7, so id like to loop through that number of cell in that row, copy the data paste it into a sheet2 in column F then go through the next range of cells on column G from the sheet shown for test 2, then paste into a sheet2 in the next column so column G and if there was a 3rd test then do the same until there is no more values in that column G and then move to column H and do the same then I and J and so on
hope i am explaining it correctly, note the work question followed by a number is not what actually goes there, just editing the questions at the moment so just put that in the mean time, however the questions for each test will be the same exact ones word for word

Book3.xlsm
ABCDFGHIJ
11234
2
3
4
5Line #Line CodeDescription
6Test - 1Header
7AQuestion 1X or Blank
8Question 2X or Blank
9Question 3X or Blank
10Question 4X or Blank
11BQuestion 5Date
12Question 6Date
13CQuestion 7Number
14G1Question 8Text
15Question 9Text
16G2AQuestion 10Text
17BQuestion 11Text
18G3Question 12Text
19G4Question 13Date
20G5Question 14Text
21G6Question 15Text
22G7Question 16Text
23G8AQuestion 17Text
24BQuestion 18Number
25H1Question 19Text
26Question 20Text
27Question 21Text
28H2Question 22X or Blank
29Question 23X or Blank
30Question 24X or Blank
31H3Question 25Text
32Question 26Text
33H4Question 27Text
34Question 28Text
35H5Question 29X or Blank
361Question 30Number
37H6Question 31X or Blank
38H7Question 32X or Blank
39H8Question 33Number
40H9Question 34Text
41H10AQuestion 35X or Blank
42BQuestion 36X or Blank
43H11Question 37X or Blank
44H12AQuestion 38X or Blank
45BQuestion 39Number
46CQuestion 40Number
47DQuestion 41Number
48H13Question 42Number
49H14Question 43X or Blank
50H15Question 44X or Blank
51Test - 1 -AHeader
52Question 1Text
53Question 2Text
54Question 3Text
55Question 4X or Blank
56Question 5X or Blank
57Question 6Text
58Question 7Text
59Question 8Text
60Question 9X or Blank
61Question 10X or Blank
62TEST - 1 - A1Header
63Question 1Text
64Question 2Text
65Question 3Text
66Question 4X or Blank
67Question 5Text
68Question 6Text
69Question 7Text
70Question 8X or Blank
71Test - 2Header
72AQuestion 1X or Blank
73Question 2X or Blank
74Question 3X or Blank
75Question 4X or Blank
76BQuestion 5Date
77Question 6Date
78CQuestion 7Number
79G1Question 8Text
80Question 9Text
81G2AQuestion 10Text
82BQuestion 11Text
83G3Question 12Text
84G4Question 13Date
85G5Question 14Text
86G6Question 15Text
87G7Question 16Text
88G8AQuestion 17Text
89BQuestion 18Number
90H1Question 19Text
91Question 20Text
92Question 21Text
93H2Question 22X or Blank
94Question 23X or Blank
95Question 24X or Blank
96H3Question 25Text
97Question 26Text
98H4Question 27Text
99Question 28Text
100H5Question 29X or Blank
1011Question 30Number
102H6Question 31X or Blank
103H7Question 32X or Blank
104H8Question 33Number
105H9Question 34Text
106H10AQuestion 35X or Blank
107BQuestion 36X or Blank
108H11Question 37X or Blank
109H12AQuestion 38X or Blank
110BQuestion 39Number
111CQuestion 40Number
112DQuestion 41Number
113H13Question 42Number
114H14Question 43X or Blank
115H15Question 44X or Blank
116Test - 2 -AHeader
117Question 1Text
118Question 2Text
119Question 3Text
120Question 4X or Blank
121Question 5X or Blank
122Question 6Text
123Question 7Text
124Question 8Text
125Question 9X or Blank
126Question 10X or Blank
127TEST - 2 - A1Header
128Question 1Text
129Question 2Text
130Question 3Text
131Question 4X or Blank
132Question 5Text
133Question 6Text
134Question 7Text
135Question 8X or Blank
Sheet3
Cells with Conditional Formatting
CellConditionCell FormatStop If True
D132:D135Cell ValueduplicatestextNO
D128:D131Cell ValueduplicatestextNO
D122:D126Cell ValueduplicatestextNO
D117:D121Cell ValueduplicatestextNO
D71Cell ValueduplicatestextNO
D71Cell ValueduplicatestextNO
D67:D70Cell ValueduplicatestextNO
D63:D66Cell ValueduplicatestextNO
D57:D61Cell ValueduplicatestextNO
D52:D56Cell ValueduplicatestextNO
D6Cell ValueduplicatestextNO
D6Cell ValueduplicatestextNO
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,986
Office Version
  1. 365
Platform
  1. Windows
I am afraid you completely lost me.

Can you show us some actual examples with data (it can be dummy data, it does not need to be real)?
Show us what is in Sheet1, and then how it need to look on Sheet2.
 

drop05

Board Regular
Joined
Mar 23, 2021
Messages
113
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

I am afraid you completely lost me.

Can you show us some actual examples with data (it can be dummy data, it does not need to be real)?
Show us what is in Sheet1, and then how it need to look on Sheet2.
sure thing i will post down below, please let me know if this helps, please note that there are 20 tests but using 2 as an example, if that is okay

Sheet with Dummy data:

Book3.xlsm
ABCDFGHIJ
11234
2
3
4
5Line #Line CodeDescription
6Test - 1Header
7AQuestion 1X or BlankTest answer 1Test 1 answer 1Next test 1 answer 1
8Question 2X or BlankTest answer 2Test 1 answer 2next test 1 answer 2
9Question 3X or BlankTest answer 3Test 1 answer 3Next test 1 answer 3
10Question 4X or BlankTest answer 4Test 1 answer 4Next test 1 answer 4
11BQuestion 5DateTest answer 5Test 1 answer 5Next test 1 answer 5
12Question 6DateTest answer 6Test 1 answer 6Next test 1 answer 6
13CQuestion 7NumberTest answer 7Test 1 answer 7Next test 1 answer 7
14G1Question 8TextTest answer 8Test 1 answer 8Next test 1 answer 8
15Question 9TextTest answer 9Test 1 answer 9Next test 1 answer 9
16G2AQuestion 10TextTest answer 10Test 1 answer 10Next test 1 answer 10
17BQuestion 11TextTest answer 11Test 1 answer 11Next test 1 answer 11
18G3Question 12TextTest answer 12Test 1 answer 12Next test 1 answer 12
19G4Question 13DateTest answer 13Test 1 answer 13Next test 1 answer 13
20G5Question 14TextTest answer 14Test 1 answer 14Next test 1 answer 14
21G6Question 15TextTest answer 15Test 1 answer 15Next test 1 answer 15
22G7Question 16TextTest answer 16Test 1 answer 16Next test 1 answer 16
23G8AQuestion 17TextTest answer 17Test 1 answer 17Next test 1 answer 17
24BQuestion 18NumberTest answer 18Test 1 answer 18Next test 1 answer 18
25H1Question 19TextTest answer 19Test 1 answer 19Next test 1 answer 19
26Question 20TextTest answer 20Test 1 answer 20Next test 1 answer 20
27Question 21TextTest answer 21Test 1 answer 21Next test 1 answer 21
28H2Question 22X or BlankTest answer 22Test 1 answer 22Next test 1 answer 22
29Question 23X or BlankTest answer 23Test 1 answer 23Next test 1 answer 23
30Question 24X or BlankTest answer 24Test 1 answer 24Next test 1 answer 24
31H3Question 25TextTest answer 25Test 1 answer 25Next test 1 answer 25
32Question 26TextTest answer 26Test 1 answer 26Next test 1 answer 26
33H4Question 27TextTest answer 27Test 1 answer 27Next test 1 answer 27
34Question 28TextTest answer 28Test 1 answer 28Next test 1 answer 28
35H5Question 29X or BlankTest answer 29Test 1 answer 29Next test 1 answer 29
361Question 30NumberTest answer 30Test 1 answer 30Next test 1 answer 30
37H6Question 31X or BlankTest answer 31Test 1 answer 31Next test 1 answer 31
38H7Question 32X or BlankTest answer 32Test 1 answer 32Next test 1 answer 32
39H8Question 33NumberTest answer 33Test 1 answer 33Next test 1 answer 33
40H9Question 34TextTest answer 34Test 1 answer 34Next test 1 answer 34
41H10AQuestion 35X or BlankTest answer 35Test 1 answer 35Next test 1 answer 35
42BQuestion 36X or BlankTest answer 36Test 1 answer 36Next test 1 answer 36
43H11Question 37X or BlankTest answer 37Test 1 answer 37Next test 1 answer 37
44H12AQuestion 38X or BlankTest answer 38Test 1 answer 38Next test 1 answer 38
45BQuestion 39NumberTest answer 39Test 1 answer 39Next test 1 answer 39
46CQuestion 40NumberTest answer 40Test 1 answer 40Next test 1 answer 40
47DQuestion 41NumberTest answer 41Test 1 answer 41Next test 1 answer 41
48H13Question 42NumberTest answer 42Test 1 answer 42Next test 1 answer 42
49H14Question 43X or BlankTest answer 43Test 1 answer 43Next test 1 answer 43
50H15Question 44X or BlankTest answer 44Test 1 answer 44Next test 1 answer 44
51Test - 1 -AHeader
52Question 1TextTest answer 1Test 1 answer 1Next test 1 answer 1
53Question 2Texttest answer 2Test 1 answer 2next test 1 answer 2
54Question 3TextTest answer 3Test 1 answer 3Next test 1 answer 3
55Question 4X or BlankTest answer 4Test 1 answer 4Next test 1 answer 4
56Question 5X or BlankTest answer 5Test 1 answer 5Next test 1 answer 5
57Question 6TextTest answer 6Test 1 answer 6Next test 1 answer 6
58Question 7TextTest answer 7Test 1 answer 7Next test 1 answer 7
59Question 8TextTest answer 8Test 1 answer 8Next test 1 answer 8
60Question 9X or BlankTest answer 9Test 1 answer 9Next test 1 answer 9
61Question 10X or BlankTest answer 10Test 1 answer 10Next test 1 answer 10
62TEST - 1 - A1Header
63Question 1TextTest answer 1Test 1 answer 1Next test 1 answer 1
64Question 2Texttest answer 2Test 1 answer 2next test 1 answer 2
65Question 3TextTest answer 3Test 1 answer 3Next test 1 answer 3
66Question 4X or BlankTest answer 4Test 1 answer 4Next test 1 answer 4
67Question 5TextTest answer 5Test 1 answer 5Next test 1 answer 5
68Question 6TextTest answer 6Test 1 answer 6Next test 1 answer 6
69Question 7TextTest answer 7Test 1 answer 7Next test 1 answer 7
70Question 8X or BlankTest answer 8Test 1 answer 8Next test 1 answer 8
71Test - 2Header
72AQuestion 1X or BlankTEST 2 ANSWER 1 Nxt test 2 answer 1
73Question 2X or BlankTEST 2 ANSWER 2Nxt test 2 answer 2
74Question 3X or BlankTEST 2 ANSWER 3Nxt test 2 answer 3
75Question 4X or BlankTEST 2 ANSWER 4Nxt test 2 answer 4
76BQuestion 5DateTEST 2 ANSWER 5Nxt test 2 answer 5
77Question 6DateTEST 2 ANSWER 6Nxt test 2 answer 6
78CQuestion 7NumberTEST 2 ANSWER 7Nxt test 2 answer 7
79G1Question 8TextTEST 2 ANSWER 8Nxt test 2 answer 8
80Question 9TextTEST 2 ANSWER 9Nxt test 2 answer 9
81G2AQuestion 10TextTEST 2 ANSWER 10Nxt test 2 answer 10
82BQuestion 11TextTEST 2 ANSWER 11Nxt test 2 answer 11
83G3Question 12TextTEST 2 ANSWER 12Nxt test 2 answer 12
84G4Question 13DateTEST 2 ANSWER 13Nxt test 2 answer 13
85G5Question 14TextTEST 2 ANSWER 14Nxt test 2 answer 14
86G6Question 15TextTEST 2 ANSWER 15Nxt test 2 answer 15
87G7Question 16TextTEST 2 ANSWER 16Nxt test 2 answer 16
88G8AQuestion 17TextTEST 2 ANSWER 17Nxt test 2 answer 17
89BQuestion 18NumberTEST 2 ANSWER 18Nxt test 2 answer 18
90H1Question 19TextTEST 2 ANSWER 19Nxt test 2 answer 19
91Question 20TextTEST 2 ANSWER 20Nxt test 2 answer 20
92Question 21TextTEST 2 ANSWER 21Nxt test 2 answer 21
93H2Question 22X or BlankTEST 2 ANSWER 22Nxt test 2 answer 22
94Question 23X or BlankTEST 2 ANSWER 23Nxt test 2 answer 23
95Question 24X or BlankTEST 2 ANSWER 24Nxt test 2 answer 24
96H3Question 25TextTEST 2 ANSWER 25Nxt test 2 answer 25
97Question 26TextTEST 2 ANSWER 26Nxt test 2 answer 26
98H4Question 27TextTEST 2 ANSWER 27Nxt test 2 answer 27
99Question 28TextTEST 2 ANSWER 28Nxt test 2 answer 28
100H5Question 29X or BlankTEST 2 ANSWER 29Nxt test 2 answer 29
1011Question 30NumberTEST 2 ANSWER 30Nxt test 2 answer 30
102H6Question 31X or BlankTEST 2 ANSWER 31Nxt test 2 answer 31
103H7Question 32X or BlankTEST 2 ANSWER 32Nxt test 2 answer 32
104H8Question 33NumberTEST 2 ANSWER 33Nxt test 2 answer 33
105H9Question 34TextTEST 2 ANSWER 34Nxt test 2 answer 34
106H10AQuestion 35X or BlankTEST 2 ANSWER 35Nxt test 2 answer 35
107BQuestion 36X or BlankTEST 2 ANSWER 36Nxt test 2 answer 36
108H11Question 37X or BlankTEST 2 ANSWER 37Nxt test 2 answer 37
109H12AQuestion 38X or BlankTEST 2 ANSWER 38Nxt test 2 answer 38
110BQuestion 39NumberTEST 2 ANSWER 39Nxt test 2 answer 39
111CQuestion 40NumberTEST 2 ANSWER 40Nxt test 2 answer 40
112DQuestion 41NumberTEST 2 ANSWER 41Nxt test 2 answer 41
113H13Question 42NumberTEST 2 ANSWER 42Nxt test 2 answer 42
114H14Question 43X or BlankTEST 2 ANSWER 43Nxt test 2 answer 43
115H15Question 44X or BlankTEST 2 ANSWER 44Nxt test 2 answer 44
116Test - 2 -AHeader
117Question 1TextTEST 2 ANSWER 1Nxt test 2 answer 1
118Question 2TextTEST 2 ANSWER2Nxt test 2 answer 2
119Question 3TextTEST 2 ANSWER 3Nxt test 2 answer 3
120Question 4X or BlankTEST 2 ANSWER 4Nxt test 2 answer 4
121Question 5X or BlankTEST 2 ANSWER 5Nxt test 2 answer 5
122Question 6TextTEST 2 ANSWER 6Nxt test 2 answer 6
123Question 7TextTEST 2 ANSWER 7Nxt test 2 answer 7
124Question 8TextTEST 2 ANSWER 8Nxt test 2 answer 8
125Question 9X or BlankTEST 2 ANSWER 9Nxt test 2 answer 9
126Question 10X or BlankTEST 2 ANSWER 10Nxt test 2 answer 10
127TEST - 2 - A1Header
128Question 1TextTEST 2 ANSWER 1Nxt test 2 answer 1
129Question 2TextTEST 2 ANSWER2Nxt test 2 answer 2
130Question 3TextTEST 2 ANSWER 3Nxt test 2 answer 3
131Question 4X or BlankTEST 2 ANSWER 4Nxt test 2 answer 4
132Question 5TextTEST 2 ANSWER 5Nxt test 2 answer 5
133Question 6TextTEST 2 ANSWER 6Nxt test 2 answer 6
134Question 7TextTEST 2 ANSWER 7Nxt test 2 answer 7
135Question 8X or BlankTEST 2 ANSWER 8Nxt test 2 answer 8
Copy
Cells with Conditional Formatting
CellConditionCell FormatStop If True
D132:D135Cell ValueduplicatestextNO
D128:D131Cell ValueduplicatestextNO
D122:D126Cell ValueduplicatestextNO
D117:D121Cell ValueduplicatestextNO
D71Cell ValueduplicatestextNO
D71Cell ValueduplicatestextNO
D67:D70Cell ValueduplicatestextNO
D63:D66Cell ValueduplicatestextNO
D57:D61Cell ValueduplicatestextNO
D52:D56Cell ValueduplicatestextNO
D6Cell ValueduplicatestextNO
D6Cell ValueduplicatestextNO


paste sheet

Book3.xlsm
ABCDE
1Test answer 1TEST 2 ANSWER 1 Test 1 answer 1Next test 1 answer 1Nxt test 2 answer 1
2Test answer 2TEST 2 ANSWER 2Test 1 answer 2next test 1 answer 2Nxt test 2 answer 2
3Test answer 3TEST 2 ANSWER 3Test 1 answer 3Next test 1 answer 3Nxt test 2 answer 3
4Test answer 4TEST 2 ANSWER 4Test 1 answer 4Next test 1 answer 4Nxt test 2 answer 4
5Test answer 5TEST 2 ANSWER 5Test 1 answer 5Next test 1 answer 5Nxt test 2 answer 5
6Test answer 6TEST 2 ANSWER 6Test 1 answer 6Next test 1 answer 6Nxt test 2 answer 6
7Test answer 7TEST 2 ANSWER 7Test 1 answer 7Next test 1 answer 7Nxt test 2 answer 7
8Test answer 8TEST 2 ANSWER 8Test 1 answer 8Next test 1 answer 8Nxt test 2 answer 8
9Test answer 9TEST 2 ANSWER 9Test 1 answer 9Next test 1 answer 9Nxt test 2 answer 9
10Test answer 10TEST 2 ANSWER 10Test 1 answer 10Next test 1 answer 10Nxt test 2 answer 10
11Test answer 11TEST 2 ANSWER 11Test 1 answer 11Next test 1 answer 11Nxt test 2 answer 11
12Test answer 12TEST 2 ANSWER 12Test 1 answer 12Next test 1 answer 12Nxt test 2 answer 12
13Test answer 13TEST 2 ANSWER 13Test 1 answer 13Next test 1 answer 13Nxt test 2 answer 13
14Test answer 14TEST 2 ANSWER 14Test 1 answer 14Next test 1 answer 14Nxt test 2 answer 14
15Test answer 15TEST 2 ANSWER 15Test 1 answer 15Next test 1 answer 15Nxt test 2 answer 15
16Test answer 16TEST 2 ANSWER 16Test 1 answer 16Next test 1 answer 16Nxt test 2 answer 16
17Test answer 17TEST 2 ANSWER 17Test 1 answer 17Next test 1 answer 17Nxt test 2 answer 17
18Test answer 18TEST 2 ANSWER 18Test 1 answer 18Next test 1 answer 18Nxt test 2 answer 18
19Test answer 19TEST 2 ANSWER 19Test 1 answer 19Next test 1 answer 19Nxt test 2 answer 19
20Test answer 20TEST 2 ANSWER 20Test 1 answer 20Next test 1 answer 20Nxt test 2 answer 20
21Test answer 21TEST 2 ANSWER 21Test 1 answer 21Next test 1 answer 21Nxt test 2 answer 21
22Test answer 22TEST 2 ANSWER 22Test 1 answer 22Next test 1 answer 22Nxt test 2 answer 22
23Test answer 23TEST 2 ANSWER 23Test 1 answer 23Next test 1 answer 23Nxt test 2 answer 23
24Test answer 24TEST 2 ANSWER 24Test 1 answer 24Next test 1 answer 24Nxt test 2 answer 24
25Test answer 25TEST 2 ANSWER 25Test 1 answer 25Next test 1 answer 25Nxt test 2 answer 25
26Test answer 26TEST 2 ANSWER 26Test 1 answer 26Next test 1 answer 26Nxt test 2 answer 26
27Test answer 27TEST 2 ANSWER 27Test 1 answer 27Next test 1 answer 27Nxt test 2 answer 27
28Test answer 28TEST 2 ANSWER 28Test 1 answer 28Next test 1 answer 28Nxt test 2 answer 28
29Test answer 29TEST 2 ANSWER 29Test 1 answer 29Next test 1 answer 29Nxt test 2 answer 29
30Test answer 30TEST 2 ANSWER 30Test 1 answer 30Next test 1 answer 30Nxt test 2 answer 30
31Test answer 31TEST 2 ANSWER 31Test 1 answer 31Next test 1 answer 31Nxt test 2 answer 31
32Test answer 32TEST 2 ANSWER 32Test 1 answer 32Next test 1 answer 32Nxt test 2 answer 32
33Test answer 33TEST 2 ANSWER 33Test 1 answer 33Next test 1 answer 33Nxt test 2 answer 33
34Test answer 34TEST 2 ANSWER 34Test 1 answer 34Next test 1 answer 34Nxt test 2 answer 34
35Test answer 35TEST 2 ANSWER 35Test 1 answer 35Next test 1 answer 35Nxt test 2 answer 35
36Test answer 36TEST 2 ANSWER 36Test 1 answer 36Next test 1 answer 36Nxt test 2 answer 36
37Test answer 37TEST 2 ANSWER 37Test 1 answer 37Next test 1 answer 37Nxt test 2 answer 37
38Test answer 38TEST 2 ANSWER 38Test 1 answer 38Next test 1 answer 38Nxt test 2 answer 38
39Test answer 39TEST 2 ANSWER 39Test 1 answer 39Next test 1 answer 39Nxt test 2 answer 39
40Test answer 40TEST 2 ANSWER 40Test 1 answer 40Next test 1 answer 40Nxt test 2 answer 40
41Test answer 41TEST 2 ANSWER 41Test 1 answer 41Next test 1 answer 41Nxt test 2 answer 41
42Test answer 42TEST 2 ANSWER 42Test 1 answer 42Next test 1 answer 42Nxt test 2 answer 42
43Test answer 43TEST 2 ANSWER 43Test 1 answer 43Next test 1 answer 43Nxt test 2 answer 43
44Test answer 44TEST 2 ANSWER 44Test 1 answer 44Next test 1 answer 44Nxt test 2 answer 44
45
46Test answer 1TEST 2 ANSWER 1Test 1 answer 1Next test 1 answer 1Nxt test 2 answer 1
47test answer 2TEST 2 ANSWER2Test 1 answer 2next test 1 answer 2Nxt test 2 answer 2
48Test answer 3TEST 2 ANSWER 3Test 1 answer 3Next test 1 answer 3Nxt test 2 answer 3
49Test answer 4TEST 2 ANSWER 4Test 1 answer 4Next test 1 answer 4Nxt test 2 answer 4
50Test answer 5TEST 2 ANSWER 5Test 1 answer 5Next test 1 answer 5Nxt test 2 answer 5
51Test answer 6TEST 2 ANSWER 6Test 1 answer 6Next test 1 answer 6Nxt test 2 answer 6
52Test answer 7TEST 2 ANSWER 7Test 1 answer 7Next test 1 answer 7Nxt test 2 answer 7
53Test answer 8TEST 2 ANSWER 8Test 1 answer 8Next test 1 answer 8Nxt test 2 answer 8
54Test answer 9TEST 2 ANSWER 9Test 1 answer 9Next test 1 answer 9Nxt test 2 answer 9
55Test answer 10TEST 2 ANSWER 10Test 1 answer 10Next test 1 answer 10Nxt test 2 answer 10
56
57Test answer 1TEST 2 ANSWER 1Test 1 answer 1Next test 1 answer 1Nxt test 2 answer 1
58test answer 2TEST 2 ANSWER2Test 1 answer 2next test 1 answer 2Nxt test 2 answer 2
59Test answer 3TEST 2 ANSWER 3Test 1 answer 3Next test 1 answer 3Nxt test 2 answer 3
60Test answer 4TEST 2 ANSWER 4Test 1 answer 4Next test 1 answer 4Nxt test 2 answer 4
61Test answer 5TEST 2 ANSWER 5Test 1 answer 5Next test 1 answer 5Nxt test 2 answer 5
62Test answer 6TEST 2 ANSWER 6Test 1 answer 6Next test 1 answer 6Nxt test 2 answer 6
63Test answer 7TEST 2 ANSWER 7Test 1 answer 7Next test 1 answer 7Nxt test 2 answer 7
64Test answer 8TEST 2 ANSWER 8Test 1 answer 8Next test 1 answer 8Nxt test 2 answer 8
PASTE
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,986
Office Version
  1. 365
Platform
  1. Windows
So, it looks to me that you just want to copy the answers/values from Sheet1, and copy them to the same row number on Sheet2.
And then each subsequent test/time you run it, move over one column on Sheet2.
Is that correct?

Please let us know the following details:
1. In which column on Sheet1 do the answers we want to copy over reside?
2. What is the FIRST column will be be pasting the answers to on Sheet2?
 

drop05

Board Regular
Joined
Mar 23, 2021
Messages
113
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

So, it looks to me that you just want to copy the answers/values from Sheet1, and copy them to the same row number on Sheet2.
And then each subsequent test/time you run it, move over one column on Sheet2.
Is that correct?

Please let us know the following details:
1. In which column on Sheet1 do the answers we want to copy over reside?
2. What is the FIRST column will be be pasting the answers to on Sheet2?
Wanting it to copy the values starting from column G, go through each test, all have the same range of rows within the test. So as shown in example, G has two tests filled out, keeping in mind that there is 20 tests, all same range of amount of rows in each test just this example using two so excel file wont be so long.
Sheet2 will have test1 from G go in column A, then the test 2 from sheet 1 column G will go into column B. Notices that there is no more values in the next loop through on G. That is all the tests that were filled out from column G sheet 1, so now the loop will make it go to the next row, column H, notice how this one has only test 1, so it gets those values and those will go to sheet 2 the next blank column which is C
There is no test 2 so the loop should move to the next column in sheet 1 so that is column I, that one has both test 1 and 2 so get the values from test 1 column I and paste into next blank column in sheet 2 which in this example will be D. It sees that the next test (test2) has values so grabs those and then goes to paste that into sheet 2 column E since that is the next blank column.

1. The answers start from G7, G6 if you include the header row, as you can see in the above data. Goes all the way down to row 70 being the last row where data will go then test starts with the header at 71 and a value going into row 72. So range of rows within each test, with header 64 without 63. So loop through the first 63/64 the the next until no values in G then go to H and do the same and so on.

2. Can start from A where the pasting begins
 

drop05

Board Regular
Joined
Mar 23, 2021
Messages
113
Office Version
  1. 365
Platform
  1. Windows
So, it looks to me that you just want to copy the answers/values from Sheet1, and copy them to the same row number on Sheet2.
And then each subsequent test/time you run it, move over one column on Sheet2.
Is that correct?

Please let us know the following details:
1. In which column on Sheet1 do the answers we want to copy over reside?
2. What is the FIRST column will be be pasting the answers to on Sheet2?
please let me know if this explanation makes sense or if i need to explain better, i know its a bit confusing that is why i am seeking help and also trying to explain correctly to get that help. I do want to say i appreciate your time and help!
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
58,986
Office Version
  1. 365
Platform
  1. Windows
OK, that is not what I thought was happening at all. I think I am thoroughly confused by it all. o_O
That being said, I am a very visual person, and verbose explanations usually lose me fairly quickly.

Can we take a bit of a different approach? Let's try this:
Walk me through the first few tests, giving me explicit instructions, i.e.
- Tell me that exact range address of the first test on Sheet1, and tell me the exact range address where is it being copied to on Sheet2
- Tell me that exact range address of the second test on Sheet1, and tell me the exact range address where is it being copied to on Sheet2
- Go through a few more iterations like this (like 4 or 5 in total)

If I see if from that standpoint, I will hopefully be able to see the pattern to use.
 

drop05

Board Regular
Joined
Mar 23, 2021
Messages
113
Office Version
  1. 365
Platform
  1. Windows
OK, that is not what I thought was happening at all. I think I am thoroughly confused by it all. o_O
That being said, I am a very visual person, and verbose explanations usually lose me fairly quickly.

Can we take a bit of a different approach? Let's try this:
Walk me through the first few tests, giving me explicit instructions, i.e.
- Tell me that exact range address of the first test on Sheet1, and tell me the exact range address where is it being copied to on Sheet2
- Tell me that exact range address of the second test on Sheet1, and tell me the exact range address where is it being copied to on Sheet2
- Go through a few more iterations like this (like 4 or 5 in total)

If I see if from that standpoint, I will hopefully be able to see the pattern to use.
sure thing, if you give a me a few minutes i can put that request together, ill post in the comments when done and tag in case it is later in the day
I do apologize for the confusion and i appreciate the patience
Id really appreciate the help sir
 

Forum statistics

Threads
1,141,298
Messages
5,705,567
Members
421,399
Latest member
hjweiss00

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top