May Peace be on everyone here !
I have a big sales sheet which has columns like date, items, amount and customer name, etc. Now what I want is following:
1. filter a specific customer,
2. copy visible data related to that customer
3. paste in a new sheet
4. name that sheet with the name of customer.
Therefore if there are 25 customers, then there will be 25 sheets with their respective customer names.
Please help me in doing that with macro, or anything !
Thanks !
I have a big sales sheet which has columns like date, items, amount and customer name, etc. Now what I want is following:
1. filter a specific customer,
2. copy visible data related to that customer
3. paste in a new sheet
4. name that sheet with the name of customer.
Therefore if there are 25 customers, then there will be 25 sheets with their respective customer names.
Please help me in doing that with macro, or anything !
Thanks !