@ppr … I have tried to apply the solution to my project scenario. I just tried with one input file(Report) and try to write into output file (Summary). Below are the issues i am facing:
Write range is throwing an exception error. I think its run time error. May be because of the memory. My input file contains close to 36K rows. Attached the error screenshot.![Error|690x277]. But when i verified the counts, output has all the expected rows. Not sure why its throwing the error.
I am expecting to write the All the states alphabetically after the sheet1. ie. Sheet1, AL, GA, ID, IL etc…if you see the below screenshot it’s other way around.