S
Sinner
Hi,
I have around 25 text files with pipe sign delimited data.
Header lines start at row 9.
I want to consolidate all the data in one worksheet named DATA.
Requirement is as follows:
- Worksheet data is of three columns.
..columnA header is Category
..columnB header is Number
..columnC header is LOCATION
- A group of text files have required data in columnB & another in
columnC. So these group of files need to be defined in import
sequence.
- Import values from all text files as text.
- Text file name are 1,2,3,4,5......25. The Category name should be a
list of names like for 1 its 'K', for 2 its, 'P' an so on making it
possible to modify later on as well.
Once the data is imported from file 1 text file, the data should goto
columnB & category should be 'K' for all data & so on for rest of the
files accordingly.
A 'TEMP' sheet will help to make sure we can modify import
requirements from there instead the main code.
Sample file is at
http://www.savefile.com/files/1786679
Any help is appreciated.
Thx.
I have around 25 text files with pipe sign delimited data.
Header lines start at row 9.
I want to consolidate all the data in one worksheet named DATA.
Requirement is as follows:
- Worksheet data is of three columns.
..columnA header is Category
..columnB header is Number
..columnC header is LOCATION
- A group of text files have required data in columnB & another in
columnC. So these group of files need to be defined in import
sequence.
- Import values from all text files as text.
- Text file name are 1,2,3,4,5......25. The Category name should be a
list of names like for 1 its 'K', for 2 its, 'P' an so on making it
possible to modify later on as well.
Once the data is imported from file 1 text file, the data should goto
columnB & category should be 'K' for all data & so on for rest of the
files accordingly.
A 'TEMP' sheet will help to make sure we can modify import
requirements from there instead the main code.
Sample file is at
http://www.savefile.com/files/1786679
Any help is appreciated.
Thx.