Hi,
. OK I think I am alomost with you now..
Quote Originally Posted by shido View Post
...... However, if you still require any clarification, please do let me know......
. a couple of questions..
. 1) You have shown your names in the "After" shown in order

Using Excel 2007
Row\Col
A
B
C
D
E
F
G
H
1
Move to Master List
Move to Master List
2
Name List
Designation 1
Designation 2
Designation 3
Designation 4
Designation 5
Designation 7
Designation 14
3
 Name 1
1
11
21
31
41
1
11
4
 Name 2
2
12
22
32
42
2
0
5
 Name 3
3
13
23
33
43
3
13
6
 Name 4
0
0
0
0
0
4
14
7
 Name 5
5
15
25
35
45
0
15
8
 Name 6
6
16
26
36
46
6
16
9
 Name 7
7
17
27
37
47
7
0
10
 Name 8
8
18
28
38
48
8
18
11
 Name 9
9
19
29
39
49
0
19
12
 Name 10
10
20
30
40
50
10
20
13
 Name 11
0
0
0
0
0
0
21
14
15
Master

.........
. I guess this is because our imaginary names have a number on the end.
. But for real names, Tom ****, Harry etc., then the added order is unimportant?
.
. so this would be just as valid?

Using Excel 2007
Row\Col
A
B
C
D
E
F
G
H
1
Move to Master List
Move to Master List
2
Name List
Designation 1
Designation 2
Designation 3
Designation 4
Designation 5
Designation 7
Designation 14
3
 Name 1
1
11
21
31
41
1
11
4
 Name 2
2
12
22
32
42
2
0
5
 Name 3
3
13
23
33
43
3
13
6
 Name 5
5
15
25
35
45
0
15
7
 Name 6
6
16
26
36
46
6
16
8
 Name 7
7
17
27
37
47
7
0
9
 Name 8
8
18
28
38
48
8
18
10
 Name 9
9
19
29
39
49
0
19
11
 Name 10
10
20
30
40
50
10
20
12
 Name 4
0
0
0
0
0
4
14
13
 Name 11
0
0
0
0
0
0
21
Master List

Correct?
.....................................................

. 2) Are the destination headings always written such:
Designation 4, Designation 6
. ..etc with a number on the end which is used to determine the order, or is the order of the columns also not important?

Alan