Posted 8 September 2017, 12:52 pm EST
how can I compose one big spreadsheet with the data of several excel files.
All the excel files are identically formatted, i.e. they have the same columns. Only the number of rows can differ.
I want to add the content of the newly opened excel file to the data of the allready openend excel files into the spread.
Is this possible, because I tried working with a main and temporary sheet, opening the new excel files in the temporary before adding them to the main using ClipboardPaste, but I cannot define from where (a row) the paste operation has to start, it allways pasts over the old content, and so it replaces instead off adding new rows.
What am I doing wrong?
Thanks in advance,