Questions tagged [excel]

Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.

Filter by
Sorted by
Tagged with
0 votes
0 answers
100 views

userform with textboxes and dates to show timeline

I am writing the following VBA code to make a timeline, which I will be using for other parts of the code later on for other calculations and output. I have a userform where the following number of ...
Barbarian's user avatar
2 votes
1 answer
82 views

double click on userform running slow excel vba

I have this code for picking items with multiple values from userform and inserting them into a sheet. The code works perfect on my computer, which is pretty decent. But on a computer from work it ...
Santos Lee's user avatar
0 votes
2 answers
112 views

Optimize a Python code which indicates duplicated values in an excel file [closed]

I wrote this code to indicate duplicated values. It actually works but I hope to know if there's another possible solution to optimize this process. Thanks. ...
peternish's user avatar
1 vote
0 answers
77 views

Import large Excel files directly from XML streams into an SQLite database

I've got some pretty large Excel files with nearly 1M rows that are almost impossible to open and work with in Excel anymore that I'm migrating into a database. Desipte this these files will stick ...
t3chb0t's user avatar
  • 44.2k
3 votes
0 answers
269 views

A vehicle database in Excel

I'm looking for some help. I'm new to coding and have started creating this Vehicle database program in Excel for a friend to use. He is wanting to be able to see all vehicles he owns, when ...
Kendall Briggs's user avatar
1 vote
1 answer
93 views

Using Pandas to group data based on name and see if column value is greater than or equal to values based on group names

As you'll see from the below code, I'm creating separate data frames of a much larger data frame, then updating a column for each one. What I'm doing is looking at the second column and checking to ...
jp207's user avatar
  • 173
4 votes
2 answers
97 views

an algorithm that chooses the best games on steam

The code below will go through an excel spread sheet taken from kaggle, is named "SteamGames (71k games)" and the creator is "MEXWELL". inside the ...
Ellie's user avatar
  • 497
0 votes
0 answers
55 views

Extracting a substring based on a pattern

As part of a project to pull data from our purchasing system (Sage) back into our quoting system (an Excel template) to automate variations to existing quotes, I wanted to grab the original quote ...
Andi Allan's user avatar
2 votes
1 answer
116 views

One way Synchronize 2 Access Tables with VBA ADODB

I am synchronizing two MS-Access databases. One of them on a network drive, the other one on the local machine. (For testing purposes both in the same directory) The Databases both contain a table ...
MZiegaus's user avatar
1 vote
1 answer
122 views

Loop through cells of a range and convert to a hyperlink and change (Text To Display) to an ascending number per each row

I have used the below code Loop through cells of a range and convert to a hyperlink and change (Text To Display) to an ascending number per each row. it works, but for the point of ascending number I ...
Peace's user avatar
  • 113
4 votes
2 answers
593 views

Efficiently creating an array from a filtered sheet

[edit] I realised why everyone does this with loops; my plan was to use .SpecialCells(xlCellTypeVisible).EntireRow.Address to return the row(s) of the results of the results of the filter, but that ...
Andi Allan's user avatar
0 votes
0 answers
51 views

Speeding up VBA to add/remove Pivot Tables from Slicers in Excel

I have a workbook that has a number of Pivot Tables spread across a number of worksheets. There's a bunch of slicers on one of the worksheets, and they're pretty slow-ish to load after changing ...
bigsim's user avatar
  • 1
1 vote
1 answer
427 views

Python script to read an XML file and write some information to an Excel file

I'm getting an XML file from an application, want to extract some information from that file and write it to an Excel file. The XML file contains data about vacations. I need data from the last month ...
Jens Kubieziel's user avatar
1 vote
0 answers
62 views

Appending data from files listed in a file

I am working on a project that requires me to write VBA code which, upon a button press, loads the data from certain files in a given directory. In my testing, I was able to load the data from 1100 ...
Leon-Josip Dzojic's user avatar
5 votes
2 answers
130 views

concatenate values and delete the remaining rows using arrays

the below code used to: Concatenate the values on a specific column "N" depend on the value of column "A" then delete the remaining rows. It works, but with range of 30k rows the ...
Leedo's user avatar
  • 275
2 votes
1 answer
121 views

Update an Excel master workbook with values from new workbook

I have a master .xlsx file on which other spreadsheets depend. Each week, I export a new .xlsx file (from MRP) that may or may not be the same as the master. The columns are always identical. Rows may ...
Tee Mothy's user avatar
1 vote
0 answers
54 views

Inserting Rows into Access Table Using Excel Macro

I have a macro that inserts data from Excel into an Access table. Each time it runs there may be 10k -250k rows to insert. I have experimented with using an empty database/table but it still takes 60s+...
Andy's user avatar
  • 123
0 votes
1 answer
79 views

VBA Excel - autosum values from all workbooks in the directory

I have the code such as this for opposite conditions. ...
Geographos's user avatar
3 votes
1 answer
91 views

Iteratively paste values from spreadsheet tabs into empty spreadsheet

Basically below code is taking first 7 tabs from my current sheet and pasting them as values in a blank excel sheet with same tab names and saving them in a specific folder by filename I specified. ...
Sorab's user avatar
  • 31
3 votes
1 answer
557 views

Excel VBA to powerpoint

I am basically looking for a way to trim below code. It works just fine. This code takes a range from each tab of an excel spreadsheet and pastes it into a powerpoint file, then assigns a title to ...
Sorab's user avatar
  • 31
2 votes
1 answer
228 views

Copy and Paste Macro Containing For Loop

The macro below loops through column E in Sheet2 and finds matches in column Z of Sheet1. If a match is found it copies the value on the same row contained in column AA. It works ok but hangs when it ...
Robsmith's user avatar
  • 123
1 vote
1 answer
390 views

Optimising Read/Write Speed of Excel VBA Copy/Paste Macro

I have an Excel sheet that connects to third party software which populates Sheet1 with data. It does this multiple times per second and overwrites previous data. I have written the macro below to ...
Andy's user avatar
  • 123
4 votes
1 answer
176 views

Using a Counter to Select Range, Delete, and Shift Row Up

I'm trying to clean my excel sheet so that all lines match with each other when I put 3 different tables from 3 different data sets next to each other. The code I have gets the job done but it's ...
Milo Sandoval's user avatar
3 votes
3 answers
490 views

VBA Very Slow Performance using objects with scripting dictionary

I have a simple code that loops through a text file to fix a few things in it and I use mostly dictionaries to find and handle the adjustment. However, with larger files (about 30K lines) it seems to ...
KE_1234's user avatar
  • 31
2 votes
1 answer
77 views

Inserting Rows after Contiguous Set of Integers - Excel VBA

I have a repetitive data reduction where I have a list of ID's that I want to find in a longer list. I have a method, but it is slower than I'd like. How can can I speed this up? The process: After ...
Brandon Murray's user avatar
0 votes
1 answer
61 views

Code compares Columns "A" of two workbooks and copies different information to destination workbook with entire selected row. LastRow count slows code

Code explanation: I have a code, which performs two tasks - To open two workbooks, one being extract info and one destination and it compares the column A with Column A of these workbooks and all ...
Rokas's user avatar
  • 3
2 votes
2 answers
187 views

Sub that calls itself when its parent Workbook is closed

and no, I'm not talking about Workbook_BeforeClose. Note that the motivation of this question is Excel specific but the technique I'd like feedback on is not. If ...
GWD's user avatar
  • 165
2 votes
1 answer
167 views

Create a string "Build" number for procedures and module

The class assigns various strings to the build number. So the build might look like 3.4.5.1 which would be of the format ...
DanM's user avatar
  • 121
2 votes
0 answers
391 views

SheetJS method to create an Excel file with subheaders

The method is fully functional and creates an excel as expected. What I would like to know, is if can be made more functional and better written for maintainability. For example, how can I put the ...
Jakub's user avatar
  • 271
4 votes
1 answer
191 views

Optimizing a large report sorting macro

I've been working on this project for my organization for a few months now, and am looking for ways to increase performance on this macro. I work for an insurance company as a claims auditor. I get a ...
Dallin DeFord's user avatar
2 votes
1 answer
240 views

Parsing information from Excel files

I have to parse information from several Excel files (.xls, .xlsx). The structure of the files is nearly identical except for the columns order. In this case it is ...
nop's user avatar
  • 739
0 votes
0 answers
48 views

Update cell format based on adjacent cell values

Trying to speed up this macro, it just loops through 'C-L" columns and changes the format based on adjacent cell values. ...
doug mackie's user avatar
1 vote
0 answers
43 views

makes plots associated with selected utilities

This code is applied to a master workbook with tabs containing characteristic information e.g. "Reliability standards", "Targets" etc. about each utility. The utilities of interest ...
patsy_794's user avatar
1 vote
2 answers
81 views

Copying formulae between sheets

I am currently running multiple macros on a large volume of files however watching it go through its processes today I realise one of my issue is that my loop runs through my workbooks 3 times instead ...
rmba22875's user avatar
4 votes
2 answers
870 views

Loop between two Arrays and change values based on condition

Instead of using 45 IF conditions , I put my two ranges into variant arrays. Then I used the below code to loop between them and change values of the first array ...
Leedo's user avatar
  • 275
6 votes
1 answer
437 views

Fastest function to `Remove Duplicate Lines` per each cell

The below function is used to Remove Duplicate Lines per each cell. It works without problem, but it is slow with a range of only one column and 17k rows. Actually, ...
Leedo's user avatar
  • 275
1 vote
0 answers
100 views

A Type.FromText function in M for PowerQuery using Expression.Evaluate

The Solution I recently came across this solution here, for a Type.FromText() function in M for Power Query*. This solution allows a user to extract the actual <...
Greg's user avatar
  • 403
9 votes
2 answers
2k views

Small datasheet code running super slow on Excel VBA

The code has been super useful with my work datasheets. They all have this pattern and the VBA code makes sure it all has the right format. Why is it so slow? Sometimes it takes 2~3 minutes to run a ...
Afonso Medeiros's user avatar
-3 votes
1 answer
88 views

Transpose and Paste VBA [closed]

Currently from my sheet2, I wanted to copy the column C36-N36. However, each of these cells has one formula that is generated from the numbers within sheet2, i.e. C36 = A1+A2/2 something like this. ...
Jackson's user avatar
6 votes
1 answer
1k views

Filter Range VBA function for Excel

Premise I have written a function in VBA, called FILTER_RANGE(), which accepts a Range object and a filtration parameter. Unlike ...
Greg's user avatar
  • 403
2 votes
1 answer
103 views

Gathering data from a file and analyzing it

Recently started learning python, and it's quite a difference coming from C and knowledge taught in CS1. Overall, I am trying to build a team building script for my summer side-project (probably will ...
CodedRoses's user avatar
3 votes
2 answers
458 views

VBA functions to calculate sun and moon positions

I have the following VBA code (across three modules) to make UDFs to calculate sun & moon position data. The issue I'm facing is that they are very slow to run as I have over 6000 rows (over 10 ...
hidp123's user avatar
  • 31
3 votes
1 answer
720 views

Add padding to top and bottom of cells

I have a column with variable length text in each of the cells. I have written some code to add padding to the top and bottom of the cells. While the code works well it becomes quite slow when the ...
jblack's user avatar
  • 131
1 vote
0 answers
61 views

Extract, transform, and load Excel files

I am curious to know if there is a cleaner/better way to write this. Any suggestions would be greatly appreciated! I do ask some questions in comments within the code specific to certain functions/...
Dre Day's user avatar
  • 111
2 votes
1 answer
65 views

Identify Anonymous orders in BOM list & update accordingly, execute time is taking very long

Right here, I'm trying to identify whether or not the demand order in my multi-level BOM list is made by an anonymous customer and then update accordingly. -In laymens term, I'm checking if an item ...
hyerii's user avatar
  • 55
2 votes
0 answers
352 views

Command line framework for VBA compiler app, written in twinBASIC :o

Ok compiler is a bit of a stretch... I'm working on a package manager for VBA code, written primarily in python. One fiddly step of the pipeline involves "compiling" packages; this is the ...
Greedo's user avatar
  • 2,345
0 votes
2 answers
165 views

VBA - Compare & Consolidate Dynamic Arrays

Background The CSV files being used can be 6+ mill records in size, using a small sample size to proof the methodology. Why are you doing this on excel? Access or SQL would be quicker My company has ...
JasonC's user avatar
  • 11
8 votes
0 answers
660 views

A VBA program to quantify the performance of code execution timers

Motivation I am interested in optimising the execution time of code with short (fast) execution times on the order of microseconds (µs), but that will be used with high frequency (e.g. like ...
vbAdder's user avatar
  • 181
2 votes
1 answer
76 views

VBA, Data Split Into Two Rows, Convert To One Loop Optimization

I'm trying to convert a data set that is split into two rows into a single row. This was my solution. ...
Jeff Glidwell's user avatar
2 votes
1 answer
820 views

Excel VBA to Fetch email addresses from inbox and sent items folders

I am using the following VBA to fetch multiple specified Email addresses from inbox and sent items folder also including cc and bcc for eg(gmail.com;yahoo.com) must return all mails having that domain ...
DeepnilVasava's user avatar

1
2 3 4 5
23