Challenge for the VB experts

[g_purve]

Hello, I am trying to re-lable the first column of data into sections, usually 60 sample increments, in order to post process all of the samples that are contained within the recorded section.
So I have a worksheet with column showing test step = usually ranging from 0-10 and the data recorded is displayed in the other columns.

There are usually 60 samples recorded per test step.

Currently I am having to select 60 cells and input the test step value manually into the cells then manually select the next 60 and input the test step value until I reach the end of the test.

I have a user input window that asks the operator how many data points are recorded in each test step, then stores the answer as variable.
Then I have a user input window that asks the operator how many test steps are performed, then stores the answer as variable.

I am having trouble because I can't get the for loop to properly lable the test step number more than one time.
Please help

 

[g_purve]

Exactly, I will try the code out first thing in the morning. Thanks again for the help

 

[g_purve]

Thanks Jproffer for the time and help. This does exactly what I was trying to do.

 

[jproffer]

No problem. Glad that did the trick. Thanks for following up.