Thank you for replying, my objective is basically appending new row everytime there’s a new data (which is every month)
i send two excel file for example, i want the “B” file to be appended to the “A” files, and since there will be new report for every two months, i want it to be appended as well next time i have a new report (for example “c” files) to the same “A” files.
i dont need to add the rows, because the format is actually the same, so it should always have the same number of rows. it will be good to have additional protection against duplicates tho, so the next time i reiterate the automation, the same “B” files dont get duplicated again…
Please show me the way, thank you so much
A.xlsx (8.3 KB)
B.xlsx (8.4 KB)