Questions tagged [excel]
Only for questions on programming against Excel objects or files, or formula development. You may combine the Excel tag with VBA, VSTO, C#, VB.NET, PowerShell, OLE automation, and other programming related tags and questions if applicable. Do NOT use with other spreadsheet software like [google-sheets].
excel
288,357
questions
-2
votes
2
answers
82
views
Excel, while loop with variable loops
Good evening all,
I have a table in columns "A" and "B". It is known as a BOM (Bill of Material) and column "A" is the parent of column "B" the child. Some ...
-2
votes
0
answers
24
views
How to create a macro that updates a table?
I have a table called TablaEntradas in the Entradas tab where all the fields of the userform frmEntradas are stored.
I have another table called Salidas in the Salidas tab where all the fields of the ...
0
votes
1
answer
34
views
Insert a very long function using VBA
Heyo, I am trying to use VBA to insert a (very) long formula into a workpage. I keep getting an "Application defined/objeft defined" error.
Hoping there's either a way to make this work or ...
-2
votes
1
answer
17
views
Excel: Calculate Time Range in Days Between Two Dates if Specific Conditions are Met [closed]
I'm trying to calculate the # of days between orders from users. So, the formula needs to reference Column D to confirm the order was from the same email and if so, then calculate the days between the ...
0
votes
0
answers
27
views
Uploading file to ASP.NET Core Web API using VBA
I'm struggling to upload a CSV file from local drive to a Web API.
Sub Upload()
Dim objHTTP As New MSXML2.ServerXMLHTTP60
Dim url As String
Dim filename, resp As String
Dim boundary, ...
0
votes
1
answer
35
views
Get value from different excel sheets with criteria
i want to get value from another excel sheets based on some criteria. at first look at the picture.
here in the gray highlighted cell i want to get the value from other sheet and it'll be dynamic and ...
0
votes
1
answer
44
views
How to calculate times in variable cells [closed]
I am trying to create an Excel file that logs diver times. Specifically, I am logging their in/out times, total dive time, and surface intervals. If you're not a diver, the total dive time is the ...
-1
votes
0
answers
49
views
Cells gets only a zero
I wrote a function in Excel VBA and use
cells(x,y) to get the values.
The problem is the table cells I copied into the excel sheet will only be read as zero. But the cells I wrote the values in by ...
0
votes
1
answer
40
views
What excel formula can I use to compare 2 columns and pick the cell that does not have #n/a in it?
A
B
C
**1**
ID 1
ID 2
Expected Output
**2**
0011Q00001xC8a7QAC
#N/A
0011Q00001xC8a7QAC
**3**
0011Q00001xC8aTQAS
#N/A
0011Q00001xC8aTQAS
**4**
#N/A
0011Q00001xxxFFFQr
0011Q00001xxxFFFQr
**5**
#N/A
...
1
vote
0
answers
20
views
Active X Controls change position on worksheet despite being software-fixed [duplicate]
the position of my controls change after clicking on them, despite my attempt to fix position by the code below. Is there anything else I should do? Please help.
Private Sub CalculateMe_Click()
Dim ...
0
votes
1
answer
18
views
How to link a shape to a column so when the shape gets larger the column get larger too?
I want to do a database on Excel and in the first page there is a navigation menu on the left side working with macros for each tab to send the user to this exact tab. The code is the following and ...
0
votes
0
answers
30
views
VBA checkboxes being inserted differently after running code again
I am trying to insert user form checkboxes in column C of my excel file because i'll use logic in another macro to see if they are checked and write information to word based on that. This code worked ...
0
votes
4
answers
58
views
How to return number placement based on criteria from a table?
I've run into an issue that I can't quite figure out. I need to return the placement of a list of values based on a separate criteria.
I have a table that looks like this:
I'm looking for a way to ...
0
votes
0
answers
21
views
Getting extra null rows when I am trying read excel file with EPPlus OfficeOpenXml
I have an Excel file with 4 sheets. However, it is behaving incorrectly when I am reading the first sheet in my C# (.NET Core 3.1) code.
The sheet has around 350-450 entries, sometimes it reads only 4 ...
2
votes
3
answers
67
views
Workbook tab Color count loop
I need help with a loop to count all colored tabs in a workbook. I have 4 different colors, I would like to data to sum on the first tab of the workbook showing how many green, yellow...ect.
Public ...