Hi.. need help here, I'm fairly new in VBA coding I've been searching the forum but i can't find similar case..
I need to generate multiple notepad files from an excel file..
Each text file has to be exported when it belongs to the same file name in column A, that is, column B will be part of the text file in column A namefile. it is somewhat confusing to explain; is something like this
COLUMN A COLUMN B
1 -FIL_NAME Information
V210201003 LINEA1
V210201003 LINEA2
V210201003 LINEA3
V210201003 LINEA4
V210201009 LINEA1
V210201009 LINEA2
V210201009 LINEA3
V210201010 LINEA1
V210201010 LINEA2
V210201011 LINEA1
Tetx file V210201003 will contains the information of column B
Text File V210201003
LINEA1
LINEA2
LINEA3
LINEA4
Text File V210201009
LINEA1
LINEA2
LINEA3
Text File V210201010
LINEA1
LINEA2
And the file name is based on the column A..
Could anyone help me?
I'd appreciate any help
thanks.
Bookmarks