Hi Everyone
I'm trying to consolidate a massive spreadsheet record of cash collections from new vending machines. Each workbook represents a month's cash collections with sheets/tabs named based on dates of collection. There could be multiple collections in day so the worksheets are quite many. As mentioned earlier all the tabs/sheets are names based on the date of collection, however, sheets with names 'Old' at the end refer to old vending machines. As well there is a second table which I want to summarise as a sort of invoice. I have attached a sample with a few examples of how I want to consolidate the data. The columns/fields under needed in the daily sheets are those highlighted in grey. The daily sheets may contain some comments or working and I want keep them as it is without affection the vba code or formula. Any help is much appreciated.
AOL#
Bookmarks