skunkworks
New Member
- Joined
- Jan 21, 2022
- Messages
- 21
- Office Version
- 2016
- Platform
- Windows
In the royalty spreadsheet shown here, authors and their books are listed. Some authors may have only one book, while others may have a dozen. "Author Total Royalty" is a calculated field. I would like to be able to extract the author's name and "Author Total Royalty" into another worksheet. How can this be done?