Excel Macro

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 Ive 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 recuiter
Member since Mar 14, 2020
Sujit Lampat
from Shizuoka, Japan

---

---

Offer to work on this project closes in 52 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions