Hi there,
I need someone who can write an excel macro to be applied to many spreadsheets going forward. I handle a publishing company and need to be able to quickly sort through long lists of data and make it readable. The data reflected in these statements is confidential, so I've prepared sample documents to work from - I need a macro to be built that can work for the real documents going forward. I may want to add details / features in the future for an extra fee, so would love to find someone great!
In the sample spreadsheet, there are 4 writers: labeled 'WRITER 1,' WRITER 2,' and so on.
I need to be able to efficiently sort by writer and spit out separate documents for each.
See 'WRITER STATEMENT TEMPLATE' for a sample layout of what I need.
On the cover page, I need the following:
1. Total earned for this writer at the top
2. Totals for each 'RIGHT_TYPE_GROUP' and subsequently, each 'RIGHT_TYPE'
3. Top 9 earning territories, followed by an 'other' section to bundle the lesser earning territories together
Then, on the next page, all the excruciating detail listed out.
About the recuiterMember since Mar 14, 2020 Ben Juda
from Queretaro, Mexico