All Questions
13
questions
1
vote
1
answer
79
views
Copying and separating data by Excel Field
I created this code that's meant to pull a specific report that's been saved in a folder clean up (delete) the data and add new titles, divide the information up by one of the fields, then copy the ...
- 143
2
votes
1
answer
105
views
Searching and sorting ranges in excel with toggle buttons
I have a spreadsheet containing ±100 named ranges (5 rows, 15 colums) which are sorted based on time.
My plan was to make toggle buttons to hide or unhide named ranges when they contain a certain ...
- 21
3
votes
1
answer
114
views
Find all identical data in a Column and filter it to another sheet
I have spent hours on this code, and truthfully need some better expert opinion.
Column A on Sheet 1 has dynamic list of data, typically IP address, but for this it is simply a number. There can be ...
- 51
4
votes
0
answers
112
views
Comb Sort Multi-dimensional Array on Key
Previously: Comb Sort in VBA
I've been running two different comb sorts (on arrays) depending on whether I want to sort numbers or strings and I figured I would give using ...
- 7,159
2
votes
2
answers
482
views
Efficient method to sort read-in text file in Excel
I've read in a text file to excel from a database and I've done it in such a way that it filters out unnecessary columns. My approach to filter rows was to use two subroutines and call the 2nd from ...
7
votes
1
answer
361
views
Comb Sort in VBA
Playing off Robust Bubble Sort in VBA and as suggested by @Henrik, I took a look at comb sort and tried to create an algorithm based on the documentation solely on Wikipedia.
Basically, the first ...
- 7,159
4
votes
1
answer
1k
views
Robust Bubble Sort in VBA
I'm creating a robust bubble sort for VBA when sorting stored arrays in VBA. Mostly this would be used when an array is stored in a single cell with a delimiter. Otherwise, one could just sort on the ...
- 7,159
5
votes
1
answer
3k
views
Sorting a 2D array on 1 dimension
Inspired by a previous question, I was looking into converting a table to a sorted list (ascending) -
Resulting in this -
I used a very simple bubble-sort, but I don't know how efficient that would ...
- 7,159
12
votes
2
answers
587
views
Forecast maintenance interval for fleet of aircraft
Being new to VBA, and many years removed from college programming courses in Java, I'm seeking opinions about design, implementation, readability and general better practices using VBA to tackle ...
- 221
2
votes
2
answers
4k
views
Multi-dimensional ascending and descending sort array function
I'm back with improved version of previous Deca dimensional array sort function. This one is not just 10 dimension limited. It could be extended to unlimited number of dimensions by simply adding rows ...
- 313
5
votes
1
answer
109
views
Update on Weave Merging n lists into single list
This is a follow up to my previous post from 7 months ago. I changed up the algorithm a little. Instead of inserting items into a new list, each item's final place is calculated up front. Sort of like ...
- 313
8
votes
2
answers
399
views
Efficiently create and sort a Collection
The goal of my code is to sort data into two categories. It must use a local copy of the initial data from Collar (Top View).csv. My code creates a Collection of items called Collars using the initial ...
- 183
6
votes
4
answers
1k
views
A practical example of evenly distributing n lists into a single list
I had previously asked about how to evenly distribute the items in n lists into a single list and was referred to this question.
I made a practical example of my solution for this in VBA for Excel, ...
- 313