Closed Thread
Results 1 to 2 of 2

Consolidate/Merge multiple worksheets using VBA or excel formula

Hybrid View

Aoleone# Consolidate/Merge multiple... 07-15-2015, 06:22 AM
Aoleone# Re: Consolidate/Merge... 07-26-2015, 05:54 PM
  1. #1
    Registered User
    Join Date
    05-10-2015
    Location
    Ann Arbor
    MS-Off Ver
    M365
    Posts
    83

    Consolidate/Merge multiple worksheets using VBA or excel formula

    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#
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-10-2015
    Location
    Ann Arbor
    MS-Off Ver
    M365
    Posts
    83

    Re: Consolidate/Merge multiple worksheets using VBA or excel formula

    I have posted the thread in the commercial services, please close this thread

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Merge/Consolidate Worksheets Based Upon Column Name
    By StrongEagle in forum Excel General
    Replies: 1
    Last Post: 09-03-2014, 03:06 PM
  2. [SOLVED] Merge/Consolidate Multiple Workbooks data into a Single Sheet
    By COLIN_303 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-08-2012, 04:53 AM
  3. [SOLVED] Merge/Consolidate Multiple Timesheet data into a Single Sheet
    By dingbat in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-11-2012, 12:51 PM
  4. Consolidate/Merge Worksheets
    By karlr9 in forum Excel General
    Replies: 0
    Last Post: 07-22-2009, 01:29 PM
  5. Merge / Consolidate Worksheets
    By Hoopsah in forum Excel General
    Replies: 4
    Last Post: 08-02-2007, 07:47 AM
  6. combine, merge, consolidate worksheets
    By biglu in forum Excel General
    Replies: 6
    Last Post: 12-05-2006, 05:40 PM
  7. How do I merge multiple worksheets in excel ?
    By rene in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1