289,618 questions
2
votes
3
answers
100
views
Skip invalid inputs when finding Min and Max values
I'm working on a VBA problem to find the maximum and minimum values in a sequence while skipping invalid inputs.
The issue I'm facing is that when the first value in the sequence is invalid, the ...
- 21
2
votes
1
answer
106
views
VBA is not creating text file for output
I am writing a VBA code in an Excel spreadsheet. The code tested OK and now it's time to output the results to an ASCII (text) file - as this has been the very intent of the code since the very ...
-1
votes
1
answer
85
views
Creating a new folder in Sharepoint using VBA for Excel [closed]
I am trying to create a folder at https:\\myorg.sharepoint.com\sites\CASH ORDER\Testing using...
MkDir "//myorg.sharepoint.com/sites/CASH ORDER/Testing"
...but I keep getting a run-time ...
Advice
0
votes
3
replies
90
views
When a user selects all cells and resizes a column, all hidden columns are redisplayed - How can I detect that and rehide the unhidden columns
User selects all cells via Ctrl+A or clicking in the box above the Row numbers and to the left of the Column letters
With all cells selected, if they auto resize any column
a. All hidden columns are ...
- 1,165
-1
votes
3
answers
143
views
How do I bold every other name in repeating rows in a single column in Excel? [closed]
In column A, I have a list of names.
The names repeat sometimes, depends on the data.
.
I want to format the list by bolding every other name.
Is there a way to automate this bold formatting?
The ...
1
vote
1
answer
95
views
My "MoveRowsTo" Module is only moving to one row
Basically I have a task list, and once the tab is labeled as "closed" in column G of the "Open Items" Sheet, It needs to move to the "Closed Items" sheet.
The function ...
Tooling
0
votes
0
replies
88
views
Machine learning to manage Excel files
I would like to train a model to understand if an Excel file has the expected structure. I can put a list of right files in a folder and a list of wrong ones in another. Any help and suggestion are ...
- 21
3
votes
0
answers
164
views
How to Correct Shape Offsets When Drawing a Bullseye Target in Excel Using VBA
I’m building a bullseye target chart in Excel using VBA macros. Each ring represents a performance range based on an array of percentage values.
The sizing and labeling are working fine, but I’m ...
0
votes
0
answers
62
views
Why does setting values from a column make array 2d? [duplicate]
I have this code that takes the values from row 1-8 in the 3rd column and sets them to an array and for some reason, it's making it into a 2D array.
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets(&...
4
votes
0
answers
136
views
How to read mixed data (numbers and strings) from Excel with xlwings without converting 123 → 123.0
I’m using xlwings to read an Excel sheet into a pandas DataFrame with the built-in pd.DataFrame converter.
Some of my columns contain mixed data (e.g. IDs or codes like 123, 00123, ABCD).
When I read ...
- 49
-1
votes
1
answer
50
views
Matlab script to write to Excel file, have excel calculate, and read output in a for loop
I am trying to build a Matlab script to write data to an Excel file, have the excel file execute, and pull out another cell as the output. I asked an AI engine to give me a script and it came up with ...
- 17
1
vote
1
answer
144
views
Is there a way to write a previously read and updated DataSet back to Excel? [duplicate]
The idea is simple and no matter how much I have searched I couldn't find any similar example.
Using the OleDbDataAdapter class, I am able to achieve the first step:
Read a specific range in a ...
- 79
0
votes
1
answer
76
views
In powerquery I need to control if a merge happens based on a condition
I need to accomplish two things.
I am trying to generate a folder tree. I have to find a target folder. Starting at the root folder, I am merging a list of objects based on OBJECT_ID = PARENT_ID. This ...
0
votes
2
answers
100
views
Weighted percentages
I have a problem on how to calculate "partial" percentages that match the "total" percentage.
My problem is as in the table below.
I have values for the beginning and end of the ...
- 391
1
vote
2
answers
54
views
In Excel Power Query, can I return a specific table if the data is empty, but return the data if it exists?
I'm using Excel to create a fire weather product for a specific National Forest. One of the tables reported includes National Fire Danger Rating System (NFDRS) indices and weather observations from ...
Advice
1
vote
4
replies
100
views
How to make a js dropdown with description like Microsoft Excel
How can you recreate with javascript a dropdown with a side "tooltip" description like Microsoft Excel does? What I'm trying to obtain is this:
Is there a library already that could handle ...
0
votes
0
answers
106
views
Office JS displayDialogAsync Error : TypeError TypeError: Cannot read properties of undefined (reading 'register')
I'm developing a webAddin on Excel and I'm having an issue, I have a taskpane that opens from the button in the ribbon, but I wanted to change to a Display, I have this code in the commands.js
...
0
votes
1
answer
115
views
Creating an Excel spreadsheet that includes quantities of item from one sheet when box is checked on another sheet? [closed]
Okay, this is going to be a bit long, sorry!
In general terms, I'm looking to create a spreadsheet that adds up the total quantities of things from multiple different sheets in the same workbook, but ...
0
votes
5
answers
135
views
Finding Max Value and Returning Horizontal Array belonging to the Max Value
I attempted to use a mixture of filter/index/xlookup with multiple criteria.
I am given 4 rows of data (Option 1-4) for 3 different groups (A-C). I need to compare the max V1 value for each group for ...
- 39
1
vote
0
answers
129
views
How to set ListObject (Excel table) formulas with structured references without error 1004
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.
...
1
vote
0
answers
73
views
Excel UI thread freezes on async function invocation
I am kind of confused, I was following the "Excel 2013 SDK" documentation, and bein interested in User defined Asynchronous functions. Here is my simplest example, it doesn't even do ...
- 1,667
1
vote
1
answer
110
views
Load XML into Excel (on a Mac & with Stylesheet)
I'm trying to import an XML file into Excel using the Workbooks.OpenXML
to load data through VBA. Two questions:
Can this method be called by Excel for Mac?
The second argument is an XSL stylesheet. ...
- 11
0
votes
2
answers
126
views
Excel VBA code for finding Cell header name
I am using the code below. It works the way I want it to, but when I introduce a variable into the range statement it works in some instances and not in others. What have I missed? If I substitute ...
0
votes
3
answers
138
views
Power Query Unqiue Row Formatting With Sum
Trying to figure out if this is even possible as LLMs have failed to answer this question.
I have a report from our companie's ERP that exports as a CSV. This is a basic inventory report that looks ...
- 47
0
votes
1
answer
61
views
Fabric Dataflow Gen2 not showing all columns of an excel sheet because of the dimension property in the xml
I am working on a new Dataflow Gen 2 to import Excel files from SharePoint.
The problem I am running into is our vendor, who is supplying the files, is not properly setting the worksheet dimension ...
- 1,011
-1
votes
0
answers
69
views
Exception when calling C++/CLI Methods with arguments ByVal from 64 bit Excel
I'm trying to make a C++/CLI dll to wrap a managed assembly so it can be called from VBA inside Excel (I specifically want to avoid using COM). It shall only support 64 bit.
I have based my test code ...
0
votes
0
answers
37
views
How can I automatically export multiple Excel sheets into separate CSV files using Python? [duplicate]
I’m trying to automate a report generation task using Python.
I have an Excel workbook that contains multiple sheets (e.g., "Sales", "Orders", "Summary"),
and I want to ...
4
votes
0
answers
188
views
Excel VBA - strange run-time error 6: Overflow
[M2 MacBook Air, macOS Sequoia 15.6.1 (24G90), Microsoft Excel for Mac Office 365 Version 16.102.1 (25101829)]
In a new .xlsm workbook, with Personal.xlsb removed and no plug-ins enabled (i.e. fresh ...
- 91
1
vote
1
answer
89
views
Power Query - Error Convert Null to Number at Merge
I have a tool I created that simplifies and combines some Sharepoint files with basic tables with a SQL database query and I've been using it for about a year. Suddenly, it's not working and throwing ...
- 23
0
votes
0
answers
41
views
make Excel “Sign in with Organizational Account” work with Spring Boot API and Azure AD
I’m developing a Spring Boot API that serves data to Excel via the “Export to Excel” feature. I want Excel to authenticate with Azure AD before calling my API.
I’ve implemented a custom ...
2
votes
1
answer
110
views
For Each X in Y, starting at Z?
In VBA, is there a way to use a For Each loop, but starting at some determined place?
For example, I have a script I call from Excel that loops through slides in PowerPoint, but starting at slide 60, ...
- 23.5k
0
votes
3
answers
139
views
Array Functions
I am currently learning the new array functions in Excel. I've been learning them for a bit, but still learning.
I am trying to create a dynamic YTD type report off some dummy data however I can't ...
- 8,576
0
votes
0
answers
32
views
Extract Multiple values from a column with criteria in excel [duplicate]
I have an excel data with 9 columns. I would like to extract multiple values from a column with criteria base.
for example my file look like this:
enter image description here
expecting output...
...
- 1
0
votes
3
answers
130
views
Workaround for #spill! in Excel when creating random integer array of random size (with constraints)?
How to construct a random size, random integer array with (exact) target sum value with a single Excel function (or 'best' viable/working solution given the 'known' volatile issue with this sort of ...
- 2,589
-1
votes
2
answers
137
views
I want to add a minimum run time for an Excel engine simulation
I'm new to stackoverflow and was looking for some help.
I'm building an Excel formula (using LET) to enforce a minimum run length for a CHP engine. The logic is:
If today's suggested load (row 8) >...
0
votes
1
answer
116
views
Shift cells from right to left side
For automation purposes, I want to reflect the cells from right side to left side from the active cell.
Example: In H2 cell ={"A","B","C"}. This result will spill in H2, ...
- 491
1
vote
1
answer
125
views
Cannot set up multiple worksheet events that all target the same column
I found a great video for VBA to work with timestamps for a poker spreadsheet I'm creating.
The VBA works great. But I need to track mixed games. We may play several out of our 20+ games.
I want just ...
- 1,015
0
votes
2
answers
165
views
Tracking elapsed time for a task in Excel — resume timing after status changes (formula or VBA)
I have an Excel sheet used to measure the time spent on individual tasks. The sheet has these columns:
Task
Start Date (timestamp when the task was first started)
Status (data validation with three ...
- 17
3
votes
0
answers
69
views
Open an Excel file save in Sharepoint environment in desktop app using Power automate
In my line of work, I have to use an add-on to Excel in order to extract data from multiple instruments. I'm a chemical engineer in a chemical plant, so think thousands and thousands of inputs, all ...
- 31
2
votes
1
answer
236
views
How do we remake program. The program return error overflow error 6
How do we remake this program?
File input.xlsm result.xlsm is larger than 600 000 records.
Sub Insertdata()
' Define constants.
Const SRC_FILE_PATH As String = _
"\\s-fa\...
1
vote
2
answers
146
views
Update entire sheet any time there is a change
I have a macro that depending on the number of X's and N/A's in certain columns changes the color of that row, telling me that it is either ready or still waiting on something.
Other logic checks ...
- 95
4
votes
1
answer
113
views
How to convert Excel file with multiple header and sub header to Nested Json as show
i have tried to convert the excel file data as shown in the picture from excel to Json format but not able to properly convert to the structure that i required, the structure I required is as below
{
...
- 760
1
vote
2
answers
101
views
Update Excel formulas between a path in local folder and owncloud in another computer
I have a lot of Excel archives with lots of formulas which reference other Excel files, all in the path H:\Fold\Data\physics on a computer, and at the same time, on another computer, I have an ...
- 19
0
votes
4
answers
143
views
MakeArray to dynamically Offset rows by a factor on the source row
I have a table of invoice which we have monthly amounts we expect to bill. We also have a factor on how long many months we expect to actually collect per invoice.
What I am attempting to do is take ...
- 2,866
1
vote
1
answer
97
views
Excel adding rows in a table when sheet is protected
I want to be alble to add rows to a table in protected sheet but I cannot get it to work.
In have named table (range) of which all the cells of that table are unlocked. (Selected the whole table, ...
- 665
0
votes
2
answers
121
views
Worksheet_SelectionChange Causes Clip Board to Clear
I have the code below - Essentially, if the user inputs a 1, 2, or 3 in cell N16, different sheets will show and hide themselves. This all works fine except that the clipboard gets cleared when any ...
0
votes
2
answers
93
views
VBA Runtime Error 9 When Copying Sheets From One Workbook to Another [closed]
I'm trying to run some relatively simple code to copy sheets from one workbook to another
ref_sheet = "111"
temp_path = "K:....xlsx"
main_book = "K:....xlsm"
Set ...
- 99
3
votes
2
answers
142
views
How to calculate Adjustment amount with conditions
I have a table as below:
Branch Code
Target
Actual Profit
Adjustment 1
Adjusment 2
Adjusted Profit
Progress Rate
Completion Rate
(A)
(B)
(C)
(D)
(E) = B + C + D
(F)
(G) = ((E - C)/F+C)/A
100
8,031.00
...
- 1,793
0
votes
2
answers
78
views
Compare two Excel sheets by SKU, Price, and Date Ranges — highlight mismatches
Sheet 1: sell_in
Column
Name
Example
A
SKU
12345
B
Price
59990
C
Start Date
01-09-2024
D
End Date
30-09-2024
Sheet 2: oficial_prices
Column
Name
Example
A
SKU
12345
B
Price
59990
C
Start Date
01-09-...
1
vote
2
answers
80
views
Calculated Field - Subtract two percentages for Percent Point Difference?
I am simply trying to add a calculated field to a pivot table, that subtracts two percentages. I'm trying to get the percent point difference between a "Name" average and "State" ...
- 23.5k