#dynamic

Hi all below is a graph i made and the data i made it from only issue is when i update the table the graph doesn't update how can i make this dynamic , thanks in advance DIJKLMNOPQ2Property Investment3Intermediary4Multi Landlord5Property Management6Intermediary7Asset...

Hello team, I have an excel sheet with raw data of exits of employees. I want to make dynamic summary of exit report like below with sorting of largest to smallest count exit reason wise (automatically every month, so excel should ignore the exit reason not available in the next month and the...

Hello All, So today my boss told me that he wanted a just a cell that displays YTD YOY growth. So essentially here is what we're working with for excel tables. Year January February March April May June July August September October November December Total 2017 $ 16,186.00 $ 20,262.00 $...

Howdy ! My first post on Mr. Excel, so let me know in the comments if I left anything out. I have attached a simplified version of my project which illustrates my problem of creating a chart, when the data dynamically changes quantity, the graph gets thrown off. You can see that if you change...

I have dynamic name range named "Employee" defined as "=offset(Sheet1!A1,0,0,counta(Sheet1!A:A)-1,1)" I want to make this name range as input range to my combo box. When I enter the input range for the combobox as "Employee" (without the quotes) it gives me an error "Reference is not valid"...

Hi guys, I am trying to figure out if there is a way to collate pdf's together in VBA. I have currently written a macro that changes filters for a couple of pivot tables based on a list of variables that I am looping through. Example of above. My filter is a company name and I have a list...