dynamic

Hello, I have an exported, filtered list of results (not a table) where one out of two rows (the second one) describes the first one. Now I'd like to select these pairs of rows dynamically in order to format their borders, among other things. I'd like, for instance, to give the impression of...

Hi, I have spent hours and finally got the multiple lists to work dynamically in the ListBox. But for the oddest reason when i click on an "option" the box moves way over almost out of the form. It still works perfectly but it is visually unappealing. See the attached screenshot before i...

Howdy dear Excel specialists, This is my first time on any Excel forums. I've tried to look at other threads before posting this one, yet I don't seem to be able to apply it to my own situation, nor can I understand a thing of that VBA witchcraft. So I have this main table that regroups all...

Hi. Am confused here. I would like to create a data validation drop down list that when one of 4 things are selected, it brings up another list, select an option and bring up a final list. Example: Drop down list one would have Region 1, Region 2, Region 3, Region 4. By selecting Region 2, it...

I'm trying to get better at this and in doing so, I've seen over and over again to stop using .Select and .Copy/.Cut to move things I know I can move my columns with copy and insert no issue, but I'd like to step into the next level. On one ws, i've got columns P to AB and need to move them to...

Hi Everyone, I have attached a spreadsheet and highlighted in yellow the column K I would need to be filled with a formula (spill formula only so that it is completely automated). Column I and J: This is a spill formula using Unique, Filter and Choose function. Column K: I would need a spill...

I have an excel sheet that contains all of my data named (Book1), and that excel sheet (Book1) updates on daily basis. What I want is to transfer the data for each date to another excel work book (Book2) on daily basis, without over writing the old data on the work book (Book2). For example if...

I would like to make a dynamic graph that based on operator, can display various metrics related to production to a date range. The caveat here is that the graph will need to change x axis values per operator due to the fact that each operator works different days. For instance, I want to...

Hi, First of all, my level of VBA knowledge is hacking together things I find on the internet, so I apolgise if this is a stupid question. I have the following table (made up details, but same format): Server Patch No Date Server 1 1 27/04/22 Server 1 2 27/04/22 Server 1 3 27/04/22...

Hi, To give you a bit of background I work for a property company and we currently keep our database of properties on Excel. There are multiple entities and each entity has a tab on a workbook, each entity tab contains the same column headers across the top and down the side are the list of...

Hi all, I am having some issues with the following problem. I have a range of coordinates x [m] and 5 items defined by the functions x1,y1, x2,y2, x3,y3 and x4,y4. My objective is to find the y [mm2] value corresponding to my x-value by finding the value inside of my x1-x4,y1-y4 list. I need...

Hi all, hoping someone can help with this one. I'm currently working on a spreadsheet to track training data, and one thing I'd like to add is a dependent drop down list for the training provider. It would have a drop-down list in Column J to select the "Provider Type" (either external or...

Hello, I have only recently started diving into GETPIVOTDATA and I am stumped as to how to have the following happen. I would like to have the information for an employee to show up in a cell on another sheet by referencing their name on that sheet. but because we need to deal with different...

Hi, Long time lurker first time question poster here :) I'm trying to plot a variable amount of series on a chart. I've created a dummy environment with data for my issue, however in the actual issues case, the data table in B29:R47 is filtered from a master on another sheet which I cannot...

Hello, in my workbook i have 3 sheets, 2 contain data (Sheet 1 and Sheet 2) and another references specific cells on those 2 data sheets. the reference sheet looks like this is there a way (prefereably without VBA) that i can highlight the cells in the data sheets (sheet 1 and 2) that are...

Hi All, Good Day .. :) I just started learn more about excel deep nowadays, I got promotion in office. I was assigned to small task in excel, which a am suck now, can anyone just lift me up from this issue. I have some multiple sheets with dynamic rows to be updated daily and another mail...

I have >100 files, all with the same make-up. I use Sample File to get a 'specific part of the table'. I also need '1 value' of this table from a specific cell, BUT this value is filtered out in the steps to get the 'specific part of the table'. I could Add (the '1 value') as New Query before I...

I have 3 categories (Priority, Less, None) that correlate to a specific NESTED IF Function but only differs in the percent within the calculation. Overall, the result of the use of the formula provides a Status of behind, ahead, on track etc. I currently have the status only populating with...

Hi! I'm beginner with VBA and struggling to get dynamic "data import" to work properly in a way that the path is taken from a cell value (instead of written to VBA code). I have one master Excel (sheet "WP_Data") to which I want to import data (one cell content) from tens of source-Excels (in...

Hello, Fairly new to VBA and working on a macro that will update 5 cells with values calculated through a formula given a dynamic range of values. For example, the input range the formula cells would draw from on worksheet achLinkage could be AB2:AC5, or it could be AB2:AC10. I've developed...