learn72
11-11-2017, 12:48 AM
Can we copy specific columns in vba from active workbook to a closed workbook in a specific directory.
Suppose active workbook assuming row 1 are headers , copy column A , C,D, E, F AND AA to a close workbook on c:\\testdata\keeprecords
row1 are SAME HEADERS as active worbook .
A
C
D
E
F
AH
A
B
C
D
E
F
Suppose active workbook assuming row 1 are headers , copy column A , C,D, E, F AND AA to a close workbook on c:\\testdata\keeprecords
row1 are SAME HEADERS as active worbook .
A
C
D
E
F
AH
A
B
C
D
E
F