Questions tagged [excel]

0 votes
1 replies
Loop Through Files - File not found
So, I have this code that I found here: https://stackoverflow.com/a/10382861 And when I first found it, I modified it to actually open the files...
asked 4 months ago
0 votes
1 replies
How to determine the length of a particular array
Determine the length of a particular array. Have tried several variations of Value but no joy. Within a macro I've tried: Range("BB4").Select...
asked 4 months ago
0 votes
0 replies
Corrupt XLSX file after download via axios
I try to create an XLSX file in a Vue application with axios. I do this: First I send a post call to the backend controller: return axios({...
asked 4 months ago
0 votes
1 replies
Paste array to certain rows and column within table
I wrote a function to write the contents of a 2-dimensional array to an existing table. Nothing will be removed from the table. The new rows must...
asked 4 months ago
1 votes
1 replies
Transfer Access Code into Oracle Syntax (Power Query)
I am just woorking on to transfer a Access Query into Power Query (Excel). I think there are some challenges regarding the terms/ wording. Its a...
asked 4 months ago
-1 votes
1 replies
Generate passwords
I need generate passwords that do not repeat and do not have the same consecutive number, in addition to having a length of 8 digits, only number...
asked 4 months ago
-1 votes
0 replies
Is there a way to use vba and solver to recalculate an iterative worksheet (circular references) to reach target values for 10 dependent variables?
I have a worksheet with a series of iterative calculations that produce ten component variables whose sum needs to match a target demand at a fut...
asked 4 months ago
-2 votes
2 replies
Is there a way to group by multiple criteria and then count data in excel?
Pickup Received BUILDING ROOM 7/12/2018 50 0G39 7/12/2018 50 0G39 9/13/2018 101 0275B 9/13/2018 101...
asked 4 months ago
1 votes
1 replies
How to modify bullets using an Excel macro?
Quick question: How do you format the actual bullet point itself? The bullet points all still appear as stars instead of a normal black circle...
asked 4 months ago
-1 votes
0 replies
how can we retrieve non contiguous cells from three workbooks and display it in main workbooks
I have a master workbook that display a monthly Absences for shift employees. The workbook have four fields:Date(cell:A1),Total Rostered(cell:B1)...
asked 4 months ago
1 votes
1 replies
Filter 1 column and return all associated records in a different column
I have a spreadsheet with 18 columns....column 15 (o) is a list of accessories and column 5 (e) is the serial number tied to the accessory. I am...
asked 4 months ago
0 votes
1 replies
How to avoid distinct records from database while inserting data using asp.net?
I'm building a program that imports data from an Excel file into a database, or by writing into textboxes (by an insert in asp.net) or both, but...
asked 4 months ago
0 votes
0 replies
SumIfs Formula Issue
I have a monthly spreadsheet that has a link taking you to another spreadsheet with totals, could be one total by vendor, could be several accord...
asked 4 months ago
1 votes
2 replies
Storing the first value in a sequence and use the stored values where the condition meets
I have this table and the VBA code has to fetch Value from Product where the Primary value is Yes. But, Value has to be the First Value in the Se...
asked 4 months ago
-1 votes
0 replies
Uploading excel(xlsx) file in a web application that analyses its data and exports other data in a different xlsx file
So i am trying to make a web application that does what the title says. The problem is i dont know exactly how to move on. I am thinking using pa...
0 votes
0 replies
how to add a formula to each cell in a column if another column has a value
i have two dates. column G has start date and column H has end date. Column P has the amount of days between the two dates."Formula in Vba". the...
asked 4 months ago
0 votes
2 replies
Worksheet Event Not Firing
My basic worksheet event code is not working. I have the following code included in my Sheet4 workbook (where I want it to run): Private Sub Wo...
asked 4 months ago
0 votes
0 replies
How to insert a countif column on each row of the table?
Basically I have a table with lots of rows, this column is called "source_id" and "time spent", in the column "source_id" I have repeated items t...
asked 4 months ago
0 votes
1 replies
compilation error, Sub or Function not defined
Currently realising a project for my company to highlight anomalies in orders, I wrote this VBA code in order to compare status of orders and a d...
asked 4 months ago
1 votes
1 replies
Populate Combobox with Two Text Fields from an Array
I'm trying to get values from 2 cells in an array to populate the text field of a combobox on a userform. The values in the array look like this:...
asked 4 months ago
0 votes
1 replies
How do I set the value of a do while inner loop, nested in a for loop?
I have a report that downloads from a client's SharePoint. The report varies in length depending on the site and time range I am running it for....
asked 4 months ago
0 votes
0 replies
How to create a graph that will not display ending zero values
I am trying to create a simple line chart in excel whose data is based on a dynamic range. The reason the range is dynamic is because I would lik...
0 votes
0 replies
Trying to hide rows that are not filled in and have values in them, can do the opposite but stumped
I have a vba macro that hides an entire row if there is a "1" and an highlighted cells. But I'm trying to do the opposite. Hide rows that have a...
asked 4 months ago
0 votes
1 replies
Can't Ctrl+Z (undo) with ComboBox referring to dynamic list with named range, rename to array? How?
I have a ComboBox whose list refers to a named range that creates a dynamic list based on the matches with the linked text to the ComboBox (linke...
asked 4 months ago
0 votes
1 replies
Using worksheet function countif for filtered cells
I am using the code below to loop through a filtered column and collect each name of sales person as it loops through; I am using the SpecialCell...
asked 4 months ago