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

found 'TargetTable.Range.SpecialCells(xlCellTypeVisible).Copy _ ' Destination:=Sheets("Sheet8").Range("A1")

I have a sheet named "Staffdb" with two named tables "PermTBL" and "StaffTBL", same headers "Girls" "ID" "Hire_date" and "Status". All of the current and historic staff are in PermTBL. I would like to filter PermTBL on the Status field for "A"…
YangonBill
  • 1
  • 1
0
votes
1 answer

Excel Sumproduct from 2 tables with multiple matching criteria

I need a help please, I have 2 tables: one has days an employee worked on the project/proposal in a month(Jan, Feb etc.), and the other has employee rates. I need to multiple matching rates and Jan days where all the criteria are same in both…
Kev
  • 3
  • 4
0
votes
1 answer

How to link a Table and a Pivot Table using Slicers in Excel?

Well. I have a table named "ALL_INFO" on a Sheet in Excel and I made a Pivot table in other sheet, its name is "PIVOT_INFO". And I would like to know the way to link a table, and a pivot table using Slicers to filter information and it be reflected…
PoorChristmas
  • 55
  • 1
  • 2
  • 9
0
votes
2 answers

How can I change my excel table layout?

I'm currently stuck with a problem with my Excel data. I have a csv file which has the following values; **Country | Country Code | 1990 | 1991 | 1992 | ... | 2015** *United States | US | 93 | 93.5 | 93.2 | ... | 95.4* *The Netherlands | NL | 100 |…
Tim Hellegers
  • 87
  • 11
0
votes
2 answers

Excel Referencing

I am trying to compare a value (for example if D4 >= 10) and if this is true have it pull the data in the column. This is to pass information from one table to another in the same excel sheet. For some reason I cannot seem to do this for a whole…
Josh
  • 77
  • 1
  • 8
0
votes
2 answers

Add named worksheets using For Loop

I am trying to write a code that will take a list of titles/names, and create a tab for each one of them, with each worksheet having a name from the list. For example, given a table on the ActiveSheet (might not necessarily be sheet1) Metric |…
Matt G
  • 67
  • 1
  • 2
  • 8
0
votes
1 answer

PowerApps error message for users

I have created simple PowerApp based on an Excel workbook stored on OneDrive. The workbook contains a table of 1,000 rows and 3 columns. The PowerApp works perfectly for me (owner). But when I share it with another teammember and provide view…
user974061
  • 343
  • 1
  • 5
  • 17
0
votes
1 answer

Data Validation List from Filtered Table

Below is the source data (sTable) Name Email List User1 u@em.co No User2 u@e.com Yes User3 t@em.co No User4 f@e.com Yes User5 w@e.com Yes User6 d@em.co No User7 i@e.com Yes The Destination table: (dTable) SomeStuff …
Chandler R Reeves
  • 93
  • 2
  • 16
0
votes
1 answer

Transposing an Excel table with 1500 rows and 13 columns

So I have this table in Excel as below: . The table has 14 columns and 1500 rows depicting car (for simplicity) sales. Now, what I want is to have the table transformed like this: I know there is such thing as a transpose formula (which I used to…
user71812
  • 457
  • 2
  • 4
  • 19
0
votes
1 answer

Table Reference when copying a worksheet

Second part of a question which has been answered on here First Part Of Question I have a worksheet that contains a table that has some code to add columns as and when needed. This works perfectly (thanks to answers on this site) but within the code…
Sploits
  • 1
0
votes
2 answers

Tables overwritten when exporting multiple tables from excel to word

I am trying to use VBA to create a Word document with multiple tables each on a new page (using a loop) compiled with cell information from Excel. So far everything works fantastically except after inserting the first table it is replaced by the…
Joseph Andrews
  • 1
0
votes
3 answers

Combining IF and RIGHT functions in excel

I'm a super novice, trying to navigate data analysis in Excel, so be kind! I need to combine the IF and RIGHT functions. So it's a sales dataset with different products, I need to use the IF function to filter the products so it only applies to…
sgregory
  • 1
  • 1
  • 1
  • 2
0
votes
1 answer

How do I create an Excel table with a blank header

I have an Excel table that summarizes data from a TFS query using COUNTIFS() statements. It works great until I get to the end and I want to use a blank value to display a count of the blanks. For the row values I can just type an apostrophe and…
Sam
  • 487
  • 1
  • 10
  • 25
0
votes
2 answers

Hiding certain columns on an Excel table

I've been trying to hide table columns on my Excel spreadsheet. While I can hide entire columns if my data was not in table form, this is something I cannot do because of the information that is underneath the table. For the purposes of this…
Ladainian
  • 13
  • 1
  • 2
0
votes
1 answer

Is it better to use a large Excel table or multiple small ones, and why?

I have a headcount dashboard which looks at data for the last 13 months, which is about 26000 rows by 55 columns for each month. Currently I have a table in its own tab for each month and use formula to analyse this data. In terms of times to…
Nathan Burt
  • 3
  • 3
1 2 3
…
21 22