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
0
votes
0 answers

How to update my dashboard using slicer from my table

Ok, I have one tab that I collect data from Power BI reports. In this tab (Export FF) I created a table called "FFLExport", I also have another tab called "Dashboard" where I created 13 slicer base on the table "FFL", once I manipulate the filter…
Larissa Victoria
  • 1
0
votes
1 answer

Reference to a column under a variable header of a table

Given a table T and headers H1, H2, H3. I know that we can use T[H1] to refer to the column under the header H1 of the table. Now, I have a cell A10 containing the header such as H1, H2, or H3. I would like to return the column depending the value…
SoftTimur
  • 5,630
  • 38
  • 140
  • 292
0
votes
0 answers

Why is the Power Apps form getting stuck on "Getting Your Data..." and not updating the data source?

I've created a form in Power Apps that when submitted is meant to append an Excel Table. It is in New Form mode and is connected to a data source. Two of the fields are from approved choices though, so I don't know if I did something wrong there. I…
Cedric
  • 1
0
votes
2 answers

VBA Select a range of cells within a table dataBodyRange using column names

Lets suppose we have a named table in excel with several columns C1,C2,...,C20. I want to select and process the table rows containing only the C10 .. C16 columns (for example). How to select this part of the table's data body? Unfortunately, the…
Zoltan Hernyak
  • 989
  • 1
  • 14
  • 35
0
votes
1 answer

Header not visible

I don't want a header on the table. For that, I passed the false in the tables.add method and also used the showHeaders:false for not visible the headers in the table. The table headers are not visible but there is one single row displayed at the…
Shiv Yadav
  • 467
  • 2
  • 11
0
votes
2 answers

excel new row doesn't add under a table

I have macro file (xlsm) that in vba put certain data under an existing table. then, another table in VLOOKUP searching that new data. in one computer everything work just fine, and the data is added in the new table as a new row, but in other…
Oran Dinelton
  • 51
  • 3
0
votes
1 answer

Excel VBA - Run-time error '1004' Application-defined or object-defined error when assigning a Date

I am trying to assign a Date to a table column. I get 1004 error on each Date column. Public Type JobStatusDetailLine ... PromisedShipDate As Date LastOpDate As Date ShipDate As Date End Type Public JobStatusDetailArr() As…
mchernecki
  • 29
  • 7
0
votes
0 answers

How do I get data from an unused Pivot Table text field using VBA?

I have a PivotTable which helps us review company charging, and I'm trying to figure out how to display comments the employee left in their time charging in a cell on the sheet. The pivot table itself has rows of Projects and Employee Names, and…
John Hamilton
  • 3
  • 3
0
votes
1 answer

How to insert userform data in new row below headers?

I have a userform with a Submit button to insert data into the top row of a table, below the headers, in a worksheet called "database2". The issue is adding the top row. I tried recording a macro to see the code. The button is supposed to: add a…
Magjack
  • 1
0
votes
1 answer

Choose table to add a row to in power automate

I'm very new to power automate and I'm looking for a way to add rows to a specific table on a spreadsheet based on forms submission. For example, if the form comes from a specific city, I want to update that city's specific sheet and table in the…
Baby Yoda
  • 34
  • 6
0
votes
1 answer

How to have a structured reference respond to filters on a table?

I have a table in Excel with multiple columns. One of the columns is an index column with an arbitrary number (1,2,3..). At the moment I have a pivot table where the rows of the pivot table are in sync with the rows of the source table, even when…
MaxxL
  • 15
  • 5
0
votes
1 answer

Excel: Attempting to have 2 tables of different size communicate without a #SPILL error

I run into the error because I am trying to make a string of formulas that read when between 2 dates in "table 1" is negative it pulls information from "table 2" to have it highlighted on the graph as a data callout. Biggest problem I'm having is…
Kai Sosa
  • 3
  • 2
0
votes
1 answer

Reference a table in formula with table name in a cell

Let's say that there is a excel sheet with a table (Table1) and a cell (C1) in which the table name is written (as text). Can I make a formula that uses notation for using values from the table (e.g. Table1[Column1]), but instead of hardcoding the…
Razero
  • 321
  • 1
  • 4
  • 16
0
votes
0 answers

SUMIFS using two unrelated Tables in Excel on same rows

When building a financial model that is set up using multiple unrelated tables, however on the same rows across the worksheet, I am having trouble with structuring formulas the same way as you would with a single Table in Excel. The very first table…
FSM
  • 1
0
votes
0 answers

Creating and updating Excel Tables through xlwings

I'm trying to create and update excel tables through xlwings. The documentation provides a simple exemple to create a table but it returns the following error : AttributeError: 'Sheet' object has no attribute 'tables' here are the lines import…
Overkill32
  • 1
1 2 3
…
21 22