consolidate

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?

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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.

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

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

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

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.