table

I have tried a number of formulas to get this, and I keep getting circular references. My use case is a construction project budget, where I have a hierarchy of categories. In a single table, I want to make the inputs AND see the rollup (I am familiar with PivotTables, and they do not fit this...

Hi everyone, I was wondering if it's possible to create #This Row type table reference using a text stored in another cell - I have unsuccessfully tried a few things including INDIRECT but nothing worked. BACKGROUND: my spreadsheet has a manual input in the cell A1 and a formula stored in a...

I cannot figure it out. I am trying to scrape a table from the website CapWages - NHL Salary Cap Data which will scrape the first 50 rows but because the website makes you click next page, it will not display the next ones. Normally, websites add to the url to advance the page...but this site...

Hi everybody I'm trying to write a macro to enable colleagues to sort a table on a protected worksheet. This table and worksheet are protected in regards to formatting to prevent unwanted changes to the tabel by colleagues who aren't very excel-savvy. Unfortunately, because of the locked...

I have a table wher I'm trying to use Sumproduct by row, and an Fixed Range out of the Table Range. The Table Range is [B4:I5] and I need to use SumProduct on [H] Column that must consider the current Row and the Price Values, on Fixed Range, [C3:G3], to calculate the Total on Column [H]. The...

Hello, excel gurus, So, I have a vba code that checks every checkbox that i have in a table, and deletes said checkbox if the row is empty or outside of the table, but I had to put a "+8" in the row range, because the table starts at row 7 of my worksheet. Problem with this, is if someone make...

Hi all, I have vba code to update the workbook when there are changes in a table. My problem is that if I add a row to the table, it calls the code and updates the workbook, but if I delete a row, nothing hapens. My code is this on: Private Sub Worksheet_Change(ByVal Target As Range)...

Here I come again with my questions. I'm trying to add a column before the last column of a table and insert the name of the column with a value that is inputed by the user. How can I do that? Already have code to check if already exists a column with that name in the table, if there are...

Hi guys, I have a file where I have an inputbox, where the user types "MyInputMatriculaMaiusculas" values. This variable is then used to o through a table and delete the row, where this value is in the second column. Or, at least, that was the goal, because, in reality, this code is doing...

I'm trying to insert a table whose content are contained on a spreadsheet (Let's say within the range A1:D4 as an example) into an email. I've written the body out in HTMLBody format and have followed the instructions from this guide to insert the table: Convert Excel Range Into HTML Table...

I have a table that is looking up data from a different table. One of the input variables is the header, I have 29 columns that all have the same formula (across 250 different tables). I'd like to write a lambda function, so I can drag the formula across the whole table. Is there a way I can...

Hello everyone. I created a master table where I set IDs, and used "Existing Connections" to create another table (Table B) using this method , where I created additional columns and insert more information about these IDs. The thing is, if I insert new data in the master table and refresh the...

I have a sheet with just one table. As of right now, the table is named "Main", but it will get changed later (working with queries). Here is a test function that checks for a certain set of values within two columns of the table: Function testFunc(ByVal a As String, ByVal b As String) As...

Is it possible to create a new table based of multiple column of an existent table, but replacing the values that are negatives to zeros?

I´m having trouble creating a rolling chart regarding the syntax of the OFFSET Function for specifying a dynamic range. i want to make the table so that. when a new column header is added, the same values of previous collumns are added bellow this new collumn header aswell. I´m doing this by...

Hi all, I'm copying some data over from an input spreadsheet into a data table, I'm using the below code which finds the first blank cell in the tables first column and correctly updates the value, but then when I repeat it moves down a row, I assume because the table auto creates the whole...

Hi! i´ve been struggling with this one for a bit now. I want to paste something into the Last Column Header of a Table. I´ve tried with following code: ActiveSheet.ListObjects("TableName").HeaderRowRange(LastColumn).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone...

Hi all, i hope you're doing well. First of all, sorry for bad English. I'm currently using Excel 2021 and trying to experiment with Dynamic Array formula lately. It's quite helping with my daily Excel use. I have a one case where i want to divide its own cell using a value from another cell...

So I'm trying to return a cell value from a table, relating to a text based cell as the searching tool. It's actually part of a larger formula, but the rest is straight forward. I am trying to return a result where if the day of the week changes in A2, it changes what cell I use in a formula in...

I have a table with 3 columns, whose fields I show below: ABCDE123Customer_IDProcess_NumberFolder_Name41234P0000000011234 - 155678P0000000025678 - 267D4:D5D4=[@[Customer_ID]]&" - "&[@[Process_Number]] The [Process_Number] Column, has the Format...