User M.Doerner

10 votes

Accepted

Code which pulls from SQL and dumps in Excel

answered Oct 31, 2017 at 11:13

10 votes

Accepted

Create a build order from a list of projects and their respective prerequisites

answered Jun 30, 2020 at 23:21

9 votes

Accepted

App for providing accounting solutions for clients

answered Feb 4, 2018 at 2:57

8 votes

Designing a text based guessing game with a branching decision tree

answered Apr 10, 2020 at 11:28

7 votes

Accepted

Summary Data According to Machine No, Order No and Shifts

answered Dec 16, 2016 at 17:07

6 votes

Check Accounting Journal for Errors

answered Jul 10, 2017 at 22:22

6 votes

Recursive code to generate a parametric sweep of input values

answered Sep 28, 2019 at 8:55

5 votes

Method to generate a List<string> containing permutation of an input string

answered Jun 5, 2020 at 19:55

4 votes

Assign a variant to a variant

answered Nov 3, 2019 at 19:29

4 votes

VBA script that copies data from one workbook to another

answered Jun 28, 2018 at 16:27

4 votes

Accepted

BattleShip Grid: Classes and Tests

answered Aug 21, 2018 at 8:50

4 votes

Writing an array to a worksheet

answered Jun 18, 2018 at 15:04

4 votes

Pairing all identifiers from 3 sheets and list them on a report worksheet

answered Dec 21, 2016 at 23:46

4 votes

Accepted

Remove unwanted characters from specified column in all Worksheets

answered Jan 10, 2017 at 22:26

4 votes

Merging rows in excel using VBA

answered Jan 19, 2017 at 20:30

3 votes

Sluggish Performance when using ranges from two workbooks to update the one

answered Oct 21, 2019 at 13:15

3 votes

Accepted

GUI Button Element with Unit Tests

answered Apr 21, 2019 at 18:18

2 votes

Comparing Multiple Columns to Remove Duplicates

answered Nov 1, 2021 at 21:46

2 votes

Accepted

Populating monthly report with new data each month

answered Feb 3, 2017 at 22:15

2 votes

Excel Duplicate File name with different Revisions

answered Feb 28, 2017 at 13:38

2 votes

Accepted

Transfer of data instead of copy.paste.clear used

answered Dec 13, 2016 at 22:05

2 votes

Increase the execution speed of VBA macro code

answered Nov 13, 2017 at 12:56

1 vote

Comparison of excel files, cell by cell

answered Jun 16, 2017 at 7:38

1 vote

"Pivoting" data with VBA

answered Nov 19, 2018 at 23:38

1 vote

Find and replace placeholders in Word with values from Excel

answered Jun 22, 2018 at 10:30

1 vote

Calculate quantities in a userform

answered Jun 25, 2018 at 22:05

1 vote

Getting Rid of .Find in VBA Code

answered Jul 1, 2020 at 20:40

Stack Exchange Network

27 Answers

Code which pulls from SQL and dumps in Excel

Create a build order from a list of projects and their respective prerequisites

App for providing accounting solutions for clients

Designing a text based guessing game with a branching decision tree

Summary Data According to Machine No, Order No and Shifts

Check Accounting Journal for Errors

Recursive code to generate a parametric sweep of input values

Method to generate a List<string> containing permutation of an input string

Assign a variant to a variant

VBA script that copies data from one workbook to another

BattleShip Grid: Classes and Tests

Writing an array to a worksheet

Pairing all identifiers from 3 sheets and list them on a report worksheet

Remove unwanted characters from specified column in all Worksheets

Merging rows in excel using VBA

Sluggish Performance when using ranges from two workbooks to update the one

GUI Button Element with Unit Tests

Comparing Multiple Columns to Remove Duplicates

Populating monthly report with new data each month

Excel Duplicate File name with different Revisions

Transfer of data instead of copy.paste.clear used

Increase the execution speed of VBA macro code

Comparison of excel files, cell by cell

"Pivoting" data with VBA

Find and replace placeholders in Word with values from Excel

Calculate quantities in a userform

Getting Rid of .Find in VBA Code