rollup

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

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

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

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

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

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

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

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

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

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