consolidation

Hey Guys, I have really strange issue connected to the master tracker, which consolidates data from several other 'individual' trackers. Once I consolidate data, everything from 'individual' trackers flows to master tracker (they look perfectly the same in terms of view, columns, etc.). The...

Hello all, I have an excel (2016) workbook with a direct connection to an SSAS cube. I need to combine two or more cubevalue formulas in order to sum two different values or sometimes more. For example I want the formula to return the sum of Sales and Cost of Sales. Currently I do it like...

Hello people I'm stuck. I'm trying to consolidate data from three workbooks called 'Oct', 'Nov' and 'Dec' into a new master worksheet. Not found anything on here pitched to my very basic level of understanding and nothing on the office support forum that I can make work. There are several bits...

I have a process that is processing and then moving about 60 files to an archive. For some reason this one file cannot be moved. The files name is: (very long I know, can't help it) 1 2 2018 - xOpen Line Report for y and AVOCENT Product POs RMAs as of 01 02 2018 - x Backlog Report as of...

I am working on consolidating several different employee groups. They are separated by different benefit rates. I have 25 different groups, each with 9 different rates. I am looking to consolidate the 25 groups if possible by comparing similarites in the rates. Is there a formula that can help...

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.

Hi All, Once per year my team sends out excel spreadsheets to 22 different departments to get their 4-year staffing plans. The templates we send out have pretty much all been standardized (we had to create one or two specialized spreadsheets, but I'll worry about these exceptions later). Our...

Good afternoon. I have a number of files that will be placed into a network file and will all have the same format. There will be a separate tab for the following: Risks Assumptions Issues Dependencies These will all be placed in a specified folder each week and I want to be able to take all...

Hi, I was wondering if there a way to make a master consolidation master sheet in excel. I currently with large volume of worksheets. And then I have to manually copy paste the workbooks one by one. I currently receive about 80 excel worksheets and than manually have to consolidate them. I am...

Hi all I have a worksheet with hundreds of tabs of data, one per person, named as the person's name. The person's name is in Cell A3 on each sheet. I need a macro to look on each sheet for a specific value and, if found, to pull the person's name, that value and a number of cells to the right...

Hi! My problem is this: - a manager is emailing out spreadsheets weekly to her team for them to fill in their current workload. Design includes Name at B4, and completed information about workload in cells A11 to Hx (x depends, more/less rows are filled in each week) - team email back the...

To whom it may concern, Hello, my name is Jake, and I've been presented with a large task in Excel. I have two sheets that I'm working with; the first sheet has 1436 rows and the second sheet has 2548 rows. Essentially, my task is this: If any of the values within sheet 1, column a, are...

So this problem has a few conditions that prove to be difficult in my eyes. I basically have an output of some data correlated with a name shown in a basic form here. The first problem is that the types and amounts of vegetables will be changing weekly, so the macro cannot be based on...

Hi Folks, I have been trying to use pivot table consolidation from multiple sources but didnt manage to get the desired outcome. Im happy with any hint of solution, vba or formula / wizards... I have 3 sheets in excel where you can find similar type of data at the same locations. This is...

Hi. I am pretty clued up using excel, but my VBA knowledge is very limited, so I was hoping that someone may be able to offer some assistance. I have created a resourcing master file and I have also created a resource submission form, which is basically another excel spreadsheet, which will be...

Dear all, I am trying to consolidate multiple excel files with different sheets to one file that was initial file that was split into several files. So I have multiple files that contains part of the file and I would like to collect the feedback from that in the Initial master file. My logic...

Hi, I am new to VBA so struggling to get this to work. I have a number of workbooks in one directory that are exactly the same apart from the name of the workbook. I want to take all the active rows and columns and copy the data into one master version, so that workbook b data is pasted below...

I love this forum. I used to post here all the time and I can honestly say that the help I have gotten from people here has helped me become an OK Excel user. So I have another question and I'm wondering what you all think might be the best way to accomplish this. I have a workbook which...

I'm new to the consolidation feature in Excel. I have shared a link to the drive doc in google. https://docs.google.com/spreadsheets/d/1SJ7e85R5Hm1Nc6DQRJcYAhl4PPfX3lV7HfbZq4xrOuw/edit?usp=sharing I have some columns which are in percentages (conversion column), I would like to sum these and...

Hello All, We're using excel spreadsheet to maintain our time log and to log other business data. We've a checklist, in that there are two work sheet - 1. Summary & 2. Checklist. We enter our time and volume in worksheet 2. Checklist, and using formulas we got the consolidated data per person...