Hi,
I'm trying to achieve this but this is beyond my VBA skills.
I have a worksheets called "Results" on which in column "E" there is multiple sequence numbers (for example 12140, 12008, 12993...).
The sequence number will be repeated a variable number of times.
The data are already sorted. With a macro, I would like to be able to find all the matching sequence numbers and copy the sequence number (in column E) and the corresponding sample names in column A. The data would then be pasted on a different sheet (sheetname = sequence number, ex: 122140). I would then like to repeat this process for each different sequence number.
Here is a typical data set:
Thanks for your help!!
I'm trying to achieve this but this is beyond my VBA skills.
I have a worksheets called "Results" on which in column "E" there is multiple sequence numbers (for example 12140, 12008, 12993...).
The sequence number will be repeated a variable number of times.
The data are already sorted. With a macro, I would like to be able to find all the matching sequence numbers and copy the sequence number (in column E) and the corresponding sample names in column A. The data would then be pasted on a different sheet (sheetname = sequence number, ex: 122140). I would then like to repeat this process for each different sequence number.
Here is a typical data set:
Sample | Value | Units | factor | Sequence | Comment |
6442-01 | 0.0010 | 1 | 12140 | test A | |
6442-02 | 1.0010 | 1 | 12140 | Test A | |
6442-03 | 2.0010 | 1 | 12140 | test B | |
6442-04 | 3.0010 | 1 | 12952 | test b | |
6442-05 | 4.0010 | 1 | 12952 | test b | |
6442-06 | 5.0010 | 10 | 12008 | test b | |
6442-07 | 6.0010 | 1 | 12008 | test b | |
6442-08 | 7.0210 | 1 | 12008 | test b | |
6442-09 | 8.0010 | 1 | 12008 | test b | |
6442-10 | 9.0010 | 1 | 12008 | test b | |
6442-11 | 10.0010 | 1 | 12008 | test b | |
6442-12 | 11.0010 | 1 | 12008 | test b | |
6442-13 | 11.0010 | 1 | 12008 | test b | |
6442-14 | 13.0010 | 1 | 12008 | test b | |
6442-15 | 14.0010 | 10 | 12008 | test b | |
6442-16 | 15.0010 | 1 | 12993 | test b |
Thanks for your help!!