Automatic Invoice Consolidation

See attached spreadsheet exports.xls... I receive these exports every week and I need these invoices to be consolidated by invoice by week on another tab in the same spreadsheet.

So for example, if you're looking at the attached file, exports.xls, the first 6 records are for invoice# 6480191. I need this information consolidated on another spreadsheet (see attachment results.xls)

Your input is appreciated !!!

You could use a Pivot Table.

Those are the columns I kept (based on your "results" file). The way I figured out how to do it is by doing your total amount of taxes for each seperate invoice (with the Sum formula or manualy). Add your total tax amount for every invoice and keep the following columns for every different invoice:

Invoice #
Division Desc
Amount

Select just the cells (with your title row), go in Data at the top and pick PivotTable report.

Click next twice (well that's what I do because the standard settings get me what I need) and on the 3rd page, you can pick wether you want your table on a new workbook or a new sheet. Pick the one you need.

When you click "End", you'll have a small window that should pop up with your different fields.
When you get there, just place your different fields where ever you would like.

I'm not a pro but that's how I'd do it. Also, attached is the file I used from your Exports attachment. It's what I had just before doing the pivot table. You can't use more than 3 columns for the Pivot Table (at least, not that I know of) so that's why I do a sum, paste the value in a new column so that your taxes for each specific invoices follow as a full, complete amount, just like you put in your results workbook. You could either split each invoice before doing the pivot or after. If you want, you can select the lines for the table, get to a new tab, right click on the line you want, click special paste (or something like that) and paste only the values.

I hope this helps. I wish I was better with excel so that it could be easier to explain and to execute but once you get the twist, it's a fast process.

Good luck!

Thanks watersev, this will help me get to wherever I need to .... basically I'll need to append new records each week instead of creating a new tab but I can figure that out from your coding. Thank you.