All Questions
Tagged with time-limit-exceeded excel
22
questions
0
votes
1
answer
63
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 ...
2
votes
0
answers
409
views
How to speed up the VBA scraping process
I want to scrape 25000 addresses using Column A cell values as search strings. I'm using the following code, it is working fine but it's too slow to extract 25000 results. Is there any way to speed up ...
0
votes
1
answer
5k
views
VBA Excel Looping through recordset and storing the data to use later
I have a loop to add Recordset items to a Dictionary so I can do comparisons and retrieve specific data later in the code (not ...
1
vote
1
answer
93
views
Merging records from one spreadsheet into another
I have created the code below that compare two spreadsheets . It initially compares the range of value from sheet1 ("Status") to sheet2 ("Interface") . Whenever a range matches with the ranges present ...
1
vote
1
answer
130
views
Combine contiguous spreadsheet cell references into larger ranges
For a hobby project, I am using openpyxl to export Excel workbooks as JSON. Part of this involves identifying the formatting applied to cells, and serializing this information (provided the format is ...
1
vote
1
answer
103
views
User form that searches a spreadsheet
I have this userform that looks up into a sheet. The problem is that when there are a lot of rows to look up it takes too long to execute (for example 100 thousand rows). Is it possible to reduce the ...
0
votes
1
answer
52
views
Macro to clear cells that do not appear in a master list
The macro below clears cells that do not match any cell in comparison to a range (a master list). It works on small file but is too slow to work for files with large ranges.
...
0
votes
3
answers
173
views
Writing many cells to sheet causes Excel to not respond, replacing vlookups [closed]
I have found that my code causes my Excel to 'not respond' when it gets to this for loop, For thisRow = 2 To lastWSrow(outWS). I'm guessing this is because I am ...
0
votes
3
answers
295
views
Transforming tabular view of data in an Excel sheet into a vertical view
I have the following code that works correctly on small data-sets, but times out and crashes on large data sets. The goal of this code is to take a tabular view of data on one sheet and transform it ...
1
vote
2
answers
116
views
Grab data from one sheet and insert/format it into another sheet
I have code that runs and does what I want it to do with the click of the command button, however when executing, it runs very slow.
The code grabs data from one sheet and inserts/formats it into ...
1
vote
3
answers
69
views
Substitute Excel-Workbook reference for another
I have an Excel-Workbook, where we have an sheet where we consolidate data. Basically we link to other Excel-Workbooks. I wrote the following Macro, in order to update the path and filename. We cannot ...
2
votes
3
answers
830
views
Filtering rows in Excel according to words, dates, and ID numbers
I have 3 columns of ID, Field, and Date (Apologies, I do not know how to format so everything is neat in 3 columns):
...
2
votes
1
answer
10k
views
Compare two Excel workbooks, and create a new sheet containing the differences
I have code that scans and compares two Excel workbooks, and then pastes all of the differences between the two into a new sheet. My code is working properly -
the only problem is when the Excel ...
3
votes
1
answer
609
views
Delete unmatched rows in Excel
I'm looking to optimize my for loop to search faster. I've turned off ScreenUpdating, EnableEvents, Calculation, and DisplayStatusBar to speed it up a litte. I have about 10,000 rows to search for in ...
3
votes
1
answer
979
views
Compare two datasets in Excel VBA
I made the following code to take two reports and compares them to show the end user elements which are missing from one of the reports so they can make the adjustments needed.
This is the main ...