Questions tagged [excel]

Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft.

Filter by
Sorted by
Tagged with
1
vote
0answers
22 views

Performance on countifs and sumifs

I'm trying to calculate with SUMIFS and COUNTIFS some data. The output sheet looks like this: I've hidden some irrelevant or ...
2
votes
1answer
52 views

aggregate sheets from many excel workbooks into one workbook

I want to put the worksheets from several (2-5) excel workbooks (files) into one single workbook. The names of the workbooks are not standardized and so I opted for a dialog box to select the ...
1
vote
0answers
20 views

Optimizing the openpyxl program

Purpose of the code: Let's say I have 3 excel files to deal with. Those file have already been filtered or hidden because the content is very large. And I only need part of the content for every ...
0
votes
0answers
40 views

Adding items to Collection using VBA [closed]

I am storing Table Header values into a collection using an OOP approach with VBA. Being new to this OOP approach, am I breaking any rules in the way my ...
3
votes
0answers
47 views

Combine filtered or hidden cells

Purpose of the code: I have 3 Excel files to deal with. Those file have already been filtered or hidden because the content is very large. And I only need part of the content for every excel files. ...
8
votes
1answer
109 views

Data entry of Information

Couple of items to make note of first: Some of the code is inherited the other has been refactored by me. The procedures that have an underscore in them I am still working on refactoring. I ...
2
votes
1answer
59 views

Best practice when checking multiple addresses for a Worksheet_Change() event?

I'm doing some code revision and I'm looking at this portion of my Worksheet_Change() event: ...
2
votes
1answer
98 views

VBA Automatic insert in a Excel Spreadsheet

Since I'm new at this site I will try to start with something very simple. I'm making an "Automatic insert" in a Excel Spreadsheet and my code is working correctly, but I'm not so sure about my way ...
4
votes
2answers
93 views

VBA to retrieve/display information of cells in excel

I am working as a validation technician for excel spreadsheets in a pharma company. Sadly & interestingly I don't know much about VBA and Excel. To validate those excel spreadsheet, I developped ...
2
votes
0answers
44 views

Better ways to edit Excel through MS Access?

I have an Access macro that runs AfterUpdate of a form. It opens an excel workbook and edits a few cells. I have It working the way I want, but the problem is that ...
1
vote
2answers
70 views

Autofiltering and deleting rows two times too slow

...
1
vote
0answers
61 views

Managing Excel Tables (ListObjects) with OOP Approach (Second follow up)

This is a follow up to this question and this question Objective: Manage what happens when users interact with Excel Tables (ListObjects) Code incorporates: ...
4
votes
0answers
70 views

Class to organise frames on an Excel userform

The Task A task I've been given recently is to design a data entry form which transfers data from the form to a table on a worksheet. Depending on the answers given to various questions, other ...
5
votes
1answer
229 views

Evaluating formulas greater than 255 characters

Recently I was receiving Error 2015 when trying to use Application.Evaluate, then I realized it was because my formula was greater than 255 characters. As a ...
2
votes
1answer
113 views

Adds text to specific cells then bolds one column and copies it to target sheet removing bolded column. Makes last column red

What I have tried to accomplish with the code is to make some sort of partner budget where 2 people can have 2 separate budgets with separate expenses but which are still intertwined with eachother in ...
3
votes
1answer
62 views

Checks data already stored in specific worksheets then populates data as needed

The code below looks at different range values and then populates specific cells on a worksheet called GeneralInfo in the Worksheet_Activate event.The below code ...
1
vote
0answers
17 views

Resolve parent child hierarchy in Power Query M code with sorting columns

Based on this article And this question posted on the power bi forums Objectives: Resolve a hierarchy (parent - child relationship) in Power Query adding levels and their corresponding sorting ...
0
votes
1answer
68 views

Trying to optimize VBA code to create worksheets

I am learning to clean my code and make it more efficient, however I'm having trouble with my code, because most of the post about the subject are specified to a given code. The code below looks like ...
3
votes
1answer
82 views

SQL to Excel then to CSV file for Data Upload

Before we get started I need to let you know a critical piece of information: Due to permissions within an offsite database I am NOT allowed to create tables even temporary ones within the database ...
3
votes
2answers
62 views

Retrieve status for a list of FedEx tracking numbers

Background If you buy something from our facility, you will get a box with a shipping label on it. The two main numbers it will have are a FedEx tracking number and a carton number. For cartons that ...
2
votes
1answer
85 views

How to speed up VBA to Extract data from Word to Excel

I am new to stackoverflow and a newbie to VBA coding. At my work, we are supplied with shipment data in the form of Ms Word which is not very useful. I have found a way to transfer the data using VBA ...
3
votes
1answer
96 views

Implementing a class hierarchy and instancing the base class in VBA

Objective: Have a single point of entrance to initialize a class that holds instances of "sub" classes Background: I read about inheritance in VBA (or as close ...
1
vote
1answer
48 views

VBA Class instance to simulate a framework

Objective: Simulate namespaces in VBA and access functions like if you had a Framework setup or at least that was what I ...
2
votes
1answer
84 views

Managing Excel Tables (ListObjects) with OOP Approach (Follow up)

This is a follow up to this question Objective: Manage what happens when users interact with Excel Tables (ListObjects) Code incorporates: Greedo's answer suggestions: Listen to an encapsulated <...
2
votes
2answers
87 views

Why does it take so long to print values from userform to sheet?

I have a userform with around 20 controls in that can be inputted. Some are textboxes some are comboboxes etc. The user fills in these controls and then hits save. When save is pressed, the code ...
2
votes
1answer
62 views

Inserting large amounts data into Excel spreadsheet

I have a VSTO Excel Add-In which is used to retrieve data from another application and insert it into an Excel worksheet. Due to the potential for lots of pieces of data to be inserted into a ...
2
votes
1answer
36 views

Copy Certain Cells over to another worksheet based on column headers

I have two worksheets in my workbook. The first worksheet ("home"), the user will enter information in cells B7-B14, not all of the fields are required in order for the macro to proceed. I need each ...
4
votes
1answer
148 views

Managing Excel Tables (ListObjects) with OOP Approach

Objective: Manage what happens when users interact with Excel Tables (ListObjects) Possible interactions: Update an existing Excel table Add rows/columns to the table Update a cell or a range of ...
4
votes
4answers
112 views

Check non-continuous range for equal values

Background I'm trying to check equality between cells in an irregular, non-continuous range of cells. For this purpose I would like to know if all cells are equal to the first ...
2
votes
2answers
76 views

Excel VBE code find and replace

I need to write a VBA code routine with an efficient way to replace blank cells with values from another cell. For example, my worksheet has some blank cells on random rows in column D. I want to ...
1
vote
1answer
78 views

Changing the formatting of sheets

This my program to change the formatting of sheets in different folders. I have over 5000 files in one folder and it is taking up to three hrs for one folder and there are multiple subfolders in the ...
1
vote
1answer
43 views

Populate dates in a label based on dates in a hidden sheet using IIF

The code below uses information saved in a hidden worksheet based on values from another sheet with a codename of GeneralInfo and is called when specific cells in GeneralInfo are changed. I think ...
0
votes
0answers
54 views

When passing in a range in an excel worksheet in VBA code makes the code run through every cell causing the code to run slow?

When passing in a range in an excel worksheet in VBA code makes the code run through every cell causing the code to run slow. I want to be able to pass in the range RngOP into the method ChangeCode(...
2
votes
1answer
44 views

Opening a specific Outlook item quickly

I have this code to open an outlook appointment item: ...
2
votes
1answer
47 views

Loop with multiple conditions that need to be true, across two different sheets

I've written some code in Excel VBA that does the following: Finds a cell ("O") in a range (C3 to Z26) Looks at an adjacent cell. This cell is located through "OFFSET_ROW" and "OFFSET_COLUMN" (...
3
votes
2answers
57 views

Modifying shapes in a group of shapes

The code is going through a series of shapes inside a group of shapes. The grpvariable is set as a Public shape variable earlier in the process of selecting the ...
6
votes
2answers
102 views

Create a 2 way mapping to allow you to stringify enums or map one enum to another

I've created a class that creates key->value pairs but also value->key pairs - i.e. a reversible hash-map. This is because I want to be able to switch between corresponding members of 2 enums with ...
2
votes
1answer
48 views

read an excel that contains population data of counties and compute summaries by state, county

As part of the exercise in the book "Automate the boring stuff with Python" chapter 13 on Excel, I had the following exercise: Reads the data from the Excel spreadsheet Counts the number of census ...
1
vote
1answer
38 views

Populates Data from one Workbook to Another

Another code clean up I am working on. I have been breaking up my code based on things I have learned here on CR. The code below all works and functions as expected, but I know it can be streamlined ...
3
votes
1answer
78 views

Utilize loop or other efficient way to find string and copy offset columns to certain cells

I am trying to find certain strings in MasterSheet and copy offset columns (3 columns) values in the specific columns in receiver sheet. So far i have this code doing exactly what i want to do ...
4
votes
2answers
80 views

Sequence Generator from previous max sequence based on certain conditions

I'm new to VBA programming so the following code may look terrible which is why I want ways to understand how to better optimize it and other future codes. ...
6
votes
1answer
144 views

Copying strings from files into a new Excel sheet

My code here loops through my folder and my files inside the folder and use .find and copy the strings into a new Excel sheet and then with all the data in the new ...
1
vote
2answers
71 views

Reduce time taken for VBA loop when copying multiple sets of input values, performing Excel formula calculations and recording results

My VBA code currently loops for 5,000 iterations and takes about 25 minutes to collect the output data in the Output excel sheet. Is there a way to reduce the time taken for instance by improving the ...
2
votes
1answer
71 views

VBA More effective way of data trimming

My code consists of Split, Mid, Left, Right and ...
2
votes
1answer
62 views

Add items to Dictionary from another dictionary on cell value change

I have created a very simple Class Module and a Dictionary to store original values when the workbook is opened as part of this project ive been working on. When the workbook opens I call a test to ...
3
votes
2answers
59 views

Worksheet_Change Event Sends Email

I have functioning code that I wrote what seems like a long time ago in a Worksheet_Change event, and even though this works I'm sure that it can be written better. ...
0
votes
1answer
83 views

Copying data from a “master” sheet onto multiple “detail” sheets

I'm new to using VBA. What I'm working on is to copy details from a master file to multiple sheets within a worksheet. I'm facing a performance problem when I run my code, my Excel file keeps ...
5
votes
2answers
107 views

VBA Workbook to automate e-mail delivery

I started learning VBA for an internship, 3 months ago. This is the last project I have worked on. It does all the tasks it has to do, it's all about code review. I will be grateful for all ...
1
vote
1answer
95 views

Comparing information to a directory of active enployees

The code is doing everything that I need it to. It's taking much too long though upwards of a couple minutes to complete the macro. Does anyone know how I code optimize this VBA code to run quicker? I'...
3
votes
2answers
87 views

Inherited Code - Worksheet_Change Event Code

I inherited this code and have to fix it. It does work and I know I can refactor the code using If Not Intersect(Target, Me.Range()) Is Nothing Then syntax. I am ...

1 2 3 4 5 20