consolidate

Hi, I am using below code for consolidate multiple workbook, however I want to consolidate data from Sheet1 which is protected. so is it possible to consolidate data from Protected sheet. Option ExplicitDim fsoMain As New FileSystemObjectDim myFldr As FolderDim myWB As Workbook, tempWB As...

Hi, I have created a meeting minutes/actions in excel. Each new meeting will be created into a new sheet with the template. Now I wish to extract all the actions from the minutes into a new 'action log' sheet so that I can track the actions and create a log for it. The following may simplify...

Need to consolidate about 40 tabs to one master tab with same format columns A-G and add a column for tab name column H.

How do I set up a central file in which every morning you can import and analyze the data in those 24 hourly summary files rather than doing this manually (copying/pasting from those 24 files each day). I have to import the data to row-wise, should i select range using importbox or, sorry I am...

I am using an xl file with multiple sheets and have a front sheet at the start where i am cosolidating results. what i am trying to do is a vlook up across the other sheets which will return the stock count of a part number. this is the code I am using...

Hi Team Need a help on excel sheets consolidation from Folders. I have folders created by city name( Mumbai, Chennai, Agra etc) and these City folders have 4-5 worksheets with different header, which i need to consolidate one master sheet with data and header line of each worksheets. I have...

I'm trying to sum multiple columns if the first column is the same. I was trying to use the consolidate function but I also need the order date and customer name to remain (it changes if I consolidate). Here's an example of an input: Here's what I'd like it to output: The number of rows will...

Hi, i have 3 xlsx. files in exactly same format each numbering about 750.000 rows, i can export either as xlsx, csv or txt. I have tried in vain to create a single Excel file by copying data in one file, but Excel crashes every time. So here is my questions: 1. Can i consolidate the files in...

Hello, Every month, each individual territories share their sales numbers to me. I have data in multiple workbooks. All workbooks have the same format. The data is only numbers in all the sheets. Only the column headers are values. I want to create a master sheet which will simply show the...

Hi All! I could use some help with this, if anyone has any ideas on how to tackle it I'd be really grateful. Here's an example of what I'm working with: <tbody> ID Location Contact 1 123 Main St 1 Jane Doe 1 Jack Frost 2 456 Second St 2 2 Lacie Lou 2 John Doe 3 789...

Hi All I have some raw data where Column A contains the project number and Columns B onwards contain the week ending dates. I would like to consolidate the rows where the Project number is the same in Column A. I have tried the Consolidate function but not sure how to use it with multiple...

Hi I want to copy the first paragraph, (the first 4 lines) from the article below into my excel sheet. When I copy everything and try to paste them in excel, they will all go into cell A1 and Wrap Text option activated by itself. I do not want that. I want these 4 lines to go into the first 4...

I have 2 very similar goals: 1. consolidate in 1 worksheets 5 specific cells from dozens of different workbooks where each workbook contains the same 3 worksheets and the specific cells are always into the same worksheet and in the very same place; 2. consolidate in 1 worksheets 1 tab per...

Hi All, So I just watched this video, and it did exactly what I needed it to do! However, I'd like it to do it automatically... is there a way to make this data consolidate when I'm done typing, instead of clicking through the Data > Consolidate THANK YOU!

Hi, So basically I have numbers of excel file with numbers of sheet also. I run code that copy all the data but it copies as is creating a new sheet and not consolidating all the data in 1 sheet. Like 2 excel file with 5 sheet and 3 sheet into new workbook with 1 sheet consolidating all the...

Hello, Good day I have 15-20 workbooks, where in in every workbook the 2nd sheet name would be " Route sheet ". I want a Macro which can consolidate all the data from these workbooks in the same formate. All 15-20 workbook " route sheet " formate will be same. can any one help me in this...

Hello, I have this code below that copies data from all worksheets and copies it into one consolidated tab. My question is: is it possible to maintain a list on another tab called "List" and only select those worksheets that are part of that List to copy and consolidate data? Let us say I have 5...

Hello I need a VBA code to consolidate data from numerous tabs into one. The format of the data tabs remain the same. See the attached example where sales from different departments need to be copied across to the consolidated tab. Thanking you in advance for your help...

Dear Experts, i have 30000 rows of data which consist of around 40 columns. the rows have duplicate data. what i require is consolidate these duplicate data using 3 conditions and insert a parent data row containing same data as the child row. the 3 conditions to validate are: 1. Code 2. SKU...

Hello, I have a table that looks like this <colgroup><col><col><col></colgroup><tbody> Customer Number Date Visited Rating 1 5/21/2018 1 2 2/7/2017 4 3 4/2/2018 2 2 5/6/2017 5 4 9/8/2017 4 5 11/25/2017 2 4 3/2/2017 5 6 6/8/2018 3 7 7/22/2018 2 7 2/16/2018 1 4 2/1/2018...