Hi guys, I want to write filtered data from first excel file to second excel file, I am able to filter the data from first excel file and I am able to write the filtered data into second excel file, but my question is once I am writing to second excel file(The data which is already in second excel file is not erasing it, and it is rewriting with the filtered one)
-> I want to rewrite the complete excel file with filtered data which is extracting from the first file. Can anyone suggest me how to solve this?
Thanks in advance!!!