rollup

  1. P

    Look Up BOM Hierarchy using Level field

    Hi all, I am trying to come up with a method of looking up the BOM structure below, using the level column, to replicate the manual output i have created in the column 'IDEAL'. The logic here is 1) If 'ISCONF' = 'N' then it remains 'N' 2) If 'IsConf' is 'Y' then look up at its parent, which...
  2. M

    Using Vlookup to return cell values between dates

    Good morning everyone, I am stumped on how to get my monthly and annual roll up data to properly display using Vlookup. I have set up a helper column to assist the daily data but I honesty cant figure out the best way to get Excel to total data across a month for a given metric. I currently...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top