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

Why am I getting this Compile Error: Type Mismatch

Hello everyone I am getting a compile Error: Type Does not match. in the code below. I was hoping you folks can help me out. Thank you! Private Sub cmbBusId_AfterUpdate() With Me .txtStOdo =…
Mr_Lemonhead
  • 23
  • 2
2
votes
1 answer

How would I loop through table headers to populate a ComboBox drop-down list?

I'm trying to loop through a table's header row to populate a UserForm's ComboBox drop-down list. The header row of my table is the second row of my worksheet. My thought was to use the intersect() function to check whether my loop is still inside…
Ira Banks
  • 23
  • 4
2
votes
2 answers

Use Excel's built in "My Table has Headers" functionality in VBA

I use a userform to select an area containing data which is manipulated in various ways. I do something like this to get the area: If Selection.Cells.Count = 1 Then Set rng = ActiveCell.CurrentRegion Else Set rng = Selection.Range End…
High Plains Grifter
  • 1,357
  • 1
  • 12
  • 36
2
votes
1 answer

Prevent user from inserting row in table except using VBA

I've created a table for data entering. However, as user use it, they insert rows in the middle of the table. That messes the formula up as the functions were designed only work forward. Also sometimes when the user add row manually (just by typing…
Tam Le
  • 360
  • 3
  • 17
2
votes
3 answers

Filling date on specific range inside a table

I have a table where i would like to insert a date as shown in image. It will copy the date to some continuos range. The program must find the range and then insert date using inputbox. I used the code below. The problem is it is not selecting the…
Deepak
  • 473
  • 1
  • 10
  • 32
2
votes
0 answers

Why Excel's convert to range property is disabled for some tables?

I have created a merge query with Excel Power Query add-in. But I can't convert the result table to range. Because the 'Convert To Range' button is disabled and I don't know. How can I convert it into table?
Ali Tor
  • 2,772
  • 2
  • 27
  • 58
2
votes
1 answer

Pulling Data Between Tables Using =IF Formula

I am trying to create a Fantasy Football Cheat sheet since my league drafts offline. The excel file has two sheets, one with all of the available players to draft sorted in a table, the other with my team as I draft them sorted into a table. I am…
LoganG
  • 23
  • 4
2
votes
1 answer

Excel ListObject Table - Remove filtered / hidden rows from ListObject table

I am banging my head to find a way to delete filtered/hidden rows from a ListObject table. The filtering is not performed trough the code, it's performed by the user using the table header filters. I want to remove the filtered/hidden rows before…
Gilles F
  • 121
  • 9
2
votes
1 answer

Excel table copy

I have a excel table in file A. The number of rows and columns varies everytime. I have to copy the table from this excel table in file A to another file B. I am trying to write a VBA so that everytime file B is opened . The table named "XYZ" is…
shweta
  • 21
  • 1
1
vote
1 answer

Excel VBA: reading 0.1 from sheet into range results in 9.999999996e-2

I have a table that I use to record measurements, all of which are increments of 0.1. The first column is just an index for the measurement, the second column is the measurement itself, then two additional columns to account for adjustments that may…
FreshlyBrewed
  • 11
  • 1
1
vote
1 answer

How to use openpyxl to add a new column to an existing excel table

I have a template spreadsheet with eixisting tables and formula referring to data in the tables. As a template, the tables start with one row of empty data. I wish to add data (rows and columns) to the tables but retain working formula. There is an…
Richard
  • 13
  • 4
1
vote
0 answers

how to create a modified table in python to download from django site

I have a django website with a database. On the site, you can add, change, delete information from the database. I made a button that, when clicked, downloads a .csv file. I open it in excel and it looks something like this: The data set does not…
user21402031
  • 31
  • 5
1
vote
2 answers

Excel TEXTJOIN Range, Order is by numbering

I have a range that I want to use TEXTJOIN on with delimiter CHAR(10) (linebreak) The values are the header names and the order is by the numbering that is on the row. If values are empty then ignore. see image below. any help will be much…
Kobe2424
  • 147
  • 7
1
vote
0 answers

Creating a variable row table from pivot table

struggling Excel user here. I think the below is likely relatively simple athough I am struggling to phrase the question, and therefore can't find answers online. I have a list of names from a Pivot table, I am wanting to transfer these names to a…
Lee
  • 23
  • 3
1
vote
1 answer

Specifying Which Column a Max Value Came From in an Excel Table

My example table Part Number 00 01 02 03 04 EX Max…
lberecek
  • 51
  • 5
1 2
3
…
21 22