Posted: 18 Dec 2018 18:17 EST Last activity: 3 Jan 2019 9:23 EST
How to append range of data in a new Excel Workbook in a single sheet in each iteration.
My used case requires filtering data in one excel application and paste it into another. The Filter parameter is based on date and the result is range of data in each iteration. I have been able to figure out the filtration and export part but every time I import, the old range of data copied in the destination excel sheet gets replaced by the new range. I found counter tool from the tool box as a possible solution to set the cell values for next iteration, but I have not been able to figure out how to make it work for the range of data basically to append in the same worksheet not replacing what I already have.