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
1
vote
3 answers

Write Array To Table

I am trying to write a function to output the data that is in a 2D array to an empty table. Function WriteArrayToTable(InputArray() As Variant, TableName As String, SheetName As String) Dim MyTable As ListObject: Set MyTable =…
Erik Remkus
  • 37
  • 6
1
vote
1 answer

Some cells in Excel rounding correctly to an integer but not applying conditional formatting

I have a column in Excel 2010 which is formatted as a number with decimals set to 0. It also has conditional formatting to color the cells green, yellow or red based on their value range. It all works fine except for certain cells whose…
Chris R
  • 39
  • 1
  • 7
1
vote
2 answers

Reference a table by index number

I'm trying to clear cell contents within a specified table column range ([Front Straddle]:[Front Option]), of all tables within a specified worksheet. This script will only live within the "VolJump" worksheet, which contains an arbitrary number of…
jlakes85
  • 57
  • 1
  • 6
1
vote
0 answers

Is there a difference where the implicit intersection operator @ goes in an Excel formula with structured table references?

Context I just received an update from Excel1, and now it's littering my formulas with the implicit intersection operator (@). Also in formulas that use structured table references like table1[@Column1]. It transforms the latter to…
Saaru Lindestøkke
  • 2,067
  • 1
  • 25
  • 51
1
vote
0 answers

How can I delete old entries from an excel table (automatically) when I upload new data?

I have a query related to excel tables that I use to build my pivot table. Now we know the excel table automatically gets updated when we add new data. But my issue here is let's say, for example, I sold 20 books this month and the details of these…
Gagan Ganapathy
  • 35
  • 6
1
vote
1 answer

Excel: Running occurrence of items in table column

I am trying to achieve this in a table in Excel: https://exceljet.net/formula/running-count-of-occurrence-in-list So, counting each item in the list in an ordered sequence: (I want it for Red and Green too, of course) If I however convert it to a…
Streching my competence
  • 381
  • 1
  • 5
  • 21
1
vote
1 answer

VBA:Subscript out of range error : For loop :multiple worksheets -Table creation

VBA newbie: Code runs fine on 1st worksheet but throws an error on the rest Dim st As Worksheet Set st = ActiveSheet For Each ws In ThisWorkbook.Worksheets ws.Activate ''--------------------------------'' 'Print lables on…
DiyaShetty
  • 95
  • 1
  • 9
1
vote
2 answers

Excel VBA select mulptiple cells based on selection

I would like to select multiple cells based on selection. And here is my code: Private Sub CommandButton1_Click() Selection.EntireRow.Select End Sub I want to select the first four columns of rows in multiple cells, instead of the whole rows. How…
Adrian
  • 15
  • 4
1
vote
2 answers

How to select range in Excel ListColumn's DataBodyRange from second to second last cell with VBA

I have data formatted as a table. I am trying to choose a range of cells in a certain column, regardless of the cells having data. The number of rows in the table will change, which is why I need to use a dynamic range. I managed to select the…
Emma
  • 13
  • 1
  • 4
1
vote
1 answer

Inserting a new table column to include IFELSE results of previous columns

Column L containing boutique numbers and Column AB where the new inserted column containing the boutique codes will be. As my title suggests, I am hoping to add a new column to a table containing IF ELSE values from a previous column (Column L,…
CleanRider
  • 149
  • 9
1
vote
1 answer

VBA - cells overwritten when looping through multiple workbooks and saving to master workbook

I have a folder with multiple .xlsx workbooks, all of which contains the same 3 tables on one page with the exact same layout but different values within each table. As each workbook contains 3 tables on the same page I have a VBA script which…
Gideon B
  • 415
  • 1
  • 3
  • 16
1
vote
1 answer

Need a general purpose Excel VBA method for sorting tables

Lately i have been doing a fair amount of work sorting Excel tables and was looking for an Excel VBA method to generalize that task. It needed to be simple and easy to use.
j2associates
  • 1,115
  • 10
  • 19
1
vote
0 answers

Looping and Recording columns in Filtered Table if one cell follows condition

I have difficulties with looping through my table when there is a filter (something I want since I have to filter first and then run the macro on the remaining cells). Let's say table mainly contains empty cells and few "x" randomly distributed. I…
Stef9169
  • 11
  • 1
1
vote
2 answers

Excel - How to reset the default Table name when copying a sheet with a table

I have a workbook with one worksheet Sheet1. On that Sheet I have one table with its default name Table1. When I copy the worksheet Right-Click > Move or Copy in the same workbook I get sheet Sheet1 (2). The Table on this sheet is automatically…
Michiel
  • 29
  • 3
1
vote
2 answers

Excel 'put random value in a cell and run permutation " easiest problem

I have an Easy problem. Anyone kindly assist. I have name(s) in Excel I would like to populate with a random full stop in between the name For instance A. B. 1 Name n.ame 2 n.a.me 3. n.a.m.e 4. na.me Etc all possible…
Jamie
  • 21
  • 1
1 2 3
…
21 22