I have an external table that I would like to download to excel each month and then create journal entries. The rows on the external file vary per month. I would like to set this up so I'm not having to copy/paste or creating new formulas each month. Below is an example of the external table and what I would like the end result to look like. . Please let me know if this is possible.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.