consolidating data

  1. 1

    Merging Data from Multiple workbooks into a summary sheet with 5 Worksheets

    A fairly complex bit of coding here - hats off to anyone able to do it. :cool: I have multiple workbooks in a specified folder that I need to summarise in a summary workbook. These workbooks contain data in 5 categories on one sheet (capital, resource, etc), and I need to summarise each...
  2. M

    Consolidating two worksheets onto a third worksheet

    Hi, Trying to consolidate 2 worksheets that have invoice numbers and payment status onto one worksheet but having difficulty. :( The solution shows the invoice numbers in ascending order and when a match is made the invoice numbers and their status should be put onto the same row. If a...
  3. A

    Consolidating Duplicate Data

    Hi, I have a sheet that tracks consignments and parcels. However what i want to do is to consolidate it by consignment number. As you can see by the table below each consignment has more than one row relating to it. For payroll purposes i want to pay by consignment if that makes sense...
  4. G

    Copying multiple tabs in a workbook to one master sheet

    Hi I have a workbook that contains numerous tabs. Each tab is a new vendor and contains information in a table format. Every tab/table is the same. I would like to find an easier way to get all of the data into one sheet rather than copying the table from sheet 2 paste into cell A1 of sheet 1...
  5. A

    Consolidating 2 Excel Workbooks into one workbook

    I am trying to consolidate 2 Excel workbooks that have multiple tabs. There are 2 people working out of the same workbooks each saved to their own computer but not necessarily working on the same tab. Anyways, once each person has worked their sections then it is time to combine the tabs in...
  6. M

    Consolidating data with a formula.

    I need to identify (and eliminate) duplicate cells in column "A" and combine/merge correlating cells (cells adjacent to duplicate cells) in column "B" I need to combine so that I don't lose information in the cells in column "B". I was hopeful that I could create a formula that could achieve...
  7. H

    master worksheet pulls from multiple workbooks

    Master worksheet showing a list of consolidated data , specifically daily sales ranging from first of the month to last day of the month. Master worksheet Column A has dates, Column B has cash totals, column C has Credit card totals. Column B and C ref sales totals pulled from different...
  8. D

    Consolidate Values Complicated Methodology

    I need help trying to consolidate trial balance values from specific sub accounts into general accounts. I have tried many different loops, offsets, filters and copying combinations and have failed miserably. I am using Excel 2010 and running Windows 7 Professional. The example I want to do is...
  9. R

    Consolidating Various Lists into one

    I have many different lists that span from A1:AM1057 that hold 2 lines of data per list. So A2,C2,E2,...etc = Stage, and B2,D2,...etc = Call Procedure. Each list hold bits of data that offset the other lists and i would like to consolidate all of the data into one master Stage list from...
  10. M

    Consolidation of Data

    I use excel to input certain recipes. Let's say we have recipe a, b, c and d. From each recipe i have different types of ingredients. Lets say we have 5, 7, 10, 8 ingredients for recipes a to d, respectively. There are some ingredients that are common on some recipes (a to d). I used this 4...
  11. A

    Mass Mailing Mail Merge, Help Needed!

    Hello Everyone! My Boss is running for public office and we need to do a mass mailing. In order to cut down on expenses; however, we need to consolidate the fields in excel to eliminate the households with more than 1 registered voter (so they dont receive multiple mailings), or, if possible...
  12. E

    consolidating data from multiple workbooks

    I currently have to consolidate data from multiple workbooks into a single file. The format of the data is the same and each workbook has the data already selected. Is there a way to automate this using a macro? I am envisioning the following... 1) Summaryworkbook.summaryWorksheet - this would...
  13. E

    consolidating data from multiple workbooks

    I currently have to consolidate data from multiple workbooks into a single file. The format of the data is the same and each workbook has the data already selected. Is there a way to automate this using a macro? I am envisioning the following... 1) Summaryworkbook.summaryWorksheet - this would...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top