Questions tagged [excel]
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
1,089 questions
6
votes
1
answer
108
views
Excel Bookkeeping Application, Create Ledgers from Chart of Accounts and Journal
I am writing an Excel bookkeeping application that would be suitable for a small business or contractor. The application is based on a book on double entry bookkeeping:
https://www.amazon.co.uk/gp/...
- 2,531
0
votes
0
answers
37
views
VB.NET code for storing purchase transactions in Excel
I have written a VB.NET program to store purchase transactions into an Excel file. The code runs without any errors and functions as expected, but it takes a significant amount of time to complete, ...
6
votes
3
answers
556
views
Relational-join Excel tables
I have an excel file and I am trying to find matching values based on these criteria.
For ARMADAS B2: D542295890, I am getting the ARMADAW A2:B05KAYIP
I will look for B05KAYIP in the E column ...
- 267
7
votes
2
answers
308
views
VBA: Efficiently Organise Data with Missing Values to Achieve Minimum Number of Tables
The task is to create sub-tables from an original table (like below) that contain the missing data columns (missing data is highlighted in red). The important part of this task is to make the smallest ...
- 71
5
votes
0
answers
86
views
Excel Lambdas for Filtration Lookup
Background
I have an ongoing challenge in Excel, where I must match differing descriptions of the same object. Originally, there were only two alternatives:
Use a dropdown list in Excel, which pulls ...
- 549
3
votes
1
answer
124
views
Search through all the sub-folders in a given folder for files
I use the below code to loop through a list of data and search through all the sub-folders in a given folder for files which match my requirements.
Right now it takes this code about 22 minutes to run,...
- 33
4
votes
1
answer
161
views
Speed up recursively looping through network folder and subfolders in VBA
I'm trying to loop through around 100k files in varying degrees of nested directories using vba and md5 hashing each of those files. Right now, the current state of the program takes around 1.5 to 2 ...
- 43
3
votes
2
answers
194
views
Excel sheet manipulation program
I'm very new to programming, and I'm hoping I can get feedback on the code I wrote - anything is helpful - what to split into different files (right now 1 large file), perhaps a way to break up the <...
- 33
2
votes
1
answer
240
views
Python using generators with Excelwriter - Performance
I'm looking to understand if my code has an obvious blockage or performance pain point that will cause it to operate slower or use more memory than it should.
The current Excelfile i am processing ...
- 131
-1
votes
1
answer
72
views
Need assistance modifying a "too large" procedure [closed]
I have a chunky VBA script that needs some help making it efficient, which I think will correct the "Procedure too Large" issue I just ran into.
I run the procedure from an open workbook ...
2
votes
1
answer
226
views
Which is faster: Unhide rows during IF or Unhiding them all at once in another macro?
I have process where I am generating workbooks from a list. One of the tabs has varying height and I have a formula that my macro uses to determine whether to hide a row.
As I move to the next ...
- 211
3
votes
1
answer
165
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 ...
- 41
2
votes
1
answer
131
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 ...
- 21
0
votes
2
answers
144
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.
...
- 77
4
votes
0
answers
419
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 ...
