Apolgies Upfront: Extracting accounting data for 3 years - either Index or VLookup.
We have the ability to print and export Quickbooks Enterprise Data into excel. However, we want to compare the years 13, 14 and 15. However, the customer names can be on 1 or more of the lists or not at all. Can someone be kind and point in the the right direction as to having 3 tabs or data, same fields, different year end date and place on a new tab.
CUSTOMER 13 | 14 | 15 |
Hopefully all customers will be listed and the sales totals would be in each of the respected cells.
I sure appreciate it.