dynamic

Hi there, I am trying to highlight each row where a value is present in another list of values (it doesn't need to be in the same order, just needs to be present) This is a line of code in SAP that highlights the row(s). In this example, it highlights all rows 0-11 (starts at 0 because of a 0...

Hi there, long time reader, first time poster. I am working on a production KPI table and I want to be able to lock all data entered prior to today's date and I would like this protection to be enacted upon saving. I found the code beow and adapted it for my purposes and the dates are in column...

Desired output: depending on the Month you select in a filter/slicer, identify only the changes (Adds/Removals of the Identifiers) from the Selected Month vs Previous Month. For example, when selecting February in the filter/slicer, I want to show Identifier "E" (i.e. an Add, because "E" isn't...

I'm trying to create a data validation list that dynamically adjusts based on the cell above it. The cell above will have the name of the tab that we want to get this list from, but the problem is the list has a different length in each tab. I know name manager and INDIRECT would help accessing...

Maybe this information exists somewhere but I have searched and searched and come up with nothing that I can actually understand. Here are the basics: 1. I have a spread sheet containing customer information. 2. Among each customer's information is an email address in it's own cell. I...

I am seeking to calculate Number of Processing Days based on a daily quota. As long as the daily quota is constant, the calculation is simple i.e. Tonnage divided by the daily quota (as in Figure 1) gives the Number of days required to process the batch. The result from the division above...

Hi all, I need a VBA to add the Colume Headings Range A1:N1 in to the next empty Row, I need to keep The formating etc. using the pictuer as an example i would like to copy row A to the top of the Transport and top of HQ, the amount of rows in transport and HQ can be different every time.

Hello there, I am a new member in this forum (just joined now). I am in my Excel learning journey and I hope that I can make contributions to this forum soon i.e., hoping to be active. Greetings aside, here is my problem. I wish to make a row of dates (not in columns which is usually the case)...

I've been working on this all day and have had zero success. I want to be able to change dates in Columns A and B and have rectangles position and lengthen themselves accordingly, based on the calculated values in Columns C and D. I almost had something working earlier today but it would only...

Hello, I've been working on a new template and excel sheet for the quality inspection of fresh carrots we receive. Everytime we receive a load, we work on a Excel sheet to fill in our quality inspection. So every load has its own sheet based on a template in the same workbook. The name of the...

Hello, I have a VBA macro that will insert a new column (titled updated col..) to the right of the specified column name. Then I use a VLOOKUP and autofill in the new column to provide the updated values. The column location of the updated column is variable/dynamic. How can I make the autofill...

Hi everyone, how are you? Could I ask you to help me please? I need to calculate automatically 2 things (in the tab "Cost details"): 1/ The P&L impact (taking into account several variables - from cell L13 to cell S13 2/ the Cash position (cashout) based on payment terms, total cost expense...

Hey everyone, I was hoping someone could help with some ideas. I have an Excel report with multiple linked pictures, one after another in a vertical layout. Each of these linked pictures points to a named range, and each of these named ranges points to a specific pivot table. Some of these...

Hi there, I'm looking for help with a problem in regards to using a dropdown menu for a dynamic summation of periods. I have a drop down menu with P1-P12 in it. Here is the report that I have to use for the information. Right now I have been working on by just using SumProduct to get the...

So here is the deal. I need that cell in E4 to be dynamic because the "Description" column on the Excel table is supposed to be sortable. By dynamic I mean that no matter the order of the Excel table, cell E4 should always report the correct tag associated to the description. How can I achieve...

Hi, I would like to ask whether it is doable to have a formatted Excel table on one sheet, a normal range (or maybe another formatted table as well if that is better??) on another sheet and have the sorting/filtering and any editing of the formatted table on the first sheet dynamically apply to...

Hi all, I have coded my index match but I used formula instead of function, also my code has set ranges instead of dynamic ones. Clumns A,C,F changes everyday so need to implement index/match functions and dynamic ranges. Is there a chance someone could kindly help me with this, please. Thank...

Hello Everyone! I have a VBA issue I can not beat and need the experts. On my "Project Tracker" tab I have a list of names in starting in cell D7 and going down. Names can be duplicated Currently I have a macro that when clicked, it will look through this range of data, find the unique values...

Hi, Wanted to ask how to enable my datasets within VBA to be dynamic for future VBA purposes ? In my "Record Macro" function, I selected the available range of data (Ctrl + Select + 8), but within the VBA, the code specifies the range which I did in my initial loop. How to allow my future...

Hi all, I have created a chart based on a table. We can see that in first foto there are no value entries, and in second foto values were added. Into the third foto, with rows only partially completed values, chart is going on 0 line from where values end. I need the red line to stop where...