Hi, I have plenty of spreadsheets with same columns but different data (the old database extracted the data grouped in small fractions by separate files). I need to merge all those files into one only. Is there an easy way to do this? Many thanks for help
Hi, I thought it was working as suggested but I have actually just noticed that the tFileList component iterates through 12 folders where I have my files, but the output is taken from the very last folder only. What am I doing wrong? See attached screenshots to see the component settings, all files in subdirectories are named c5_contact. Many thanks for help.
Good point thanks but if I use 'Apend Existing File', the output is same.. and if I add 'Apend Existing Sheet' (dont really know what the difference is) I get the error attached.. Im not code oriented so I dont understand it.