copy entire column instead of rows

Originally Posted by shido

Hi Alan,
Sorry for the confusion. Naming order would entail mixup of numbers and text.
For example: the list would start with QS001, QS002, .... to QS072. After QS0072, there may be some text such as manual handling, GDP, GMP.......I would say anything with text can be added in the next available row, whereas, anything with number would require order to be maintained, if possible. .....,

.
.

. It may be, dependinng on how / when you input data that my logic may autometically get what you want.
.
. let us have a look later when I have a code................
......................................
.
. In the meantime, think again about some test data ( still limited in size please to under 10 rows, if possible - if not then the maximum you need ) that would realistically reflect the possible combinations of those text and numbers

Alan