creating macro for biffurcation in sheets according to data.
I have data containing column of zone (i.e state). I want that the sheet should diffurcate into sheets according to the states & also mentioning tha name of sheet according to the data (i.e if the data is of andhra pradesh, then the name of sheet should be andhra pradesh). The sample data of raw & result file is attached. the no of rows will be flexible & minimum rows will be 20000. the data of states will also change monthly. Thanks in advance.
|