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
votes
2 answers

New table values are not included in excel calculations

I have created a table in excel which contains information on licenses, and I have created a formula which adds the value of licenses purchased in the last 30 days. The following code seems to do the trick: =SUMIF(LicenseList[Purchase date],…
Tim
  • 1
-1
votes
2 answers

Delete columns from a table that have Headers only

I have a table that has many columns (includes autofiltered headers) and some of the columns have just the header with no other data following withink that column. I want to remove those columns from my named table.
teenyla
  • 11
-1
votes
2 answers

A "CodeName" for an Excel table column for use in VBA

I'd like to be able to retrieve values from an Excel table by row number and column name (for code readability and robustness). In formulas, I can use Structured References with column header text and get a value from the table like…
ivan_pozdeev
  • 33,874
  • 19
  • 107
  • 152
-1
votes
3 answers

How to Set Range of Table Data for use with Chart

Using Excel 2010 I am trying to create a chart on Sheet1 using partial data from several different tables. In the below example I am just trying to pull the data from one table as a start. I seem to be having difficulty setting the range of this…
VBANewbie
  • 17
  • 1
  • 10
-1
votes
1 answer

Coloring string in Word document when transfering it from Excel using VBA

Sorry for maybe unintelligible title but i cant find out how to write this better. I've got Excel VBA code that transforms the sheet from Excel for a version to print in a Word. The problem is that when a specific cell in a row in Excel is red…
Galinowsky
  • 3
  • 3
-1
votes
1 answer

Sum product for all the months if 2 tables match

So I have this issue, I have two tables one is employees, and another one is the projects. Employees Table: Year Name Type Jan Feb 2018 Kevin Salary 5000 2000 2018 Kevin Insurance 200 400 2018 Alex Salary 3000 4000 2018…
Kev
  • 3
  • 4
-1
votes
1 answer

Search returned value in another table excel

So I have this issue, I have two tables one is employees, and another one is the projects. Table Employees: Year Name Type Amount 2018 Kevin Salary 5000 2018 Kevin Insurance 200 2018 Alex Salary 3000 2018 Alex …
Kev
  • 3
  • 4
-1
votes
1 answer

Copy value of Excel cell relative to certain value

I have an excel file that contains a list of about 1500 names that have their zip code and I need a way to quickly insert the county relative to this zip. I have another list that contains the counties based on the ZIP. What is the quickest way to…
Garrett
  • 21
  • 3
-6
votes
1 answer

Update an Excel table with new values from another table

We have table A like this: Name Website Description Freelensia https://www.example.com "Interpreter reservation platform" フリレンシア https://www.example.com/ja "通訳予約プラットフォーム" "Phi Liên Á" https://www.example.com/vi "Nền tảng đặt hẹn với phiên dịch…
Freelensia
  • 402
  • 6
  • 18
1 2 3
…
21
22