Does anyone have a formula I can use that will be able to pull values based on multiple drop downs?
My data is over 2000000 lines- I am trying to create a summary sheet where we use the drop down to summarize by region travel expenses on a monthly basis.
Im trying not to use a Pivot
I am...
Hi,
I have multiple workbooks (for each month) that has multiple sheets (for each region by MDT and QTD). All saved in the same folder
I would like a macros to pull the data from each workbook (MTD tabs) and populate my master workbook as a trend summary
My Master workbook has 3 tabs (one for...
Creating a summary tab that pulls data using the drop down options.
I have historical data that I would like to summarize using drop down options.
I want to be able to select a region and customer typ and have the top 3 customers for that region and specific customer type pull. Please see...
Hi,
If I create a drop down option, I would like the next drop down to filter by the certain groups within that option that I first selected, so if there is no information on a particular field the field doesn't show up in the second drop down.
Attached is the spreadsheet- I want to be able to...
Hi,
I have over 200 workbooks / similar templates that I need data from to populate into a summary sheet.
So I need Cell C6 From referenced worksheets to populate. Does ayone have a macro to do so?
All the workbooks are labeled e.g
1-Jan/Store 1
1-Jan/Store 3
2- Feb/Store 10
2- Feb/Store 2...
Hi,
I need help in creating a formula for the below situation.
Each region( about 30) in the report I am trying to create has different levels so if YTD amounts get to a certain level an additional amount is added..if it moves onto the next level the difference between the previous level and the...
Hi,
Does anyone have an idea how I could go about the below scenerio
i have an assumption page.. of which I want to be able to input a predicted termination/closure .. by doing so ( entering the year, month and employee #).. a formula that I can use in all my data tables ( be it sales...
Thanks .... This would make sense if my array matched.. but I have over 700 rows of data so my rows and column do not match, hence I dont think I can use MMULT function.. ( or can I?)
Please see attached I have revised it.... the highlighted I what I was trying to create a formula for. The reason is that I have over 6 years of data side by side.. and the results less the term is what is going to drive the next phase of the model am building.
Thanks for your help
Am sorry... I should have been more clear... the 1st formula worked but it gave me the count.. what I need by month is the amount not count by month for only active employees for the year.
So Feb total should be less any term for the year, march the same thing and so on so forth.
please advice..
Hi,
I have 2 tables- one that has the key ( tells us if an employee is term and active) and this drives the calculation table to give me the amount per month.
What I need is a formula by each month that will only give me the active employees of that year. So for example in the month of Feb--...
Hi,
Does anyone know a way I can change the current formula to make it more of a "variable".
What I mean.. Am working on a new store model, and I am assuming that new stores will be opened on specific months.. as we forecast out this months can change.. I want my formula to
1) change the amount...
Does anyone know a fomula I can use to populate sheet4?
I ae thousands of lins of data in the other sheet and would like to summarize whats been cleared on a weekly basis at a certain point/between this certain points in in time when the checks clear.
Summary( Sheet 4)
Payments NA EMEA...