431 questions
2
votes
1
answer
36
views
Move entire rows when PowerQuery data change
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
...
- 47
1
vote
1
answer
71
views
Run VBA on multiple worksheets and sort data in table by color
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 ...
- 13
0
votes
2
answers
146
views
How to make Excel VBA code faster for over 1000 rows [closed]
I am very inexperienced with VBA coding, so I would be very grateful for your help. I want to write code to format an Excel spreadsheet. I have the following code so far; it works quickly for sheets ...
1
vote
1
answer
62
views
Can MS Excel preserve a reference to a cell in a table that gets sorted/filtered?
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 ...
- 13
0
votes
2
answers
55
views
Can Excel 2007 filter one table into another dynamically?
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. ...
- 11
2
votes
3
answers
120
views
VBA Code using Xlookup with a table won't compile
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 ...
- 55
1
vote
4
answers
88
views
How to compare two tables with several columns and add a blank row if they don't match in either table [closed]
Both tables are on same tab.
I have the 1st table with columns as follows:
A
B
C
D
E
F
G
H
J
K
101
DK
not
1
dep
4
an
fam
8
Trip
102
cj
part
2
pre
7
bn
trp
9
DIGT
105
YJ
dio
5
pot
8
vn
rty
4
PRO
109
YJ
...
- 375
1
vote
2
answers
181
views
How to create an excel formula using LET and other dynamic array functions which gives an calculated output of each column?
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 ...
- 67
0
votes
1
answer
119
views
How to return specific column values based on cell value
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 ...
- 1
1
vote
4
answers
247
views
Using Excel VBA, how can i extract data from a named table and manipulate the data without changing the data in the original table?
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 ...
- 35
0
votes
0
answers
37
views
Combination of Excel Table and Conditional Formatting is Slow
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 ...
- 58
0
votes
0
answers
67
views
Macro to hide/unhide columns in Excel Table is very slow after a data refresh
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 ...
- 11
1
vote
2
answers
113
views
Excel TEXTJOIN of non empty rows in a table
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 ...
- 167
0
votes
1
answer
101
views
Excel VBA - Table removed by copy/paste values or range.value = range.value
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 ...
- 1
0
votes
1
answer
60
views
EXCEL - table to list for mail merge
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
...
