mchilapur
05-17-2014, 10:28 AM
Hello All,
Can you plz help me out with below situation.
Below i have excel columns with headers 10 to 100 as shown.
10
20
30
40
50
60
70
80
90
100
And i have a input data as below (Top Row is header and 2nd row is values),
10
20
50
70
90
100
A
B
C
D
E
F
Now i need as VBA code to Compare Input data headers with standard headers (i,e 10 to 100) and paste the respective values below. If the Input header is not having any of the number, then it must return 'Nil' in the main header.
I simple words, i need output as below,
10
20
30
40
50
60
70
80
90
100
A
B
Nil
Nil
C
Nil
D
Nil
E
F
Plz provide me the VBA code.
Thanks in advance
Madvesh
Can you plz help me out with below situation.
Below i have excel columns with headers 10 to 100 as shown.
10
20
30
40
50
60
70
80
90
100
And i have a input data as below (Top Row is header and 2nd row is values),
10
20
50
70
90
100
A
B
C
D
E
F
Now i need as VBA code to Compare Input data headers with standard headers (i,e 10 to 100) and paste the respective values below. If the Input header is not having any of the number, then it must return 'Nil' in the main header.
I simple words, i need output as below,
10
20
30
40
50
60
70
80
90
100
A
B
Nil
Nil
C
Nil
D
Nil
E
F
Plz provide me the VBA code.
Thanks in advance
Madvesh