Stack Overflow
Stack Overflow

Questions tagged [excel-tables]

Questions dealing with structured (aka ListObject) tables in Excel-Formula and Excel-VBA. Should be reserved for questions involving the special syntax of Structured Table References.

Questions dealing with structured (aka ListObject) tables in Excel-Formula and Excel-VBA. Should be reserved for questions involving the special syntax of Structured Table References.

324 questions
2
votes
0 answers

RichApi.Error: There was an internal error while processing the request

I have developed an Excel Javascript plugin using the React framework. The add-in workflow is simple. Request data from Ui using APIs Passing entities' column names and authorized API keys Start writing data into an active Excel sheet by pulling the…
Shiv Yadav
  • 467
  • 2
  • 11
2
votes
2 answers

VBA Create and Rename Tables

I'm looking to create a table without selecting the first row and creating a table. Then naming the table based on what the sheet name is. Sub ConvertDataToTables() ' For i = 3 To 5 ' Sheets(i).Activate ' Rows(1).EntireRow.Delete ' Next i …
ojmayo
  • 53
  • 5
2
votes
2 answers

How do I select any table on a new sheet? (VBA)

First time posting and real beginner in VBA. I was trying to write a macro that changes to the next sheet down (Essentially ctrl + pg dn function), selects and highlights values within a table and then clears the contents. The problem I am running…
L__Hillll
  • 21
  • 1
2
votes
3 answers

How to merge rows based on value in one column in Excel?

I want to merge/concatenate rows if those rows have a duplicate values in one column. The merge step applies to more than one columns. In de table below I show an example of the…
thomaswerk_94
  • 21
  • 3
2
votes
2 answers

Creating worksheets and naming them with the values in a list/table

I am trying to create multiple worksheet in a workbook and name them based on a contents in a particular table. I am doing this as the list can be dynamic and might need to create more/less sheets depending on the requirement. Sub…
Saloni
  • 31
  • 2
2
votes
2 answers

Aligning vertically a series of tables with text

Hi I need the text to be in a specific format in a spreadsheet to be able to upload it on a translation tool. I have already used the text split function to separate the text in a cell with bullet points, moving each bullet point to a separate…
user20570378
  • 23
  • 3
2
votes
2 answers

VBA code to delete row in an Excel table (ListObject) if a specific cell (DataBodyRange) includes a specific substring

Summary. I am trying to loop through a table and delete each row if a particular substring is found in a specified column. I am specifically stuck on the line of code that finds the target text, which I know to be incorrect, but cannot find the…
Steve P.
  • 25
  • 4
2
votes
2 answers

Dynamically storing a cell reference as a variable in VBA to then select (and delete) a range using the variable stored

I currently have a VBA macro that turns a regular data extract into a table. In the macro I have defined a range which is large enough to exceed the number of rows typically extracted. ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1:$AG$20000"),…
ScottG
  • 23
  • 3
2
votes
3 answers

How to sum column until current row?

I'm using an Excel table to sum some values. On a certain column, I want a running total (that is, a sum of all values previous and up to the current row). Doing that on ranges is easy, all I need to do is use an absolute cell address for the start…
Bruno Brant
  • 8,226
  • 7
  • 45
  • 90
2
votes
0 answers

Subtotal in result row returns 0 in excel table

I have an excel table ("lstTestSource") like this: I have a second excel table ("lstTestResult"), which evaluates the first one: There is a formula in each row in the second column…
Sergeij_Molotow
  • 83
  • 7
2
votes
2 answers

Getting error 400 looping through worksheets to get datas

I'm trying to loop through my 89 worksheets and extract some data to consolidate them. I want to skip worksheet "global" and "34". I want to get the data from column A to M except row 1. I want to get those data (that are not in tables) and put them…
grigri
  • 65
  • 5
2
votes
2 answers

Match Value and copy onto same line Excel VBA

I hope you’re all well. I have some VBA code that I’m having a little trouble with & was wondering if anyone might be able to lend a hand, please? The issue; If there are multiple rows on sheet 1 that need to be copied, I’m only able to copy one…
new11
  • 55
  • 6
2
votes
1 answer

Index and Match Matrix formula to

I'm really stumped with converting Index + Match to VBA. I'm very new to VBA, this is proving to be beyond my abilities. I have a table in Sheet2 With Columns, 'Case', 'Probability', 'Impact' & 'Severity'. Then a Matrix in Sheet1 My formula (filled…
DomDomDom
  • 23
  • 3
2
votes
2 answers

Resize a table with formulas based on table input

I want to resize the table "ProductList" on my worksheet "Final" depending on the input from the source table "SourceTable" on the worksheet "Input" (fields derived from source table helped with formulas). Eg.: Firstly, I want to refresh source…
benjin
  • 65
  • 5
2
votes
1 answer

TEXTJOIN of INDEX MATCH unique values if value on another table is contained in a cell

On cell B5 I'm trying to get a TEXTJOIN with delimiter "," of INDEX MATCH to the price range you see on Table B. Because cell A5 contains "Apple" then "$$$" is one of the values I need, also A5 contains "Banana" then "$$" is the second value i need.…
Kobe2424
  • 147
  • 7
1
2
3
…
21 22