dynamic

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

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.