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
1 answer

SSIS copy data from SQL db to multiple tabs on the same excel destination

I've got an SSIS package that loads data from a flat file source into a table within a SQL Server Database i then have a SQL task to get specific data and load into an excel destination, i want to add another SQL task to load different data into the…
sql2015
  • 591
  • 3
  • 13
  • 34
1
vote
0 answers

Openpyxl crash excel file with table after save

I have created a basic workbook with one worksheet and in this worksheet I have created a table (Insert>Table). Nothing complex in this table, just the value 1, 2, 3 (and the column header of course). I have written this simply code import…
Frederic Le Guen
  • 63
  • 8
1
vote
2 answers

Get Row number from each cell in selected range in Table with VBA?

Well. If I have for example a table with a column "countries" and other one "cities" And I make a Filter on Countries. How I can get the row number from each register filtered using VBA? I like to get rows numbers: 2 and 6. Thanks in advance.
PoorChristmas
  • 55
  • 1
  • 2
  • 9
1
vote
1 answer

Excel Pivot Chart - % Of Two Values

Let's say I have the following table: CORP | COAST | CITY | DONE | MISSING | TOTAL ------------------------------------- New | West | LAX | 2 | 4 | 6 Old | West | SFO | 3 | 3 | 6 New | East | NYC | 4 | 2 | 6 I…
4lackof
  • 1,250
  • 14
  • 33
1
vote
2 answers

Sum Filtered Column Within a Table

Within Excel Vba, I'm conducting a filter on table column referencing a ListObject; With TableX .Range.AutoFilter Field:=15, Criteria1:="100" End With I want to test the filtered column before executing further code, as it is possible the filter…
Jason_H
  • 31
  • 3
1
vote
2 answers

Compare two different tables with same rows but not exactly in the same order in Excel

I want to compare two different tables in Excel if they have exactly the same rows [number of rows and their fields] but the rows may not be necessarilly in the same order, say: col1---col2---col3---col4 col1---col2---col3---col4 1 …
MSnts
  • 13
  • 2
1
vote
4 answers

What's the quickest way to delete all blank rows of an Excel table?

I see several posts about deleting blank rows in a range and others about deleting table rows based on a single blank column, but nothing about deleting entirely blank table rows. What's the quickest way to do this? I posted my solution below to…
ChrisB
  • 3,024
  • 5
  • 35
  • 61
1
vote
1 answer

Excel Listobject Table Insert Rows Causes Cell Formula Error

Background: I've created a Word template that contains a routine that creates an array which holds a Project title in the first dimension and a Goal title in the second dimension. This array is transposed to a table in Excel to be used in creating…
Ron Kochanowski
  • 23
  • 3
1
vote
3 answers

Test for empty Listobject header

How to test if an Excel (Version >= 2010) ListObject header is empty? If I select such an empty header, then ?selection.value -> Column1 (or Spalte1, depending on client language) ?isEmpty(selection) -> false So as far as VBA is concerned, it…
Wolfgang Kuehn
  • 12,206
  • 2
  • 33
  • 46
0
votes
1 answer

Filter Count & Sum Based on Given Criterias

I have an excel workbook with a Database worksheet, this worksheet has a table RecordsTable. The important columns to note are: REG.DATE and CARD The RecordsTable[REG.DATE] are stored as Date month/day/year asin 8/7/2023 and 8/28/2023 and…
DigitalBraine
  • 111
  • 9
0
votes
1 answer

Office Script to Check if Table Header Exists Won't Detect Missing Header

I'm working on a macro in Office Scripts for Excel. Among other things I need it to check if a column header exists in the given table add a column if it doesn't exist, and set the desired header write values will to that column Validating the non…
truk2
  • 3
  • 4
0
votes
1 answer

ETF Sector Allocation Table

I am looking to build an Excel table listing funds which breaks down each one by its sector weightings in the columns which are manually inputted. In the summative row in each cell at the bottom of the table is the formula: C18…
BadDogTitan
  • 103
  • 1
  • 9
0
votes
2 answers

Range() in VBA on structured table stops working when column name has a quotation mark

In VBA I have this simple sub-procedure: Sub Test() Dim LookInColsSingleEntryArr(0) As Range Set LookInColsSingleEntryArr(0) = Range("UsersTbl[Father Countries]") End Sub I am assigning the data under column titled "Father Countries" in a…
jubitips
  • 3
  • 2
0
votes
0 answers

Excel table order consistency with data connection refreshes

I have a data connection inserting data into COL A-H when it gets refreshed. I have a table COL A-T (because i extended the table that is generated by the data connection). I input values manually in COL I-T. When i refresh the table sometimes data…
Felix G
  • 1
  • 1
0
votes
1 answer

populate a combobox based on other combobox using table ranges

I have the following code to populate two comboboxes based on one other combobox. before it worked perfectly with normal ranges. Now as I modified it to work with tables it does not work anymore. As the code says, the destination comboboxes are…
shahin syr
  • 33
  • 5
1 2 3
…
21 22