consolidate

Hello there, I have a master worksheet which successfully import sheets and filtered data. The problem here is, I want all the imported sheet (except master sheet) to be pasted in new worksheet name "consolidate" with specific columns and filtered rows. Below is the coding used to import...

Hi All, I found a good macro in internet and it almost suit on my needs, however I can't seem to modify it with the results I need. Public Sub consolWB() Dim FSO As Object Dim folder As Object, subfolder As Object Dim wb As Object Set FSO =...

Hi All, I need your expertise help with this please! Work has tasked me with an excel spreadsheet and I've played around with it, but can't get it to function properly and need someones help with more knowledge. What they want is a master spreadsheet of supplier payments for the year (April...

Hi Everyone, I have two receivables data workbook and i want to consolidate it in one workbook. anyone can help me on this? Thank you

I am fairly new with excel to some point, i know enough to be dangerous. Anyways, here is my problem. I have a master file spreadsheet that contains a ton of columns. The column headers i use to sort data is the same across the board on all spreadsheets and tabs. I have a unique ID field in...

Hi everyone After scouring the Forum for answers, I have come up blank. Can I please pick your more experienced brains on this one? I need to consolidate daily data into weekly data onto the same sheet. Each day data is entered into the sheet and needs to produce a weekly total of product and...

Hi folks, This may be too complex, but let me know. I can use some help with some code or macro button and would appreciate it any support. Here is what I am trying to do: The "Billing" tab is our exported data, and only a sample is shown. Rows may extend to 1000. Ideally: Once data is...

I am using EXCEL 2013 and am trying to find out if there is a way to auto-update the consolidate function. I am using a vlookup based on a data validation and would like to consolidate the result automatically when the value in the validation cell changes. I can't post the worksheet here for...

Hello! I had question about identifying ID's and getting SUM of items that appear on both lists/tables. I have hundreds of rows of data so this is example is a mere simplification of the data I am working with. With something like ten items per table, it would be simple to do it manually and by...

Hello friends. I have just discovered the consolidate function and was very excited to start using it to remove the manual process I have previously used. For some reason the function is copying each line in twice, which you can't initially see, but there are 'group' expanders on the side of the...

Hi , I need your help, i have a sheet that has several entries (columns and row, sample below) i would like to retrieve the header label based on a certain cell value (i.e. pending) and place the labels in the last cell (who is pending). in other words, if there is a date in the cell then its...

I am currently struggling to find a code that will allow my macro to function properly when opening a new workbook form my excel template. The issue im having is that the consolidate function I am using is referencing the template file and not the new workbook-where the new info will be input...

I have multiple workbooks, each with a HIDDEN tab called 'Data Merge' located on my H drive within a folder called 'KPI Submission'. I want all data from the 'Data Merge' tab using range A2:S41 to be copied to a master excel file called 'KPI Data Extraction' Loop until all files within the...

<tbody> Fruit # Total Apple 2 8 Apple 6 NO VALUE Orange 7 7 Apple 9 9 Banana 1 15 Banana<strike></strike> 10 NO VALUE<strike></strike> Banana<strike></strike> 4 NO VALUE<strike></strike> </tbody> How do I consolidate a column but only if they're in...

Hi i'm new here so i hope i do this right... I've been looking around for some code to solve my problem and have found similar situations but have been unable to adapt anything to my needs. What i'm trying to do is create a macro that will loop through a load of excel workbooks with varying...

I am a beginner in excel. I have to update a master workbook monthly with new data from a temp workbook. The two workbooks have the same column heading. For now I have to find the blanks manually to fill row by row which is very time consuming. How do I configure the excel to search for the...

Hi All, We currently have a large shared workbook (I know!!) which has multiple tabs for each month from Jan 2016 to Dec 2017. The workbook is accessed by several people in different time zones multiple times throughout the day. As you have probably guessed, it's becoming a bit unstable and I'm...

Hey! Thanks for the help, in advance. I have a list of cells (say in Col A) in the form: <tbody> Col A Albania #Value! Australia #Value! </tbody> I want to consolidate this list in Col.A into another column B, but without any errors "#Value!"; like this <tbody> Col B Albania...

I want to consolidate multiple rows into one row. Some of the data is the same, and some are unique fields in each row. Here is a sample, in which I would like Jane And John to each be consolidated to one row, with each column filled. When I use the "Consolidate" function on excel, the repeat...

Hi Everyone: Can someone please point to me in the right direction? My attempt is to go through a specific folder and consolidate all the files into one workbook. I am having three setbacks. First one is I am not sure how to loop through all the workbooks. Second one is adding the file name...