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

How do i add the complete data from table 1 from workbook1 to the end of table 2 in another workbook2 using Excel VBA macros?

I wrote the following code from here and there: Workbooks(location1).Worksheets("Lab Bench").ListObjects("ItemsSummary").Range("ItemsSummary[#All]").Select 'ItemsSummary is the name of the table, it has 18 columns lRow =…
Prashant Nittala
  • 11
  • 2
1
vote
1 answer

Why code gives 400 error, but runs in debug mode

I am having an issue where the below code will run fine in debug mode, but is throwing a 400 Error when activated normally. It keeps getting stuck on the Sub Assignee_List part of the code specifically the Sheets("Input…
Icaruim14
  • 51
  • 8
1
vote
2 answers

ListObject Error upon applying an Unlist Method

Basically, I have an Excel Formatted Table called "TestTable" in my activesheet. That's the only table in that sheet. I'm trying to convert it to a normal range. From looking up online, this should be simple, all I have to do is Unlist that table…
Diego
  • 392
  • 3
  • 16
1
vote
2 answers

deleting specific rows from a table

I would like to check through a table called "Sorted_Duplicate_Removal" for errors, blanks, and values of 0 and then remove these rows from the table. Unfortunately every time I run my code: Dim i As Integer For i = 2 To Worksheets("Resource…
Kyle Cranfill
  • 73
  • 7
1
vote
1 answer

Need formula to Detect "Different products" for same ID IN EXCEL

I'll need a formula in excel to detect for example 1111; has three different products linked, meanwhile 2222 has only linked "oranges" Here I left and example of my excel table: Product ID Product…
JoseCJ
  • 13
  • 3
1
vote
2 answers

Paste Data into table without overwriting data VBA

I am trying to filter data from one sheet and copy/paste that filtered data over into a summary sheet. I have 2 criteria that, if met, need to go into two separate summary tables. I am able to get the data filtered and copied, however, when it…
TDorman
  • 47
  • 6
1
vote
1 answer

how do i paste column widths and table settings to new workbook which is created based off of a unique value in original workbook

I want to add a paste column widths some how as well as a paste table formats but cant seem to figure it out Private Sub SplitWorksheet(ByVal Category_Name As Variant) Dim wbTarget As Workbook Set wbTarget = Workbooks.Add With wsSource …
Chris Keane
  • 11
  • 1
1
vote
1 answer

Copy and paste same values from 2 columns

I was hoping to be able to have a macro that would be able to extract the ID from each of our orders and put them into table 3.
Austin Ramos
  • 27
  • 4
1
vote
3 answers

How to select last populated cell in table column

I am learning how to use macros/vba and used the record macros function to understand how this works. For the part "Range("A31").Activate" how do I make it select the last populated cell? Since this column changes everyday- I would like to the code…
Number1Rock
  • 53
  • 4
1
vote
2 answers

Find column with specific name and fill the field with specific text to the last row

I need to find column named "Current" (preferred) or last column in general in the table named "YTD_input1" and fill all rows with text "Current" to the last row of the table. My suggested code is below but does not work. Dim pasteSheet As…
benjin
  • 65
  • 5
1
vote
2 answers

VBA Creating New WB based on unique Column data and converting new WB ranges to Tables

I posted a question similar to this in the past however a different issue has presented itself. Original Post found here. How existing code works: It creates a new workbook for each unique value, and its duplicates, in column A with all of the…
Blackmagic42
  • 83
  • 1
  • 8
1
vote
2 answers

How to copy from a cell and paste in a new row of a different table VBA

I am trying to do the following: Check each row if "Order" column is empty in table1 from sheet1 (there is only one table in this sheet) if it is "Order" column is empty, copy the "Notification" number from the same row AND then paste it into a new…
Aki G
  • 13
  • 2
1
vote
1 answer

Assigning Table/Header names in Sort Functions

I have a code that works when I assign ranges manually, but this is a bit cumbersome especially when it's unclear if the sheet will be modified and therefore make the values in the code incorrect. My original code Const ProcName As String =…
AesusV
  • 39
  • 6
1
vote
1 answer

Pasting after ClearContents in VBA

I am trying to copy data from a table into another sheet. Sub ListOfSquads() Sheets("Apontamentos").Select Range("Apontamentos[[#Headers],[Área]]").Select Range(Selection, Selection.End(xlDown)).Select Selection.Copy …
Gabriel Sotero
  • 155
  • 1
  • 13
1
vote
2 answers

Clear column content in Excel table based on specific cell value

I have the following Table in my macro-enabled excel file, Table1: My goal is: Before closing this workbook, I need to clear Column D content (shown as "Column 4" in the Table1), only where column D cells value = 999. For example, looking at the…
Hell-1931
  • 489
  • 1
  • 6
  • 24
1 2 3
…
21 22