dynamic

Imagine I have my original workbook called 001.xlsx, in cell A1 I have the below formula already saved: ='C:\Users\mbxyz\File_001\[001.csv]Sheet1'!A1 This formula is returning the value from that specific cell, from that new workbook, from that folder. Now I need the 001 to be a dynamic...

In the Xl2bb shown below, you see in cell A3 the value A21 which is based on cell C21. The issue I have is when a listed program changes row number in sheet ProgramLocInfo then I need cell A3’s value to reflect that in the hyperlink. When a program changes row number in sheet ProgramLocInfo then...

Dear Friends, I have added following Excel file for you to understand my problem. There is a picklist that you can choose first week and last week. According to this choices of the user, I want my graph to be changed dynamically. My dates are week that I manually wrote as text format. Therefore...

Sheet1, cell B2 is currently blank. I want it to auto fill with whatever is selected on Sheet2 in column A. So cell B2 is something like = active cell sheet 2 kind of formula? I'm assuming this will need to be a macro/VBA code to make it work? Also, if this matters, I have all of Sheet2 from...

I need help creating a dynamic file reference in Excel (Please let me know the correct terminology as well). Currently, it is "='[SDR2021_AFG_NN.xls]Forecast NN 29 -- T5B5 -- AFG'!C2" I want to do something like this: "='[SDR2021_$P$94_NN.xls]Forecast NN 29 -- T5B5 -- $P$94'!C2" In cell...

I would like to create a Power BI Report to help with forecasting. Part of what I would like to see is the following based on an input of a specific date any user could enter. Not sure if that's possible in Power BI: - Previous Year (Day) - Not the Date but the Day of the Week for the previous...

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