Hi guys,
I would like to ask a little help.
I have a report about sales figure. The report contains a lot of sales data of all of the customers.
What I would need to do is to create a macro which will create the same report but instead of having all customer together, it would create a file for each customer separately.
What I was thinking that it would look through the Data sheet's Customer column and it would always chose a customer, then deletes all other customer, and then saving the file with the name of the customer.
Would you help me a little with the macro, how should i start it. I'm kind of stuck with it already at the beginning, how to create a loop to filter all separate customers.
Thank you for the help!!!
I would like to ask a little help.
I have a report about sales figure. The report contains a lot of sales data of all of the customers.
What I would need to do is to create a macro which will create the same report but instead of having all customer together, it would create a file for each customer separately.
What I was thinking that it would look through the Data sheet's Customer column and it would always chose a customer, then deletes all other customer, and then saving the file with the name of the customer.
Would you help me a little with the macro, how should i start it. I'm kind of stuck with it already at the beginning, how to create a loop to filter all separate customers.
Thank you for the help!!!
