consolidate

  1. J

    VBA consolidate sheets.

    Have 15 sheet in same workbook. Want to consolidate entries in column A to C in each sheet into a consolidated sheet called "Consolidated sheet" Can this be done with a VBA formula?
  2. S

    consolidate if sheet name contains...

    Hello, Please can someone help a new boy? I have a workbook with 4 sheets & 2 different title structures. This workbook is delivered as a .CSV file every month and has a different number of rows every time. I need to consolidate the 2 sheets that start with the word "single" and then the...
  3. F

    Consolidate two columns in one sheet with VBA- HELP PLEASE

    HI everyone! I am trying to consolidate data from two columns next to each other for a macro. When I recorded the macro, it gave me this code in VBA: Selection.Consolidate Sources:= _ "'C:\Users\random\Desktop\[DensityTest.csv]DensityTest'!R2C2:R823C3", _ Function:=xlSum...
  4. P

    Excel VBA consolidate duplicate rows in to "blocks"

    Hi, I have a large number of duplicate rows that I would like to merge/consolidate into blocks of 10 and rename the product. Here is some sample data: Customer, product, qty <tbody> Customer 1 Banana 1 Customer 1 Banana 1 Customer 1 Apple 1 Customer 2 Banana 1 Customer 1 Banana 1...
  5. J

    Consolidating Rows in Excel by summing up some columns while copying the other columns

    How do you consolidate rows in which I want certain columns to be added up, but other columns like "Color" and "Qty/Bag" in the example below to not be added up? <tbody> <tbody> Item Color Qty/Bag Cost/Bag Sales $/Bag Profit Item Color Qty/Bag...
  6. M

    VBA Code for Consolidation

    Hello all I have made some basic code in VBA to generate 2 pivot tables. This works :-) I have then converted the pivots to values in order to consolidate into one report. However, I want name the ranges or at the very least in the data consolidate box allow for it to pick up the current...
  7. G

    Table Consolidation

    Hey everyone. Just wanted to started saying off by thanks! This forum has been invaluable whenever I am looking for solutions to problems. This time though, I'm having trouble finding a good solution. I have some poorly formatted data that I would like to be able to index, so I am trying to...
  8. A

    Consolidate Data from Email

    I have emails coming to my inbox on a daily basis. Starts with notification wording (approximately one or two paragraphs). Then goes table in a text format. Then goes another paragraph or two. I connected through Microsoft Exchange to this folder. When consolidate, I need to remove all the data...
  9. W

    VBA to extract certain data from multiple sheets to a master sheet

    Hello, I have a workbook with more than 20 sheets, each sheet is the same, its a bill of material for certain part #'s. I would like to extract the BOM from each sheet to a single sheet. A1 has kit part # A2 colum qty. B2 parts Each sheet has 1 kit part #, and 3 parts to make the kit...
  10. S

    data consolidate vba

    I haven't been able to find any reference to controlling the actions in the Consolidate dialog box. I know the basic Range.Consolidate Sources:= But what about the other actions in that dialog box such as adding/deleting range references?
  11. A

    Excel macro to consolidate

    Hi All Hope all is well.. I need a favour please. I have a number of excel under one folder where I have to consolidate all of them in one file. There could be 10’s tabs in each workbooks however macros should look at only 2 tabs in all the workbooks eg: tab 1 and tab 3 and consolidate...
  12. D

    Consolidate Worksheets

    I'm needing to consolidate 6 daily worksheets into 1 worksheet. I also need the summary worksheet to be dynamic and update as the daily worksheets are populated. Any suggestions would be great! I've been able to consolidate the worksheets, however the summary worksheets is not updating as data...
  13. V

    Copy paste values to summary sheet

    Dear Community, I am very new to excel and in urgent need of your help because I have a huge set of Data to analyze. I have a file with a lot of worksheets (>50) that have all their content arranged in the same way. However, they are named differently (not Sheet1, Sheet2 but e.g. P1_F, P2_F...
  14. J

    Consolidating data using VBA, end with set Layout

    Hello, Im working on a large file with around 22 tabs and I want to use VBA to consolidate all this data in a master file. I have the following code that I am using right now on my test file that is doing a perfect job of consolidating all the information: Sub CombineWorksheets() 'Declare...
  15. C

    Excel Formula or VBA if necessary

    Hello, I have a table of data (shortened example below) with 40+ questions and 500 + respondents. The green section of the table indicates the questions that were answered incorrectly by an individual and the number of times they answered the question incorrectly (these are quality checks so...
  16. U

    consolidate tabs from multiple workbooks into one new workbook

    I have a folder with approximately 20 files in it. Each file contains a different amount of tabs. Looking for a way to open each file and then grab all the tabs and consolidate into one 'master' file.
  17. R

    sum every nth cell with additional criteria

    I have a system generated table that displays sales data for products. Image below. It has a merged cell in the first row with a month/year, which has the quantity and sales dollars for that month. I want to consolidate this data by year rather than by each month. I know how to sum every...
  18. F

    Consolidate Sheets into Master Sheet

    Hi Im looking for a bit of help with a macro. I have a workbook with multiple tabs of data, all in the same format that I want to consolidate to a master tab. The tabs to be consolidated are between 2 tabs named Site>>> and <<<Site Data starts at E11 and ends at CE200 <site Anyone know a...
  19. V

    Copying selective range of column data from mutiple sheets to one sheet

    Hi All, I have a workbook with 4 sheets. Each sheet has data in 10 columns. all sheets column headers are same. I want to consolidate selective column (A: C, F:H) data from all four sheets into a new sheet under the same column header. I have a code, but it is copying the entire columns from...
  20. L

    consolidate from different files - excel 2010

    Hi I remember it is not possible or there is not any command in the ribbon to do consolidation from different files. I had to press 3 keys to get that consolidate window to consolidate from different files. What is the command? Thank you.

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
Back
Top