Write into Excel with file name and data split based on a row value

How to write excel file where one column’s value defines the splitting of data and sheet name.

The output for the above sample should be in 2 sheets names January and February and the data corresponding to those rows only in the respective sheets

Maybe this example Excel Writer Loop - #2 by ScottF gives you an idea how to approach your task.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.