There are 202 different Publishers (column AM) each with a varying number of rows.
Can you develop a macro that will take all the rows of each Publisher and save it as a separate Excel doc? So would end up with 202 different files.
I've attached an example of how it would look for "Aaron LeClair CC", ideally with the header rows and blue total row too but not essential.
I will need to be shown how to do this so I can do it myself on other documents.
13 freelancers are bidding on average £72 for this job
i can do This manually if you need .i have read your project detail and ready to work.i have relevant skills and experience for this project. Please review my profile and inbox me. Thanks Abdul Haleem
• I am very good at Excel and building up formulas that automatically carry calculations. Let's discuss your requirements in more details. Send me a message and will be happy to help you out.