rollup

  1. K

    Rollup sheet

    Hello, does anyone know how to create a rollup sheet that adds all values from other sheets in the same work book? all sheets will have same formats, rows, titles, everything will be identical except for the data in the cells, which needs to rollup to the main sheet (I'm trying to avoid go 1 by...
  2. B

    Moving Row-Level Output data into Columns

    I have a scenario where I need to move additional data in rows with the same primary key into additional columns. Below is a link to an example file that reflects what the current data output looks like and how I will need it to appear: TinyUpload.com - best file hosting solution, with no...
  3. B

    Moving Row-Level Output data into Columns

    I have a scenario where I need to move additional data in rows with the same primary key into additional columns. Below is a link to two photos to reflect what the current data output looks like and how I will need it to appear: Education & Work History - Album on Imgur Basically, I need the...
  4. C

    VBA Help Requested - Rolling up Tabs

    Hello everyone- I hope everybody is doing well. I have been spinning my wheels on trying to figure out how to best finish coding this Excel macro, and I figured at this point I should just reach out to the experts! I have attached a (scrubbed) sample picture of what I am working on for an...
  5. L

    combine multiple columns keeping some columns static

    This is a sample of the data I have I would like to have my data like this - Image titled target file Please let me know how this can be done with or without macros. Source data <tbody> Staffname Empname EmpID Project1 Domain Subdomain Project2 Domain Subdomain A AX 1 WER WERD WERS PQR...
  6. M

    Macro to Rollup from mulitple worksheets

    I am not a VBA expert but I was able to find a macro which does most, but not all of what I want. I was looking for a macro which would copy data from mutliple worksheets and into single rollup worksheets. Each of the worksheets are formated the same with the same column headings. My problem is...
  7. D

    Summary tab pulling data from multiple spreadsheets

    I am trying to make sure I am using the most efficient way possible to roll up issues from multiple files into a single issue summary log. Multiple spreadsheets/excel files (new ones will be added on a regular basis), Files will be saved with the same file name with a different 6 digit...
  8. E

    Nested Excel Logic Mindbender

    The basic problem I am working with is... "Here is a list in excel of everyone in the company (empl id in column A, supervisor id in column B)... Determine the Vice President that each person rolls up to." Everyone has ids and I have the list of VP's; the quirk is that while some may have a VP...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top