consolidate

  1. E

    Can't run multiple macros but alone they work

    Hi, I have a first macro that compile data using relative and absolute reference recording. My second macro consolidate data My third macro clean the table after the consolidation. I can run them fine alone but one after the other one its not working. Call doesnt work. Application wait...
  2. B

    How to combine columns from multiple workbooks?

    I am working on a Classroom Files. Where i have many files containing report of each test like Test 1, Test 2, Test 3... I have to make a Master workbook that will contain the Mark Columns from All the Test Files I tried the PowerQuery ( I am very much new to PQ) but failed as it was...
  3. A

    Append/Consolidate Multiple Workbooks with Multiple Sheets retaining the Format

    Excel warriors, I have 38 xlsx files stored in one folder. Each file has a different count of sheets (15+)—all sheets have the same column count, same headings, but different counts of rows. I need a macro to append (consolidate) all of the sheets into one sheet in a new workbook. This...
  4. C

    Consolidate same format sheet from different files into one file

    Hello everyone, I want to create a master file to consolidate 1 sheet from 10 different files. For example, the name of the sheet I want : FREE, the names of the different files : Europe / America / Africa. So I copy the sheet Free from Europe / America / Africa and paste them into one master...
  5. M

    Consolidate Rows Question

    Hello- Hopefully an easy question. Have a large dataset where there are two rows for each Group & Category. Is there's a way to consolidate as in the example below? ABCD1Current2GroupCategoryBaseline_CountFollow-up_Count3Age Group65 to 69 years254Age Group65 to 69 years275Age Group70 to 74...
  6. T

    Combine overlapping dates and find non-overlaps for multiple unique ID's

    I have a very large spreadsheet with headers (180k+ rows) with unique ID's in A, start date in B, and end date in C. There are multiple rows per ID and the start and end dates overlap in a messy way. I need to find any gaps in the date ranges for each ID. I've written a few different formulas...
  7. N

    Combine data from ALL worksheets in different workbook

    Hello, I've been working on a new template and excel sheet for the quality inspection of fresh carrots we receive. Everytime we receive a load, we work on a Excel sheet to fill in our quality inspection. So every load has its own sheet based on a template in the same workbook. The name of the...
  8. S

    Group By Character Name and list all Scene numbers

    Hello All, Hope you are doing Fine. I have Excel data as shown in the below table. Can anyone help me to get the desired output? SCENE NUMBER CHARACTER NAME E01 SC 01 MICHAEL E01 SC 01 JACK E01 SC 01 ELIZABETH E01 SC 02 JOHN E01 SC 02 MICHAEL E01 SC 03 JACK E01 SC 03...
  9. andrewb90

    Consolidate ever growing VBA

    Hello! I Have been trying to find a create way to copy and paste values using VBA, and while it does work perfectly, As I add more cells to my list, the VBA code gets longer and longer. Anyone have any suggestion for how I can consolidate this code? There are multiple other pieces, but they...
  10. M

    Consolidate multiple tables dynamically

    Context at the bottom. I am hoping you are able to assist me with an issue I am struggling to resolve. I have data collected in multiple separate SharePoint lists (identical structure) which can change dynamically which is causing me issues in consolidating all the data in to one table within...
  11. T

    Combine (Merge) multiple excel files (.xlsx) into 1 file (Same columns stack 1 another)

    Hello all experts : ) I would like to Combine (Merge) multiple excel files (.xlsx) into 1 file (Same columns stack 1 another) Below are some screenshots from the files I would like to merge, there are 130 files. Let's start with smaller sample, I would like to combine file 117 and 22...
  12. G

    Consolidate/merge data in duplicate rows separated by delimiter

    Hi Experts, Project: I am working on Power BI project where I am fetching data from many JIRA projects. The only problem here is one field which is not used in a harmonized way for across all JIRA projects and i.e. Release Information. For all JIRA projects in my report, I derived that...
  13. A

    Consolidate sheets into one tab?

    Hi, I have a workbook containing multiple sheets with same formatting in each tab. I am trying to take all the sheets and create a pivot table containing the data from each sheet. Is this possible to do? I am trying to avoid using a master tab because the information changes daily and the same...
  14. W

    copy data from multiple workbooks

    hi , Im new to VBA and I have been trying to create a program to copy specific range from multiple workbooks having data in sheet 2 to a master workbook sheet 2 . COPY Condition: the column range will be A20 to AS20 while the row range will depend upon the last cell having data in column R...
  15. N

    Consolidate Same Sheet from Multiple Workbooks

    Hi, I have a folder with files where I need one sheet from every file pasted into a master workbook. I have tried this with PowerQuery, but believe there are too many files for it to process. My files are saved at the path: "C:\Users\user1\Desktop\Combine Files" There are approx 100 files...
  16. S

    Consolidate multiple sheets

    Hi I am trying to consolidate multiple sheets into 1 tab. I don't know how to use the sumif because 2 of my criteria are in the same column: the customer name and the value name. I don't even know exactly what formula to use...all help would be appreciated. I am trying to consolidate data in...
  17. R

    Error in Code

    i have a code to consolidate the all sheet into one. sheet name is consolidate. but whenever i have running this, data copying twice. :( Private Sub CommandButton1_Click() Application.ScreenUpdating = False Application.DisplayAlerts = False Sheets("One").Range("a1:c1").Copy...
  18. R

    Consolidate rows with a macro based on lack of value in certain columns

    I'm working on fixing a spreadsheet for work with very little VBA knowledge. I've got the original sheet working again but now would like to add a consolidation button for times when the outputted table is too long. This is an example of the output table from the macro: I'd like to output to...
  19. D

    Sum all worksheets to a Single Worksheet

    I have multiple worksheets. In cell "M3" they all have the following formula adding up columns within it: =IF(R3,R3+S3+T3," ") On the Summary page I have this formula trying to add up all the worksheets but it's returning a VALUE. I want it to return a sum for all the worksheets in that cell...
  20. D

    Consolidate Workbook

    I'm trying to consolidate certain fields across my workbook: I'm using a formula: IF('Week 42'!D145,'Week 42'!D145," ") I want this formula to return whatever is in cell D145 on the "Week 42" workseet to cell D145 on he "Consoliated" worksheet OR if the cell is blank, I want it to remain...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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