Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.
1
vote
0answers
11 views
Workbook for tracking projects
This workbook is used to track projects. I have this VBA code linked to a Form Control button. When I press the button it will run through and get information from all the project sheets and feed it ...
-2
votes
0answers
25 views
Excel VBA to edit response in Google sheet via Google form [on hold]
I have modified this Excel VBA code to edit response of Google form, this code is working for one url (Response edit URL) but how to edit all existing response with excel until the last empty row. Any ...
5
votes
2answers
237 views
Summarizing data from multiple sheets
I have 9 sheets with 1668 rows and 34 cols. The code collects all data from every sheet into one Summary sheet in the following format:
...
-2
votes
0answers
23 views
Improving the performance of this VBA Script [on hold]
Upon opening this workbook the following script runs which writes a formula to create a link to multiple workbooks. Each workbook writes to 3 columns i.e. workbook 1 writes to A, B and C and workbook ...
3
votes
2answers
44 views
Search for string in many WBs and post results into another WB
I want to search for a string inserted in TextBox1 on Mainwb within a range of data located in Workbook ...
6
votes
3answers
62 views
Parsing excel cells containing line feed characters
This is a direct follow up to Parsing cells containing Line Feed Characters.
Link to sanitized xls on dropbox if test data is needed
Essentially the reports I work with aren't bad -
The issue ...
0
votes
0answers
46 views
Script Task to read complex Excel file structure with multiple sheets and export into database tables
Currently working in SSIS 2012 - Script Task to read complex Excel file structure with multiple sheets and export into database tables. Below is my sample code which does below process.
Get the ...
6
votes
2answers
54 views
Output the average values of binned columns in Excel VBA
This code is meant to run through a column of values, bin the values based on specified ranges, then output the average value of each bin. The problem is the code is running quite slowly (...
8
votes
1answer
91 views
Pasting Values To/From a Calculation Model
I have a Database worksheet (SoapUI - CollisionsSingle) that have around 1500 records and 38 columns of data per record. I have a VBA script that copies the records ...
5
votes
1answer
57 views
Determining whether a date is within a range
I am taking a user input which consists of a from date and a to date. Those dates are compared against 4 cells in a row - a post date, pause date, resume date, and a close date. My goal with this code ...
4
votes
1answer
39 views
VBA Print Summary Pages - Excel - Runs Slow
Looking to speed up this code some if possible. There is a main page with this macro assigned to a button. Once the button is pressed it ask if you wish to continue and mentions it takes a while to ...
1
vote
1answer
57 views
Copy and paste to different worksheets
This code:
Copies a value from "Sheet1"
Pastes special (as a number) in another sheet "Sheet2"
Jumps to the next line
I ...
4
votes
1answer
48 views
Powershell Interaction with Excel (Highlighting Cells)
I'm using Powershell to compare two, large csv files and output the rows which don't match. Once the two output files are made (one for the differences on each), I bring them up on Excel. Now I want ...
3
votes
2answers
39 views
Take all underlined words, put in Excel column
I have a 100+ page Word document, that I would like to extract all of the underlined words from. I am very familiar with VBA and Excel, but relatively new to Word. I was wondering if this is the best ...
2
votes
3answers
45 views
Converting a range in excel to a single column with excel vba
I am very new to coding and know only the basics. The first part of this code is running fine. It converts a range of values to a single column. However, with my data set the rows of data step down,...
1
vote
2answers
207 views
Excel VBA used to fetch Access data
I am using the following VBA to fetch data from an Access database. The query works but there is a lot of information in the database and the response time is very slow, about 30 seconds.
Is there ...
3
votes
1answer
51 views
Partial anagram generator in VBA Excel
I'm trying to make a VBA code to arrange k-element subset of an n-set into some sequence. In other word, I'm trying to list all of k-permutations of n member set. For example, let's try to list all of ...
2
votes
0answers
27 views
VBA - Cycles through a table to find the cheapest bearing that passes
I have written several VBA macros to run on an excel spreadsheet. Inputs are entered into a table and then the macro is run; it cycles through a table of Bearings (in price ascending order) and ...
5
votes
1answer
50 views
VBA to MS-Access SQL query set(s) and outputs
I am hoping I can get some guidance on some better "best practice" suggestions on how to handle this kind of code set. I understand that parameterized queries are a thing, but I am not quite there yet,...
1
vote
1answer
48 views
Generate SQL for translated resources from Excel Spreadsheet
I do some work that involves translating resources for a webpage. These are all stored in a SQL Server table that looks like this (plus a few irrelevant constraints).
...
6
votes
2answers
72 views
VBA macro - searches through a filtered table, stops when entry passes criteria
I have written several subs which are then called from a main sub. Individual subs run very quickly, most are instantaneous (the DoFind sub takes a few seconds to run due to the large amounts of data ...
4
votes
2answers
61 views
Export data from Python to spreadsheet
I have written the following code to export to data to a spreadsheet with this result:
Please let me know how to improve it.
...
5
votes
4answers
135 views
Trying to make more simple VBA
I have few models like this below for diferent tools i manage. I am trying to clean/improve the code... Could you help me?
All the informations comes inside columns B to N, and the column P ...
4
votes
2answers
53 views
Simplifying manual data entry with a UserForm Excel 2010
I am an absolute beginner. This is the first thing I've ever coded in VBA. I don't know if I'm allowed to ask for just criticism in general without a question.
But just in case I can't, this file is ...
5
votes
3answers
57 views
CopyOf2DArray (Values Only)
Purpose:
Given a 2-Dimensional Array, return a copy of the Array. In VBA, if I just
Set newArray = oldArray
then newArray is ...
5
votes
3answers
65 views
5
votes
4answers
203 views
Get Filtered Data Range in a Table
Purpose:
Given a Worksheet Table (ListObject) that may, or may not, have a filter currently applied to it, return a range consisting only of the filtered data.
...
4
votes
2answers
54 views
Accelerate the process of filling the quality control table
I'm working on a report of quality control. I've got a table, with all the points of control inside, and each time, when I get a new test result, Excel should fill this table. My code already works, ...
4
votes
1answer
55 views
Copy sheet contents faster in Excel
I have code that opens a workbook and copies the sheet to the workbook running the code. I know activating is generally bad for speed but I can't figure out how to speed this up anymore. The data ...
8
votes
2answers
47 views
Reusable VBA macro to prevent Excel from destroying the data (+ backup capacity)
My goal is to prepare the Excel file (see the download link at the end) I would share with my non-technical colleagues, so that they enter some data into it and then I was able to automatically ...
5
votes
3answers
69 views
7
votes
1answer
35 views
Audit Updating Macro
In my code, I'm trying to manipulate data for an audit between 3 sheets in a workbook.The first block of my code is to paste the data of items I need to find for the audit from the original sheet onto ...
3
votes
3answers
62 views
List(Of ) like operation in macro
NOTE: I previously asked this question in Stack Overflow and got pointed here.
I have a macro that I am trying to get running a little more quickly. The intent of the macro is to merge multiple files ...
4
votes
3answers
95 views
Dealing Poker Hands
I thought I'd give a shot at creating my own version of dealing 5-card hands to n players in VBA, printing them to columns and coloring hearts and diamonds red.
I felt I might have been a little ...
8
votes
4answers
105 views
Converting from .xlsx to .txt
I have code that converts each sheet of a spreadsheet into a .txt file. It works well, however, given the big number of exports (about 90 .txt files), I'd like to seek advice on how to speed it up.
<...
4
votes
3answers
62 views
Error handling for cells.find
Revised and truncated version of my last question. I updated how I handle the error if a cost center is not found. I originally asked expecting improvements on the matching system so thoughts on that ...
0
votes
0answers
18 views
Automatically pull in data from one workbook into a template workbook and update the formulas [duplicate]
I have two workbooks: one being a template file with saved formulas that extend to the 30,000 row and the other workbook that contains the data that is input into the template file.
Due to the fact ...
8
votes
3answers
85 views
Loop through a unique combinations driven by choices
I am trying to optimize my code and make it as fast as it can be, I have researched as much as I can and am now asking the community for any tips because there are definitely people more experienced ...
5
votes
3answers
246 views
Transferring data for a given month from one sheet to another
I have dollar amounts sorted by month that I want to transfer from sheet entry to sheet actuals. I only want to do it for a ...
10
votes
3answers
802 views
Macro that does some kind of duplicate check
This macro pulls in two workbooks, one being a template with saved formulas already, and the other containing data with thousands of rows...I need to increase the speed because the process takes more ...
5
votes
1answer
110 views
Clearing filters, copying a range, and then pasting a formula down a row
Novice coder here. I have the following code to perform a few actions like clearing filters, copying a range, and then pasting a formula down a row till the last line.
It works perfectly, but it ...
10
votes
3answers
105 views
Userform for getting data from data sheet into a table
I am making a userform that grabs data from a data sheet and puts it into a table:
Grabs the data based on what the user wants (Brand -> Items for brand)
Allows multiple items to be added
Displays ...
11
votes
4answers
595 views
Copying values from one sheet to another
I am trying to copy values from one sheet to another using loop with two conditions and it is very slow. Removing conditions from code doesn't have any effect on the speed of the execution.
I already ...
7
votes
3answers
227 views
Summarize raw data in new sheet, 2.0
Thanks to zak for some great advice on this previous question. This is a follow up question:
I have an Excel workbook with two sheets: "Raw data" and "Summary". In the raw data sheet there are ...
2
votes
1answer
45 views
Summarize raw data in new sheet
Note: This question has a follow up question here.
I have an Excel workbook with two sheets: "Raw data" and "Summary". In the raw data sheet there are several blocks with data structured like the ...
9
votes
4answers
1k views
Create a list of random numbers with sum = n
I want to create a list of random integers in the range [0, 9], that sums up to 100 in Excel, using VBA. The list should be printed in a single column.
The routine I've written is as follows:
...
3
votes
0answers
51 views
Mailmerge from Excel to premade template in Word
I've written the following code to take data from the Excel file "Data" and use it for a mailmerge in a prepare Word template named "Template." I'm new to using VBA in word or Access, so any feedback ...
10
votes
5answers
841 views
Macro code that removes excess rows
I'm a business student who just started to learn VBA. I am trying to write a macro for a project but only have minimal experience actually stepping into the code.
The macro I have written is to ...
5
votes
1answer
63 views
Compare and find duplicates in 2 corresponding columns in 2 sheets
I want to compare (500) and find duplicate daily records within 2 sheets, and copy the unmatched row to another sheet, copy the match from another to 3rd sheet, and delete the matched records from ...
4
votes
2answers
49 views
Consolidate used student hours into master sheet for export
I've developed a spreadsheet that has evolved over several years to help keep track of the number of student contact hours that have been used to help flag up when students have run out / are running ...
