dynamic

Hi guys, Very specific query for a workbook I'm building so I hope you can help me. I need to incorporate a formula in column D(Flag) so this field populates one of these three labels (First time, Prior, Before) when the following scenarios occur. The logic/formula needs to be reset every...

I am looking for VBA code that I can select a range and it would: Create a new workbook and a worksheet named with a the source name & date/time stamp select a any range find all the blanks in the selected range report the blank address in column A of the new wb/sheet report the column header...

Hello everybody, I am currently managing a stock tracking file, which is edited manually to a large extent. Currently, the four significant columns look like this: Here, column I is the actual quantity in stock. If my code was functioning, which it was as of yesterday (and I have made no...

Hello! Thanks for any help in advance: I'm attempting to create a "dynamic invoice" of sorts, with names being pulled from a "refresh-able" table. By that term, I mean an excel table that (I'm assuming) is pulling from an SQL query and just needs the "refresh all" button on the Data tab to be...

Hi all, i feel like i've watched a million youtube videos and read a million articles and they all seem sooo similar to what i'm trying to accomplish, but i just can't quite get there... Here's the situation; Excel 2016, will be a shared workbook so no tables allowed, workbooks will likely have...

My workbook contains an 'inputs tab' where i will have 3 inputs: "date", "amount" and "number of months." In my 'output tab' i have row 1 filled with all the month end dates. I.e Jan 31, 2020, Feb 28, 2020....etc I want to have a dynamic formula in row 2 that will match the "date" from...

Hi, Wonder if it is possible to have a formula that dynamically looks up values from a table as the reference cell instead of manually typing in each one. Once it finds a new VLOOKUP value it would use that by default until it finds the next value in the table and so on. In the example below it...

Hello everyone, I have a macro that insert new blank rows, then copy and paste some rows, based on a input userbox. Those last rows contain formulas but, once pasting them, they become incorrect (problem of references). I'd like to make the formulas dynamic in the macro code (via R1C1) or via...

Hello, @MARK858 - Is it possible for you to help me on this please. I have a Pivot table, where i need to Select Blank Column next to last row of Pivot table and Put Filter. I tried some coding but i am getting an error. Please help to rectify. Steps: 1. select Row from a Blank Column (Here it...

Hi All, Really hoping for some help here in calculating the correct weighted utilization. The idea is you have multiple plants within each product group and within each plant you have multiple lines with different possible volumes. Based on the volume assigned to the line you have a...

Hi All, I've been trying to solve this for a few days now. I am relatively new to VBA, and I am running into trouble due to the data in my worksheets being dynamic. I need to autofill a formula down to the last row of the adjacent column next to it. The problem I'm running into, is I'm not...

I have a table which has a ToggleButton next to each line. I would like to write a script that does something for each line of the table, but only if the ToggleButton on that line is pressed. Is there a way to define the if condition in an elegant way? I would imagine something like: For i =...

Hi! I am looking to learn if it is possible to update a growing list within excel through a separate sheets inputted values. I will use name, height, weight, and age as example placeholders. On the first sheet (Sheet1), I would like to have inputs for the above data which will then populate a...

I have worksheet A, B, C, D, E, & a I have data in cells G5:G15 of sheets B, C, D, & E I want to count the total cells in each sheet with values "xx" that are visible except in sheets A and a.

Hi, just wondering if this is a possibility with the Index/Match formula. Or is there a better formula when I don't know the column position of the header? The new report we get now, the header name is not always in the same order so the index/match formula isn't cutting it anymore. Example...

I'm trying to average a set of cells based on multiple criteria (hence the AVERAGEIFS), but I want this average to change as more data is added. There may be a very simple fix for this, but I can't figure it out for the life of me. Below is a sample of the table followed by an explanation of...

I have a formula in a table that uses an IF function. The output of the formula dynamically plots a line chart. The problem I'm experiencing is that if the output of the IF function is False, then the "" value output is interpreted by the dynamic line chart as a zero instead of a blank cell...

I have created a Userform programmatically and created a series of controls on the form. Now I want to read from/write to one of the text boxes. I have tried everything that I can think of to reference to the control, but I'm having no luck. The control was originally created as part of the...

i know veritfically (ie offset($a$1,0,0,counta(....) but how do you make one horizontally for 2 rows. also, is it possible to make a dynamic range formula that expands BOTH veritically and horizontally?

I want a drop down list in one workbook that references a dynamic list in another workbook ie it may have entries added to it so I can't hard code the reference? If I select data validation for a cell, I set it to allow a list but what do I put in the source for the list to be from another...