consolidate data

Hello all, I'm looking for some help after spending the last two days searching the threads for a modifiable macro to solve my current problem, and unfortunately finding myself unsuccessful. Scenario: I am using a different macro to copy in files from a folder into one workbook on different...

Hello - I'm hoping someone can help me. What i'm trying to do is be able to execute a macro that would look at data in a table similar to the example below and consolidate so that multiple rows with the same Ship Date/Vendor/Order Type/Plant and Material would display in a single row with the...

Hello all, I am working on creating a data reduction sheet for a very large amount of data acquired through a Data Acquisition System. I have a 'Raw Data' sheet set up to quickly copy and paste over the entire DAQ file into specific columns. One thing I am recording is the flow rate through...

Hi Everyone, I am not sure what is the best way of solving this problem whether its some advanced function, or VBA/Macro route. What I am trying to accomplish is to merge and sum multiple rows for the same invoice number. So, if for INV1 there's multiple product line with same product line...

I have a macro that pulls in a tab called "Registration Form" from multiple other files and dumps it into my working file. I also have a "Control Panel" and "Master" tab in my working file. As a result, the tab names in my worksheet are as follows: Control Panel Master Registration Form...

Hi All, I have a one workbook with multiple sheets. And I wanted to combine these sheets into one sheet except for worksheets with sheet name "summary" and "data". My code is not working because it is still combining all the sheets even if the worksheets "summary" and "data" are hidden. Can...

Hello everyone, I just got a new job and i was asked to find a way to combine data from multiple workbooks into one master-sheet. New data will come all the time and i will need to update the master-sheet accordingly. I am new to this, but i was hoping to get your help please. I have been...

I am looking for a way to automate consolidating project numbers and making descriptions match. Here is an example: I have a very long road segment list (800+ segments) with the structure shown in the table below, which I want to consolidate into one row in a new tab with these columns...

G'day folks, So I am looking for multiple/best solution(s) to summarise/consolidate multiple tables into one. These tables are Bill of Materials (BOM's), on each worksheet will be a table summarising the materials required for each product assembly. The tables are made up of Part Numbers...

This is my first post so please (kindly) let me know if I made an error in my question - and I apologize in advance if any are made. I have 5 possible shifts (1-5) in this Shift column. For each Job Code in the 1st column I need to somehow merge each Job Code into 1 total 'qty' per each shift...

Greetings of harmony, I have the following situation and I'm trying to do this using a PC with Excel 2007. I would like this: <tbody> T N O O C O E I M I T H K U M H R L N E H A Y S U F H P G W TH IS :) </tbody> <tbody> </tbody> To look like this: <tbody> T H A N K Y O...

Hi all, I'm looking for a macro that will create a new worksheet "consolidated" and copy and paste all of the data (excluding duplicating the headings - headings row 2) from each sheet into the consolidated worksheet unless the value in A1 is blank. Any help is greatly appreciated. Linesy

Hello. I have only been working with macros/VBA for a week, so I know there are simple issues with my code, but I've turned it into spaghetti code trying to debug. I am trying to load data from multiple workbooks into a master and really need help please!! Dir for source files: C:\Test Dir\ Dir...

Hi guys, I have formulas that output values in 3 columns (H-I-J). What formula should I put in column K if I want to consolidate everything that is in columns H-I-J but WITHOUT the use of VBA?

Hello I'm a bit of a noob and need some help! I have 2 property spreadsheets to combine, the both have roughly the same data but both have some missing compared to each other and most data has been changed/updated. So I wish to combine and update both into a master spreadsheet without creating...

Hi All, I currently have two tables that are on separate worksheets in the same workbook. I want to combine them onto a third worksheet in that same workbook. When I say combine, I mean literally stack one right on top of the other*. Both tables have the same column headers, but all of the data...

Hi, I desperately need some help to append multiple sheets within a workbook into one master spreadsheet. I have tried the examples I have found in this forum but have not worked for me. I am very new to VBA and using macros and am using Excel 2003. All sheets within the workbook have the...

Hi I have 5-6 excel with same TAB name on each on them.I want one single excel with same tab where all the data will be extracted from them. Thanks

Hello I have a changing number of workbooks under a directory and I would like to extract some data from their first sheet called "offer". The data is always going to be from the same cells inside each workbook B12 B4 B15 B14 and B9 In my master sheet, line 1 will be the headers. Column A...

I want to bring all the data in different sheets(same file) in a single sheet. The data is in the same format shown below in all the sheets. <tbody> Description Drawing no. EDP Unit Price </tbody> I need to have a single sheet having the same column headings at the top of that...