consolidation

  1. T

    Forumla Help

    I know this is probably something simple that I am just not thinking of but I'm struggling here and wanted to see if I could get some advise! I have imported sales data into a spreadsheet over a large period of time, it has imported at one day per tab and has 133 tabs of unique data. I need to...
  2. M

    Consolidate by reference - automatically select data

    Hello, I've workbook with some 100 sheets. This number increases each week. In each sheet there is a table with different dates and values assigned to these dates. Each sheet has a same structure. The difference is only in the entered dates. I have to consolidate by dates to get sum of...
  3. G

    Excel Tables - appropriate to use?

    Hi, I have a workbook that is comprised of around a dozen worksheets, each containing data from a different source. There is also a single consolidation worksheet in which I extract the relevant data from the other spreadsheets, using VLOOKUP, SUMIFS and INDEX/MATCH. As a general...
  4. G

    consolidation of multiple excel workbooks to one workbook

    i have multiple workbooks with same type of data. i want all this workbook to be consolidated to one workbook.
  5. G

    Consolidation of excel sheet

    I have multiple excel sheet with same header. I want to merge the data in these excel sheet to one excel sheet with the help of macros. Can any one help.
  6. Jerry Sullivan

    VBA: Deleting Worksheet Consolidation References

    Hi all, We have some legacy workbooks that have numerous Consolidation references that need to be removed. The references can be deleted manually using the Data tab > Data Tools group > Consolidate button A web search shows some examples of how to Add Consolidation references using VBA, but I...
  7. L

    3d formula vs Data consolidation

    Hi I am reading about 3D formula. I found that it does not come with any new idea! It is very similar to Data Consolidation (Data-->Consolidate), am I right? if yes, then why I have one another? Thank you.
  8. S

    VBA: Opening multiple hyperlinks to excels and copying data to a consolidation excel file

    Need I have a file where in column “C” I have a list of different hyperlinks to excel workbooks stored on SharePoint (number of rows and links is different every month, but approx. 140). I want to retrieve information from these hyperlinks (the information needed is all in one range on a hidden...
  9. F

    Consolidate two columns in one sheet with VBA- HELP PLEASE

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

    Consolidating Workbooks in a folder into one Workbook

    Hello all, I am brand new to the forum and have done a search for the answer I am looking for but none of the current posts do what I want and I have got in a bit of a muddle now, so I decided to ask outright - I hope someone with a brain much bigger than my own can help me solve my problem...
  11. D

    Consolidation

    I have a list of employees and their manager's names. I need to consolidate the list so each manager name appears only once in column A and each employee is in a column to the right of the manager name. Ideally, the employees' names would be alphabetized from left to right, as well. Here is a...
  12. P

    How to combine datasets

    I have three data sources that I need to consolidate into a single data source: 1. A list of maintenance periods which are uniquely (no repeats) identified by 4 letters and 3 digits, for example CANS118. The Maintenance Periods mentioned in the data sources below will be listed it this list...
  13. H

    Module Crashing Excel but Don't know why

    Hi guys so I have a module that is crashing excel every time and I don't know why. I will paste it below. This path does not have two string variables declared; destinationpath and sourcepath When I try to add the declarations (as seen below), then press f8 to step through the module, the...
  14. S

    consolidation of two sheets with partially different column headers

    Hello MrExcel community, I've been looking for a solution of my issue and couldn't find any coherent help. I have two sheets which have specific names. Let's say "sheet 1" and "sheet 2". How can I consolidate the data per VBA in a newly created sheet if sheet 1 and sheet 2 have columns that...
  15. S

    Excel do not see date format in columns after 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...
  16. J

    Help with Cubeset or Cubemember formula

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

    Consolidating Data

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

    VBA cannot move this file to a folder. Weirdness

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

    Rate Consolidation

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

    consolidate from different files - excel 2010

    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.

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top