Update Excel Report with changing data
Posted on 2014-03-11
I'd like to create a set of reports in Excel that will provide us some charts and trends, etc. from Quickbooks data we import.
QB offers a simple way to export data to Excel, so I'm interested in creating a stock report file that will update the reports from a sheet of data we import.
The only problem that confuses me is how that works when the data changes that is imported. By changes, I mean that new rows may be added.
I'm not sure what to look up to find the answer for this so hopefully I can get some insight in what to look into.