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

Auto Filter Array only Filtering by Last Criteria in Array

I am trying to sort a table by deleting rows that have their cell in column 9 NOT beginning with S, X, or P. Below is the code that I have that filters for the rows that do not meet my criteria, and then deletes them, and then shows the remaining…
Bert328
  • 119
  • 8
1
vote
1 answer

Iterate to Find Listobject in a Workbook

I am trying to find a table ( ListObject ) from a excel workbook ( Lets say workbook 2 ) after opening the same through a VBA subroutine in another workbook ( Lets say workbook 1 ). The code I tried is as follows , Sub B() Dim TBL_EMP As…
Asanka.S
  • 61
  • 7
1
vote
2 answers

Find Table objects in the active sheet to remove auto filter

I need to find the one table (one worksheet will only have one Table) in the Active worksheet and find the first & last column in that table and remove the auto filter from those first and last columns. Currently I am doing this:- The problem is I…
Jawad
  • 8,352
  • 10
  • 40
  • 45
1
vote
1 answer

Delete Filtered Rows in Table and not entire Row

How do I delete table rows only and not entire worksheet rows when my table is filtered? Dim TradeTable As Excel.ListObject Set TradeTable = Sheets("Pre Trade").ListObjects("PreTradeTable") On Error Resume Next With TradeTable …
Motacular
  • 33
  • 7
1
vote
1 answer

How to create a new table out of pasted values VBA

I try to make a table out of new range which has just been pasted (it is an extraction of old table but only part of it, not entire so it doesn't paste as a table) in the worksheet, however I got an error. It used to even create a table with this…
lifeofthenoobie
  • 127
  • 1
  • 7
1
vote
0 answers

When a cell is being populated through a formula in excel, is there a way to freeze the populated data (prevent it from getting updated)?

I am working on automating some fields in a table in excel. I want to automatically add a 'Block Date' when the status is change to 'Blocked' in following table structure. sample table here I am using this excel formula for it:…
AVS
  • 11
  • 2
1
vote
1 answer

copy a table in 1 workbook to another workbook

I am new to vba coding. I do not know if this is possible but can you copy a table (Daily) in 1 of my sheets to another workbook. I want the 2nd workbook to open, paste the selected data range into the table in the 2nd workbook, and then save and…
user13596510
  • 57
  • 6
1
vote
2 answers

Random of Table Header Name of another table via INDEX MATCH

I have these 2 tables: On column B i'm trying to get one of the Header Names of a feature that is not empty on Table B. I want it to be selected randomly. The order of the items in Table A can be different than the order of the items in Table B,…
Kobe2424
  • 147
  • 7
1
vote
1 answer

TEXTJOIN of INDEX MATCH of another table unique values by SKU

I have Table A and Table B. On Table A I have a SKU column, a Fruit column, and a column where I want the formula to be at. On Table B I have a Fruit column, and a Price Range column. on column C, I want a formula to get a TEXTJOIN with delimiter ",…
Kobe2424
  • 147
  • 7
1
vote
1 answer

Removing Duplicates from ComboBox sourced from Table - Excel VBA

I have a combobox which is populating value from a table column. The column contains multiple rows including rows with duplicate values. I want the combobox to contain only unique values. The code I used to populate combobox: Set wb =…
crazyboy24
  • 45
  • 6
1
vote
1 answer

copying 12 diffrent workbooks to one, any way to optimize the code and make it run faster?

I need to open 12 different workbooks copy the data to 1 workbook in 12 sheets and make each range a table, any way to make the code faster than what I wrote? all workbooks are in one shared folder, mixed with different workbooks that do not need to…
dima gorokh
  • 37
  • 5
1
vote
2 answers

TEXTJOIN of column with same values of other columns, Table references

On column D i want TEXTJOIN of column C. delimiter is comma with a space after: ", " the two conditions that have to be met are: same date in column A, same value in column B This is a table so I prefer using references of the name of the columns…
Kobe2424
  • 147
  • 7
1
vote
2 answers

Excel VBA 'Format as Table' for all rows with data

So I've create below macro with the record feature: ActiveSheet.ListObjects.Add(xlSrcRange, Range("A1:L656"), , xlYes).Name = _ "Table1" Range("Table1[#All]").Select ActiveSheet.ListObjects("Table1").TableStyle =…
Lawrence
  • 11
  • 5
1
vote
2 answers

Is there any way to copy a complete sheet to another workbook by pasting only the values, but keeping the tables?

I am going to keep it simple: Is there any way to copy a complete sheet to another workbook by pasting only the values, but keeping the tables ? Right now I am using the code below, but I can't seem to keep my tables in the new file that is…
Janson Martin
  • 13
  • 4
1
vote
1 answer

Format range as table

I have a set of data that changes in length. I would like to make a macro that does various things, including making the entire data set a table? Using Selection.End(xlToRight) and xlToDown to select the data works, but when the recorded macro…
OFFICE_HELP_
  • 11
  • 1
1 2 3
…
21 22