dynamic

Previously I had similar problem with this one, where I needed to assign a value to array's element then use ARRAYTOTEXT function. The reason I use arraytotext function is because I need to do iteration involving dynamic array variables, so I store the arrays in some cells in a row for each...

Hi - I have a list of company plant and would like to dynamically-highlight the column title as each active row is selected, based on that row containing an 'X'. I've kind of got part-way there, but can't get it over the line... It works for the first line highlighted in the set, but nothing...

Hello I have tried using the hyperlink formula to dynamically link to newly created test sheets from a template sheet. Its a basic workbook at this point with the template having name "sheet1", and the subsequent test sheets having names "sheet1 (2)" and so on. I have used the formula...

Hello - I have a sheet full of billing groups and their accounts, with account values and billable amount. In some cases, there is only one account in a billing group, but most of the time, there are multiple accounts within the same group. I'm using VBA to calculate a subtotal of both the...

Hello I want to select columns in the worksheet and then merge them in PQ. The first part is done. The second part drives me crazy. I searched the web and the best I could find was this: Stackoverflow.com But it errors with: Expression.Error: Das Feld "NAME" des Datensatzes wurde nicht...

I require a textbox to change the font size of text dynamically based on number of characters in the text Initially the size is 14 if no. of characters < 20 size = 14 if no. of characters > 20 and < 25, size =13 if no. of characters > 24 and < 30 size = 12

I have some data in a spreadsheet, and have used VBA to create a dynamic range object from this data like so: Dim ws As Worksheet Dim rng As Range Set ws = ThisWorkbook.Sheets("Sheet1") Set rng = ws.Range("A1").CurrentRegion I am new to VBA, so I don't know exactly what this range object is...

Hi, I've created a formula that works fine if it is within the sheet where the data originates, if is filtering the routes our vans will be taking and excludes any blank routes (if a van is not scheduled out that day). But I want to have the summary in another sheet dynamically changing based on...

Hello, I have what is supposed to be a simple problem with dynamic Checkbox. I'm making a list CheckBox in UserForm. Dim chkbox As MSForms.CheckBox Dim i As Integer For i = 1 To 3 Set chkbox = Me.Controls.Add("Forms.Checkbox.1", "Checkbox_" & i) chkbox.Caption = "Test " & i...

I have the following code that show details of a filtered PivotTable in new worksheets. I want to create new PivotTable in these new worksheets and have the following code but I keep on running into the object required error on the Set Tbl = d.Parent.Cells(d.Row, lCol).Name line? How do I fix...

Hello, I've been slowly but surely writing/cobbling together code snippets, to gain some pivot table functionality (to be used for "quick and dirty" analysis of fairly large data sets). I apologize in advance for when you see the associated code. I am on a deadline for how long I can work on...

I know this seems simple but I've been researching this for a few hours and I'm come up blank. I'm looking to do the following two things with conditional formatting. I need a cell in Row B to go RED if the planned end date has passed and YELLOW if the planned end date is within 14 days of the...

Hi, I'm trying to set the sourceRange as a dynamic range in VBA that starts from cell AC22 and offset with the height of COUNTA(data_date_range)+1, where data_date_range is a named range. and width of Columns(InputClaims), where InputClaims is also a named range. The following formula works...

=XLOOKUP(E2:E11,A2:A5,C2:C5,,-1) =FILTER(A2:A5,D2:D5>F2) I want A5 to be dynamic to the last cell with a value. I've tried my hand at sequence and index, but it doesn't seem to work.

Hello there, Although this is predominatley a Power Query Question, the criteria are obtained from an Excel Sheet and the output placed on 1 Excel sheet. I have some PQ code (Windows Excel 2016) that will load a single pre-specified CVS file into Excel as follows: Excel Sheet1: Excel Name...

Hi, I have a 11 (row) x 15 (column) table in Excel. Cells A2:A11 are the categorical variables, and cells B1:O1 are time values that I want to have as the x-axis. Cells B2:O11 are numeric values that I want to use for the stacked chart. I want to create a stacked bar chart of the data. I know...

Hello, I am having trouble with creating a hyperlink between two dynamic points. Sheet 2 is updated with new data every night. Sheet 1 is a smaller subset of the data, that also gets updated every night based on the data from sheet 2. The idea is to click on the project id on sheet 1 and it...

Hello all, I have set up the means to determine and count the number of public holidays during a year on a month by month basis. They work but I need the calendars to be dynamic to allow local holidays to be added. I have tried to set up a dynamic ranges to work within the existing formula to...

Hello! I've searched high and low across multiple forums for this specific answer, but I can't seem to find it based on cell value. I can find the VBA code for ALL worksheet names to be listed in the ListBox, but not specific ones based on cell value to be used as selections for printing...

I am trying to get dynamically the sum of Column E values if the corresponding F row value is empty. Any ideas what formula I should have on column G? Here is the live document link: https://1drv.ms/x/s!AkrCelEpjATAltgb8XshYXFVhjGaGA?e=VlNhyT