consolidating data

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...