I would like the macro to do the following :
convert multiple .txt files in a folder
should delimit the .txt files so that there are headers in each column
format for date (1st column) should be in DDMMYY format
place all data from .txt files into 1 .xls file
scan through the data in .xls file
ensure all data are unique (ie. no repeated data in each row)
Is the above feasible ?