jacque
08-31-2017, 01:51 PM
I have the following string in sheet 1 column A. If you notice, the first left strings are a sequential number.
I want to copy the complete row to sheet 2 column A from for example number 158 to 170.
These numbers changes every run, actually the I have about 1800 rows. I like the code refers to cell B1, and B2, to obtain these numbers, and then run the macro.
154,"9001203","0007541","0000000000"
155,"0002551","0005548","0000000000"
156,"9019074","0002361","0000000000"
157,"0004501","0008363","0000000000"
158,"9016847","0005085","0000000000"
159,"0003769","0000501","0000000000"
160,"0003880","0001990","0000000000"
161,"9012481","0009726","0000000000"
162,"0004789","0009769","0000000000"
163,"9011637","0009674","0000000000"
164,"9007373","0009536","0000000000"
165,"9015222","0009814","0000000000"
166,"9013953","0009426","0000000000"
167,"9022671","0009808","0000000000"
168,"9003903","0009692","0000000000"
169,"9026207","0009793","0000000000"
170,"9025813","0009486","0000000000"
171,"0003574","0009408","0000000000"
172,"9006220","0009620","0000000000"
173,"9010121","0009634","0000000000"
174,"9024978","0009724","0000000000"
I want to copy the complete row to sheet 2 column A from for example number 158 to 170.
These numbers changes every run, actually the I have about 1800 rows. I like the code refers to cell B1, and B2, to obtain these numbers, and then run the macro.
154,"9001203","0007541","0000000000"
155,"0002551","0005548","0000000000"
156,"9019074","0002361","0000000000"
157,"0004501","0008363","0000000000"
158,"9016847","0005085","0000000000"
159,"0003769","0000501","0000000000"
160,"0003880","0001990","0000000000"
161,"9012481","0009726","0000000000"
162,"0004789","0009769","0000000000"
163,"9011637","0009674","0000000000"
164,"9007373","0009536","0000000000"
165,"9015222","0009814","0000000000"
166,"9013953","0009426","0000000000"
167,"9022671","0009808","0000000000"
168,"9003903","0009692","0000000000"
169,"9026207","0009793","0000000000"
170,"9025813","0009486","0000000000"
171,"0003574","0009408","0000000000"
172,"9006220","0009620","0000000000"
173,"9010121","0009634","0000000000"
174,"9024978","0009724","0000000000"