How to format Revenue data in Excel
Each time I download my revenue data (CSV file) and import it into Excel, I then have to format the spreadsheet (e.g. adjust column widths, and then add Excel functions to make sense of the data).
For example, I use the =SUM function to add up the Quantity and Earnings columns. I also use the =COUNTIF function to create separate sub-totals per individual book title. Other formulae allow me to see how profitable each book title is.
Rather than do this manually each time, may I ask if anyone has developed a Visual Basic macro in Excel to automate the whole thing?