I have a query regarding how to Divide Master sheet into separate working sheets based on paticular column filter.
For example we have a master sales data sheet. In this master sales data we have columns like product, month, city, No. of products sold and sales volume. I have applied filtered to the data and we have 10 cities in city column.
I want to get filtered data based on each city in different worksheets from the master sales data sheet. How could I do it?