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

Excel VBA 'On Error Resume Next' causing problems with renaming Table Headers

I want to loop through tables in a workbook and rename certain column headers in tables, to enable the Advanced Filter to copy data. Currently, I'm using On Error Resume Next to avoid Error messages when the column isn't found in the table, and then…
Simone Evans
  • 183
  • 2
  • 17
1
vote
0 answers

How can i export merged cells in table from excel to word 2016 using a macro?

I try to use this method to export a table from excel to word, however i cannot export correctly because the merged cells appears unmerged. But the problem is that the format does not include the merged cells, also i noticed that the customized…
Arroyo Danowsky
  • 11
  • 1
1
vote
1 answer

VBA Select Data in Table that meets criteria

I am trying to select cells in a table if another cell in the same table meets a certain condition, then copy the selected cells into a separate worksheet. I thought using an if then statement might workout best but Im sure there might be simpler…
Corey Bolling
  • 11
  • 2
1
vote
2 answers

EPPlus Table @ Column reference

I'm trying to use EPPlus to create a table on a worksheet. I can create the table, but all my @ variables become #Ref! when opening up the file. If I paste the exact same formula into Excel it takes it and has no problem. What am I missing here? Do…
Lee
  • 41
  • 4
1
vote
1 answer

Excel Table - Convert Range-Based Formula to Field-Based

I have inherited a very large spreadsheet and am trying to migrate it to a database. The table has over 300 columns, many of which reference other columns. By converting it to a table (ListObject) in Excel, I thought it would be easier to…
Hambone
  • 15,600
  • 8
  • 46
  • 69
1
vote
0 answers

Copy cell formula automatically while adding new row in excel table using apache POI

I have a simple table in excel which has a column serial no with formula =ROW()-ROW(Member_Data[[#Headers],[S. No.]]). Whenever I add new row to the table serial no is calculated automatically.when i added new row using Apache POI it didn't copied…
Niketan Mishra
  • 21
  • 3
1
vote
0 answers

Column doesnt exist in vlookup table error in APACHE POI

I have an Excel file with named excel tables for VLOOKUP in a sheet. I'm trying to get the VLOOKUP result in another sheet by referencing through the Gender_lookup table. I am using the formula =VLOOKUP(TRIM(CLEAN([@[Gender ]])),Gender_lookup,2,0)…
Niketan Mishra
  • 21
  • 3
1
vote
3 answers

How to check if Excel table cell has been edited by user?

What are options to monitor changes in an Excel table? Possible solution I can think of is to have a clone copy of the table, say in a hidden worksheet and a formula which compares both sheets. Is there any other way?
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
1
vote
1 answer

How to take data from one excel table and add it to matching rows in a different table?

I have two excel tables, Table A has 4 columns, Table B has 13. Each of the 4 columns in Table A can be found in Table B. They are composed of count data from censuses. During the censuses, people counted the species they encountered and gave a…
user3403745
  • 83
  • 1
  • 2
  • 7
1
vote
3 answers

VBA listobject won't add rows

I have a wb with several sheets, each having two tables (listobjects). I also have a userform that allows a user to add, edit, delete rows from the tables. These tables are static, ever meaning they are ever present and never deleted, they are…
Brad
  • 23
  • 5
1
vote
0 answers

Using Formulas in Re-arrenged tabels

I've taken on a small project for my finances, I've created a tabel with incomes, Expense and totals. (Example table with imaginary numbers - Seen Below) The profit column is calculated using this formula & is the Sum of the profits minus the Sum…
CptGoodar
  • 303
  • 2
  • 15
1
vote
0 answers

How to scrape tables from raster files (like .jpeg, .jpg, .png, .gif) and save in excel format?

I have been trying to extract a table from .jpg format to excel format. I'm aware how to do it if it's a .pdf or html file. Please find the script below. I would be grateful if someone could help me figure this out.…
Justin
  • 11
  • 2
1
vote
0 answers

How can I add options/values as drop downs to the header of my Excel Table using EP Plus?

My code creates an Excel file with columns chosen from the UI. Users use this Excel table (with only column names on the 1st row) as a template of a table and start filling details from the 2nd row onwards. On the back end I use these input to pass…
beginnerCSemployee
  • 21
  • 3
1
vote
1 answer

How recreate blank table automatically in Excel

So I'm just getting into Excel and I want to learn more about it so please bear with me. Currently I have a working timesheet that does what I want. Well, not everything...what I want to do is use it to keep a record of weeks and such. So my…
Excallypurr
  • 319
  • 1
  • 16
1
vote
2 answers

Formula To Paste Table In Seperate Worksheet In Excel

I have a table located on Sheet1 called Table2, I just need a way to paste it onto Sheet2 in a certain cell to prepare it for a CSV file. Is there a formula I can use in a cell to display my table in a different sheet? Table2 dynamically changes…
MSauce
  • 123
  • 2
  • 13
1 2 3
…
21 22