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

Excel - Create one to one relationship between tables

I have a workbook for controlling attendance of students on a course, modelled on many worksheets. The first worksheet have the cadastral data for all students. The other ones have attedence data of each month. I need to dinamically update the first…
Rafael Leite
  • 75
  • 7
0
votes
1 answer

VBA: Error 1004 merged cells when copying data into a table

The objective is to a copy a range of data into a prexisting table, where the table first removes the old data. I have additional code but this is the part of the code that handles the table data. Important note: The range I am copying does NOT…
BlackBear
  • 385
  • 1
  • 5
  • 25
0
votes
2 answers

Delete Table Row Based on Criteria VBA

I am attempting to delete a specific table row based on values in two columns. I attempted to apply filters to the table columns to narrow my criteria, but once I click delete, the ENTIRE ROW is deleted causing values outside of the table to be…
MSauce
  • 123
  • 2
  • 13
0
votes
2 answers

Select and Delete Multiple Rows

With Sheet(name) .ListObjects(Table_name).ShowTotals = False .ListObjects(Table_name).Range.AutoFilter _ Field:=8, Criteria1:=ListBox1.Value, _ Operator:=xlFilterValues …
Diaa El Din
  • 1
  • 1
  • 1
0
votes
1 answer

Extract data between two dates from an Excel table into another Excel table?

Scenario: I have two named tables in the Excel with common column "date": "MonthlySheet[date]" "WorkShiftAll[date]" lets take a look into the sample data-set: I'm trying to index dynamically all records from the WorkShiftAll[date]which are…
Saffa Seraj
  • 77
  • 1
  • 8
0
votes
1 answer

Excel VBA - ShowAllData of table fails

I have this longer piece of VBA (see also my former question: https://stackoverflow.com/questions/53206850/copy-rows-which-match-criteria-into-two-or-more-different-sheets-in-excel-with-v). One particular piece doesn't work properly. I want a table…
Ekfa
  • 93
  • 3
  • 15
0
votes
1 answer

Deleting worksheet row based on value tied to a table

I have a worksheet with two tables on it located starting in column B. In Column A I have a COUNTA formula that is tied to a delete blank rows button. My code works great to delete the table row but i need it to delete the entire worksheet row so…
JessicaGMG
  • 11
  • 1
0
votes
2 answers

A table's column of same cell of different spreadsheets

I have different spreadsheets (on the following photo, from 1 to 25); They have the same layout ( Photo here ). I want to create a table with the E7 cell of each spreadsheet (A table of every "Total"). I tried this by extanding the formula...sounds…
mewX Max
  • 31
  • 1
  • 8
0
votes
0 answers

How can I sort a column with associeted tables inside the cells [Excel]

I have an excel table with associated tables inside cells. This is an example: If you click on "+", you can see the associated table: I tried to sort the column PSM from highest to lowest. The problem is that excel doesn't respect the associated…
Enrique
  • 842
  • 1
  • 9
  • 21
0
votes
1 answer

Excel Hates Defined Name for Formula referring to Same Row in Table Format, e.g. [@[TableColumnName]]

When I try to make a defined name (Formulas > Defined Name > Name Manager > etc.) representing the local or same row in a table, e.g. =[@[TableColumnName]], Excel won't let me, says "The syntax of the name isn't correct." I know by trial and error…
Travis Bennett
  • 131
  • 3
  • 12
0
votes
1 answer

Formula Referencing Excel Table

I am using Excel 2013. I have a table with three columns: Start Date, End Date, and Holiday - a column containing a formula to check if a holiday falls between the Start Date and End Date. The Start Date and End Date columns contain references to…
mjp
  • 99
  • 1
  • 12
0
votes
1 answer

Copying and Pasting into a new Table Row using VBA

I am trying to figure this out and I am hoping you can help Basically I have Form and Data Sheet. I am looking to copy the information in the form into a new blank row within Table1 on the data sheet, I have managed to get as far as the following…
Geoff Bird
  • 9
  • 1
  • 5
0
votes
2 answers

Transferring data in Excel

I have a table where each row represents one logical value. Sort of like this: | January | Margaret | 10 | | February | Jeff | 20 | | March | William | 30 | I want to transfer the data to another table, where the data would be modelled as…
Maelstorm
  • 1
  • 1
0
votes
1 answer

Excel: Linking the data of one Table's column to Table in another Workbook

Thank you for reading my question. I am looking to replicate certain columns (e.g columns A,D,F) from a table (e.g TableX) DYNAMICALLY to a set of columns (e.g columns H, J, K) in a second table (Table Y) in a second workbook (Workbook 2). I want…
RDawn
  • 1
  • 1
0
votes
1 answer

Derive cell value of an Excel Table based on two parameters

I have 2 columns in excel, A and B. In A I have percentages (rates) and in B integers numbers (years). rating PD year 0.39% 3 0.88% 2 1.32% 17 0.88% 1 0.26% 15 0.17% 2 0.17% 2 0.59% 2 0.59% …
Saverio
  • 111
  • 8
1 2 3
…
21 22