I currently have 2 worksheets in an excel file, mainly Sheet1 and Sheet2.
How can I pass the new data from Sheet1 to Sheet2 without overwriting the existing data in Sheet2?
I have tried reading range activity for Sheet 1 and appending range for Sheet2 before using write activity for Sheet2. I’m not sure what I’m doing incorrectly.
I have to keep adding new data to Sheet1 and append it to Sheet 2. Please help!