Skip to main content
427 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
0 answers
174 views

I’m trying to insert formulas programmatically into an Excel table (ListObject) using VBA. The formulas use structured references (e.g. [@ID], Table_Lookup[Column]) rather than standard A1 ranges. ...
SANTIAGO MIGUEL CASTRO GARCIA's user avatar
  • 11
2 votes
1 answer
112 views

I'm working on a file with two different tables on two different Queries, with this structure: Table 1 GROUP MEMBER ID GROUP SCORE 1 SCORE 2 SCORE 3 Member 1 01 A1 1 1 4 Member 2 02 A1 3 3 5 Member 3 ...
MrBoop's user avatar
  • 57
1 vote
1 answer
85 views

I know how to record and edit to clean it up, but this action is a bit more complicated. I've pieced the code below from A LOT of different sources. When I record it, it works on the one sheet but I ...
user30798065's user avatar
  • 13
1 vote
1 answer
86 views

If you have a table in Excel and have a reference somewhere to a cell in that table – let's say A7, and you insert a new row above so A7 will become A8, any reference to that cell gets updated so it ...
Jeppe Bech's user avatar
  • 13
0 votes
2 answers
73 views

I'm trying to create one, "master" table of information, and have some pre-defined filtered versions of that table available in separate sheets (of the same workbook) for easier printing. ...
purplecho's user avatar
  • 11
2 votes
3 answers
148 views

Good evening, all, I'm trying shorten names in a column by parsing the names and doing lookups on each word to return a possible abbreviation. I was doing a loop through each row (~200 words) to find ...
R C's user avatar
  • 65
1 vote
2 answers
210 views

I have a table like this which stores marks of students in different subjects Name Class ID Math English Hindi Tony 5 1 39 30 30 Andrew 5 2 40 20 20 Mark 5 3 40 10 30 and a tabel like this which sets ...
Daniel's user avatar
  • 67
0 votes
1 answer
329 views

I am trying to create a formula that will return the employee names and ID's based on the Skill Name in cell A1 if the employee has a "Y" under that Skill Name. I have tried variations of ...
Ryan T's user avatar
  • 1
1 vote
4 answers
367 views

In Excel VBA, I am trying to extract a unique list of values from a column in an named table. I want to store the unique list of values in a variable that I can then use for further processing. I am ...
akinoali88's user avatar
  • 35
0 votes
0 answers
49 views

An Excel Table of moderate size with some Conditional Formatting is slow in Excel 2016. The table has 16 columns, 20 body rows, and a Total row. Adding a new row at the bottom (marking the entire ...
pps's user avatar
  • 58
0 votes
0 answers
89 views

I have a large Excel workbook that imports data from some local SQL servers via Power Query and performs a bunch of calculations on the imported data in an Excel Table. Because the table containing ...
Johnny Cash's user avatar
  • 11
1 vote
2 answers
133 views

I have a table named "Table1" and a column named "Details". I would like help with joining the text in column Details into one cell with a linebreak separator - CHAR(10), I would ...
Kobe2424's user avatar
  • 169
0 votes
1 answer
144 views

I'm trying to copy over a whole sheet of inputs to a spreadsheet. The problem comes because on the target sheet there are a number of tables, which I need to remain tables. When I copy / paste ...
Sicrates's user avatar
  • 1
0 votes
1 answer
70 views

I'm helping a group update a competition score sheet and need help converting a table with gaps to a list. Before Example Number Name address 1 2 3 4 5 1 david xxdavid apples potatos 2 helen xxhelen ...
adjectivedave's user avatar
  • 41
1 vote
1 answer
86 views

I have to imagine the answer is somewhere but I am not sure where. Here is the situation: I have a 6-column array of numbers starting from zero, and they increment sequentially, but not in every cell,...
Mark Yorsaner's user avatar
  • 13
0 votes
1 answer
48 views

Having a known Y value and a Known (x,y) value, find Y value in a table. Essentially, I have a table with (x) values along A:A and (y) values along 1:1 with the corresponding (x,y) values within the ...
Evan Flury's user avatar
  • 1
0 votes
1 answer
48 views

I have one excel file that retrieves a list of transactions from another excel file. Source = Excel.Workbook(File.Contents("D:\Documents\Dashboard.xlsm"), null, true), T_TRANSACTIONS_Table = ...
Quercus47's user avatar
  • 3
0 votes
1 answer
103 views

If I create an Excel table object with Powershell and use it to insert a row into the table like $Table.ListRows.Add() It formats the new row like the row above it. If the row above has been filled ...
Roman's user avatar
  • 551
1 vote
2 answers
134 views

I am trying to insert a new row into an Excel sheet. I open a file with Powershell, get an object for the sheet, and then get a range object like $Range=$Sheet.Range("A1") $Range.Insert() ...
Roman's user avatar
  • 551
1 vote
1 answer
119 views

I am struggling with a data validation using tables in Excel. I have two tables, one for "category" that has a list of categories, and a second table for 'types' that has a column / field '...
The Frog's user avatar
  • 95
0 votes
1 answer
487 views

EXCEL: I have a table in the cell range A2 to G4. I want to find a value that can be in any cell in the range A2 to F4 and display the corresponding value in column G. I've tried creating forums with ...
nosperov's user avatar
  • 41
0 votes
2 answers
80 views

I'm creating a template for work, and I need to be able to insert a variable range from an input table which sits in "Inputs" into a form sheet, which sits in "Form". The input ...
user23370984's user avatar
  • 11
0 votes
1 answer
464 views

I am doing a survey on Microsoft Forms and the responses are coming through as one string in one cell; as follows: Product1;Product2;Product3;Product4,... Is there an way in excel to split these ...
Luke Robins's user avatar
  • 11
1 vote
1 answer
105 views

I want to filter a table range where Generate = "x" and copy range, non-contiguous column header and down, and paste into a new workbook and save. Sub ExportNewReps() ' ' CurrentFile = &...
Dj.cho's user avatar
  • 15
1 vote
1 answer
75 views

I have and excel where in a sheet there is a table with information, in another sheet I want to create a form that could allow me to add new information to that table Here is an example of more of ...
Emilio's user avatar
  • 11
2 votes
1 answer
89 views

I want to use VBA to create a table for import to our ERP system. Desired state: I press a button on Sheet2, the VBA code iterates through each row of a power query table on Sheet1, then paste each ...
LT_AKR's user avatar
  • 81
3 votes
1 answer
455 views

I've got a spreadsheet with some formulas in a table that would be clearer if I could use the Column Header name instead of the column letter. Can't figure out how. Using the Implicit Intersection ...
evanmars's user avatar
  • 61
0 votes
0 answers
61 views

I'm making a macro to take the date from a table to another one on the same workbook, but for some reason when it does it the values are multiplied like in the image. The multiplications aren't ...
Enzo's user avatar
  • 1
1 vote
2 answers
89 views

This following code works, but it needs to be simplified so that the table columns are deleted with one line of code if possible. The columns are noncontiguous and are downloaded straight from a ...
Austin Weiss's user avatar
  • 25
0 votes
0 answers
61 views

I've created a Excel Userform that contains a listbox linked to a named table. I want to be able to select an item within the list box then edit the data in the linked name table. Sheet Name is "...
user3599946's user avatar
  • 31
1 vote
1 answer
112 views

I have a source list in a dynamic excel table. The column of the source list that I want to reference for data validation has 3 cells populated but there are a few extra cells below the last populated ...
Charles Osueke's user avatar
  • 11
0 votes
1 answer
71 views

I have a table which I insert rows to with this code: Sub Invoice_InsertProduct() If Sheet1.Range("Z6").Value = "" Then MsgBox "Selecciona producto" Sheet1.Range(&...
Sheila Hurtado's user avatar
  • 3
1 vote
2 answers
150 views

I want to have a table filter and remove the items that are not needed. However, when I try to filter the four items that need to be removed, I receive the following error message - Compile error: ...
ZulT's user avatar
  • 11
1 vote
3 answers
405 views

I'm currently working on a project in which the user needs to add new rows into a table and each column value has to have a definded default state. This was quite simple using an ActiveX button that ...
Emanuel Zúñiga's user avatar
  • 11
0 votes
0 answers
58 views

could you give me a hint how to link one table to the other table so that the second table is an aggregated version of the first table (e.g. filtered In Scope) and the second table is followed by ...
Muhammed Kilicaslan's user avatar
  • 1
0 votes
1 answer
189 views

While generating a table via CSV import, I noticed that Excel added to some table names an ending underscore: e.g. abc12.csv became Table abc12_. This does not seem to be consistent with official ...
DataBunny's user avatar
  • 185
0 votes
1 answer
97 views

I have a table in Power Query that I'm trying to rearrange. The original table looks like this: I want to rearrange it to look like: I would appreciate any help in solving this issue. Thanks in ...
Sara's user avatar
  • 13
0 votes
1 answer
298 views

i have a problema whit a formula to get the reference of the first and last row of a table. i have create a table named "Income" that table start at row 10 and end at row 12 in a cell i use ...
Epilol's user avatar
  • 130
1 vote
2 answers
112 views

I have a piece of code that does exactly as I want it to do. Whenever a cell is updated in the column "Contacts 1 Made?" it inputs the date and time into the 2 columns to the right. I want ...
Peter Mogford's user avatar
  • 496
0 votes
1 answer
71 views

I'm trying to add a name to the active workbook using VBA in Excel 365. In the active workbook, I have already created a table named TestTable. It has two columns, the first of which is named One. If ...
Rich Holton's user avatar
  • 692
1 vote
1 answer
283 views

In Excel, even if you create a 'table' and add rows to this table, other cells will not be affected. I would like to implement this feature in Google Sheets, but I couldn't find a table. If there is ...
bsjy's user avatar
  • 25
1 vote
1 answer
217 views

I have a task list table in Excel. I'm trying to create a VBA macro for sorting the assigned tasks automatically. When the macro is run I want it to check whether each row contains a name in the '...
Chris Cannell's user avatar
  • 11
0 votes
1 answer
266 views

I have 2 tables, one is "RSO" and the other is "ESP". In the column ADD of the table ESP a need to write a SUMIF function to sum the RESULT column if the RANGE column matches the ...
José Angel Bernal's user avatar
  • 61
0 votes
2 answers
464 views

I have a Table1 (memberslist) with a column birthdays and i want to count how many members are older than 18. cell P2 has a date 1/1/2023 =COUNTIFS(Table1[Birthday];(YEAR(P2)-YEAR(Table1[@Birthday]))&...
eldje's user avatar
  • 41
1 vote
1 answer
4k views

I'm trying to run a macro that will pull data from a Table in Excel, when the Table might initially be filtered. The code should: Clear the Table filter Apply a filter to the Column Heading: "...
CDay's user avatar
  • 111
1 vote
2 answers
188 views

The code below is meant to import data from a defined table in another workbook to process in this workbook, after which it will clear the contents of the table in the source workbook. It gives me the ...
GreyGhost's user avatar
  • 13
0 votes
0 answers
598 views

I have a table where the highlighted cells contain formulas in which I do not want anyone to be able to edit: The reason I have built a table is so that once I enter new data on the forth row for ...
Lil H's user avatar
  • 1
4 votes
3 answers
331 views

I'm looking to perform a rolling sum for an excel table based on the value of a column. I want the sum only up to the current row (not sum of all rows that have the same value) I've made a simple ...
Karan's user avatar
  • 45
1 vote
0 answers
66 views

I have created different tabs/ sheets in excel each with a table. Each table has the same headers and has one column using the same drop-down list. I want to summarise all tables into a single table ...
Supasyl's user avatar
  • 11
0 votes
1 answer
290 views

I have a table in excel set up like so: Procedure Visit 1 Visit 2 Visit 3 Visit 4 Arm X Z X Brain X Y X Chest Z Z Eye X Y X Z I want to get be able to select information like so that I can filter to ...
Mikayla Baer's user avatar
  • 49

1
2 3 4 5
…
9