Dear Experts,
I will need a macro and would like your help in this. I have a set of columns in an Excel sheet.
ColA ColB ColC ColD ColE
1 X 12 23 32
2 X 13 78 6
3 X 77 34 8
4 Y 88 55 38
5 Y 25 89 23
-
-
-
-
-
-
-
-
-
25 Z 55 94 29
If you check this table Col B has three values of X, two values of y etc. which means that 1,2,3 belong to the same group, 4 and 5 to the same group an so on.
I would like to export the data that contains Col B = X into one word file, Col B = Y into another word file and so on with Col B values as the filename. All these have to be stored in a specified directory. How can I do this? Can I have a macro to do this.
Also is there a possibility of selecting the columns that I would like to export before the export?
Thanks in advance for the help
Regards,
E-tech
Bookmarks