Jul-14-2020, 07:59 PM
How would I go about making ws2 increment by one cell every time it loops to the next file? The cell data for ws1 can remain the same because it's always the same cell data for each file. But ws2 is the template, and I need the cell that the data gets pasted into to increment each time the for loop grabs the next file.
ws2['A2']=ws1['A1].valuewould work if I wasn't looping through files, and only had one file to copy and paste from. On the next file I would need it to be
ws2['A3']=ws1[A1'].valueso ws2 incremented by one.