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
209
questions
-1
votes
2
answers
27
views
Excel VBA - Loop through row and copy paste to another sheet if condition meet
I have 2 sheets - "Current" and "Email".
I want to have a script that reads that row by row on Column A - D.
If Column D = "", then Copy corresponding Column B value ...
-1
votes
0
answers
19
views
vba – Copying cells to another sheet when a condition is met with search function [closed]
I simply cannot solve this one, even if I customize similar codes from this web.
When I choose a value from my drop-down menu in cell G of the worksheet "Úkoly", I need to search for the ...
0
votes
0
answers
25
views
Calculations with the MS excel tool using the functions and formulas in a single cell
How do we calculate Coefficient C if R/W=0.64 and H/W=1.8? using functions in a single cell/step.
Detailed query:
If We have a table with some rows and columns, How do we calculate the respective ...
0
votes
0
answers
12
views
How to create multiple pivot tables with their own charts on the same sheet using a macro?
I am new to VBA so I apologize if this is a rookie mistake. I am attempting to create several pivot tables on the same sheet with each one having their own chart. The goal is to do this every month as ...
0
votes
0
answers
13
views
Unable to Export Data In Hindi (Unicode) Excel using PHP and MySqli
Unable to Export Data In Hindi (Unicode) Excel using PHP and MySqli
Below is the code im using to export data from the database & its working fine but when i try to export hindi entries excel ...
-2
votes
1
answer
45
views
Excel VBA code to Sum the debit up values when credit happen
I'm having excel sheet with debit transaction and Credit transaction in specific dates, I want VBA code to sum the previous debit transaction when Credit transaction occur and reconcile the amount if ...
0
votes
0
answers
12
views
how to create a dependent drop-down list linked to a multi selection source cell
I have dependent drop-down lists in sheet 1, P1 (the source cell) and Q1 (the dependent cell).
I used the following equation in data validation source for Q cell which worked great.
=INDIRECT(VLOOKUP(...
0
votes
1
answer
34
views
Excel Formula for Today's Month Being Greater Than Lookup Value Month & Provide Message
I have created a budget sheet in Excel to track Debt Snowball payments. I have a formula that successfully works to lookup the month from a list of months (column F) that a final payment is made for a ...
0
votes
0
answers
36
views
Running the VBA code gives me an "Invalid path or URL"
I have a snippet of VBA code that I've been working with where I want to press a button in Excel that will open an Outlook template. But for some reason, when I press the button, I get an error for &...
0
votes
1
answer
22
views
vba excel to read outlook and send pre scribed e mail based on subject line
excel says that it is not connected and shows me error on the line where "myInbox" is set to the outlook inbox. at first my studies led me to these references and ol commands. Then online ...
1
vote
0
answers
32
views
Values Are of Wrong Data Type in Formula in VBA Excel
I'm trying to multiply a variant array of coefficients by an independent variable stored in an excel sheet through a function in VBA to return the dependent value. The array has one integer in the ...
0
votes
0
answers
15
views
Using VBA to automate generation of multiple worddocs populated with data from excel sheet
I am using the following start to my VBA project, but when I run it I get a 1004 error and it highlights the below. The error seems to be the path, but I know not what the issue is.
Sub ...
0
votes
0
answers
9
views
Copying data from repeated cells in multiple excel files in a folder to a new file as a table not entering the loops
There's a few iterations/versions of code from StackOverflow that I have tried to copy certain repeated cells from multiple excel files in a folder into one new file. From adding MsgBox into different ...
-2
votes
2
answers
78
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
23
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 ...