| CARVIEW |
Select Language
HTTP/2 200
date: Sun, 27 Jul 2025 11:26:24 GMT
content-type: text/html; charset=utf-8
cf-ray: 965bc817f814f470-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=bef58149-7675-4744-a36c-ee15163cc07c; expires=Mon, 27 Jul 2026 11:26:24 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: 3061585d-5b94-4b8c-8829-37d86e09b009
x-worker-origin-response-time: 586000000
x-dns-prefetch-control: off
set-cookie: prov=bef58149-7675-4744-a36c-ee15163cc07c; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=KZEIPUXwQAB7QgGSfvvOYrBbt6eyAYxMFGqGHGn1Q4c-1753615584-1.0.1.1-2mIcGcgBNzt8ILOLnfli.GnodX_PpykxekyQTU9419r83CcPSC8DZNVK6Rmz2No60m1BXPDBUCRQpl1q7U5.vldCoiPbppLsCXUX_HcAEyc; path=/; expires=Sun, 27-Jul-25 11:56:24 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=f6JQKM5uyXMKk0ppyA6E0X050Mn6C56367GHuyowrew-1753615584598-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'excel' Questions - Code Review Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions tagged [excel]
Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
1,089 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
6
votes
1
answer
94
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/...
1
vote
0
answers
29
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
536
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 ...
7
votes
2
answers
293
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 ...
5
votes
0
answers
71
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 ...
3
votes
1
answer
110
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,...
4
votes
1
answer
142
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 ...
3
votes
2
answers
167
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 <...
2
votes
1
answer
236
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 ...
-1
votes
1
answer
70
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
204
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 ...
3
votes
1
answer
150
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 ...
2
votes
1
answer
115
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 ...
0
votes
2
answers
138
views
4
votes
0
answers
418
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 ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
vba × 879
performance × 261
beginner × 88
python × 81
c# × 60
array × 41
object-oriented × 40
python-3.x × 22
time-limit-exceeded × 22
csv × 21
error-handling × 20
pandas × 19
sql × 19
web-scraping × 19
java × 18
algorithm × 15
file-system × 15
hash-map × 15
ms-access × 15
datetime × 14
sorting × 13
ms-word × 12
rubberduck × 12
macros × 10
python-2.x × 10
more related tags
Hot Network Questions
- Time Machine backup disk not writeable any longer
- “Unclear step in a math book for entertainment”
- Easy ways to draw vector diagrams in TikZ?
- Can Spi flash memory's contents be corrupted from heat?
- Why does Gaza Humanitarian Foundation (GHF) not distribute more food in Gaza?
- Source for Adam naming the angels
- Not being introduced to the team – should I ask for it?
- Word order for a phrase with a number, adjective and noun
- Blinded despite Blindsight?
- JK flip-flop timing diagram: is Wikipedia correct?
- How do Japanese people understand the reading of a single kanji with multiple readings in their everyday life?
- Humans on alien planet get tailed by silent humanoids
- Will a reinforced 1" concrete slab be durable?
- Alternative to tedious assert-rewrite for trivial operations?
- Why is time reversal not a natural part of the Galilean group?
- What is the best way to bevel these corners without these deformations showing?
- About Harp Pedaling for a Pentatonic Glissando
- how is it possible for a player to have crossed 2400 and secure 3+ IM norms to stay FM
- Existence of Jordan curves between a compact and an open set
- Why are police personnel of all ranks called officers?
- How to make that the object sliding down along the local axis while following the rotation of the another object?
- About security concerns using in find -exec vs interactively performing the same task
- Early Sailing days in September 1066... Could Harold defeat William at Hastings, if it happened before Stamford Bridge?
- Is this a violation of open source?