ashleywanless
Board Regular
- Joined
- Aug 4, 2009
- Messages
- 158
Hi,
I have a macro which produces a worksheet of specific questions according to what criteria a user choses on a userform. It then copies this data into a new tab. There are 3 columns, Question Number, Question and Evidence.
My problem is that because the data copied is a mere extract of a much larger question set the question numbers in column A do not run concurrently. e.g 1,2,5,6,7,9,10 etc etc. I need to find a way of making these numbers in the extract sheet run concurrently. This can't be a simple as typing 1 in cell A3, 2 in cell A4, 3 in cell A5 then sending down the page as the copied data contains grey header lines. These do not have a question number in column A instead they have a H.
Can anyone think of how to do this? so that the numbers in cells A3 onwards run concurrently unless the Value H is anywhere in column A, in which case the H should be left and the next cell should continue the numbering sequence?
Thanks
Ashley
I have a macro which produces a worksheet of specific questions according to what criteria a user choses on a userform. It then copies this data into a new tab. There are 3 columns, Question Number, Question and Evidence.
My problem is that because the data copied is a mere extract of a much larger question set the question numbers in column A do not run concurrently. e.g 1,2,5,6,7,9,10 etc etc. I need to find a way of making these numbers in the extract sheet run concurrently. This can't be a simple as typing 1 in cell A3, 2 in cell A4, 3 in cell A5 then sending down the page as the copied data contains grey header lines. These do not have a question number in column A instead they have a H.
Can anyone think of how to do this? so that the numbers in cells A3 onwards run concurrently unless the Value H is anywhere in column A, in which case the H should be left and the next cell should continue the numbering sequence?
Thanks
Ashley