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

Why is my excel VBA Macro run successfully one time and then crash and close the workbook with no error message the second time?

I have two excel tables on two different sheets: "Open" and "Hold or Closed". On the "Open" sheet, I am trying to cut a row inside the table and paste it into the "Hold or Closed" Table if the "CLOSED_DATE" column record is populated. If not…
codinglag
  • 11
  • 3
1
vote
3 answers

Delete table rows if time in column is >07:45

I'm new to VBA and have got most of what I need working but I've got stuck on this last part. The sheet is being used to paste data into and then create a table for a specific purpose from the pasted data. I need to write a macro that will delete…
jwrt
  • 11
  • 3
1
vote
3 answers

How can I get pair of negative + positive value from a .xlsx table using python

I have an excel files that looks like this : N_order Amount 1137 258 1137 -258 1137 258 1138 802 1139 983 1139 837 1139 -837 1139 -248 I want to do pair with negative and positive value, but only pair, as an example I want…
Teddy
  • 143
  • 8
1
vote
2 answers

Office Scripts - How to select specific columns using column name from a table and delete other columns?

I want to select specific columns by Column Name from a table in Excel Online Workbook and delete other unwanted columns. I want to do this using Office…
Kavinda
  • 13
  • 1
  • 3
1
vote
1 answer

Adding Rows to Tables not specified in the If Statement

I am trying to add values to the end of a table in Excel. When I run the Macro, a row is added to each of the tables, even through the values are only added to the table specified in the If Statement. Code is below: Sub…
Mocha
  • 11
  • 1
1
vote
2 answers

Count items sold per day, excluding weekend, and including present day, by selected period

I have a table where column A is the date/time, and column B fruits sold. I need a formula that automatically counts how many fruits were sold per day. With the following additional conditions: I need the present-day included. I need weekends…
Verminous
  • 490
  • 3
  • 14
1
vote
2 answers

Error on defining Key:=Range("") for table filter

I'm working on a code to filter my table, but I'm struggling to set the 'Key:=Range("")' , so far I've tested a code without setting Dims and it works, but I want a more pratical approach, so the code will work in all worksheets (active worksheet)…
Cooper
  • 229
  • 1
  • 8
1
vote
2 answers

How can I make this macro work on all sheets in an Excel workbook?

I have recorded the macro below and I'd like it to work on all sheets / tables in the workbook. I've gathered that I need to replace "ActiveWorkbook.Worksheets("Ramp")" with "ActiveWorkbook.ActiveSheet.ListObjects" but I cannot figure how to get the…
BMax1985
  • 13
  • 3
1
vote
1 answer

Excel: Split rows of table in multiple rows based on different cell values

I have a CSV that contains multiple entries per cell per row: Name Friends Family John Simon, Kevin, Patrick Mum, Dad Jane Clara, George Grandpa, Grandma I want to transform it to this, so that each row contains only one pair. Is that…
Johannes Engelhardt
  • 73
  • 6
1
vote
1 answer

How can I speed up this loop

I have a Vba code that is very slow on 25 sheets, I am wondering if this code can be speeded up in any way Sub Obracun_place_OLP_NEAKTIVNO() ' ' Obracun_place_NOVI Makronaredba ' Call Refresh_neto_TM Application.ScreenUpdating =…
Filip Mišić
  • 11
  • 3
1
vote
2 answers

Figuring Out the Multiple Worksheet Change Function

I've read through a bunch of similar questions, but I'm honestly not quite understanding the solution. I've changed the code, and essentially seem to have broken it even more. Expectation: When the data in the E column is changed, the L and M…
Brandon DeAvilla
  • 41
  • 6
1
vote
1 answer

TEXTJOIN no duplicates no blanks, table references

I have this table: on Cell A4 i want the value "Orange,Banana,Peach,Mango,Melon,Watermelon,Apple". this is the requirements i have: table format (so instead of cells like B2,C2,etc - I need [@Fruit 1], [@Fruit 2], [@Fruit 3], [@Fruit 4], [@Fruit…
Kobe2424
  • 147
  • 7
1
vote
1 answer

Autofilter in VBA when criteria is has more words separated by a comma and I want to look for Each word in a range which has multiple words

For example I have a range which has cells containing A, B, C , D, E. I have a cell which has B,D. I want to filter out all the cells in the range which contains B,D and B and D.
Mukund Vyas
  • 11
  • 1
1
vote
2 answers

Add row with new ID

I made a code where I can add a new row to a table: Private Sub CommandButton1_Click() SaveOptions.Hide Dim myRow As ListRow Dim intRows As Integer intRows =…
Hugo Almeida
  • 49
  • 5
1
vote
1 answer

How to create an Excel pivot table from a table (ListObject object) via PyWin32?

I'm trying to automate Excel report generation in Python and I would really like to create a pivot table from a proper table, which equates to the ListObject object in COM. I used several code chunks I found in the web, and it goes like this: excel…
MPadilla
  • 69
  • 1
  • 1
  • 7
1 2 3
…
21 22