Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
1
vote
4answers
106 views

Excel VBA optimizing for large data base

I am new to coding and need help with a code that won't complete. I suspect it is due to the size of the data set. I tested the code using a reduced data set and it processes fine. However, my actual ...
2
votes
1answer
83 views

Compare text in two excel ranges, highlighting additions and strikethrough deletions

Code is running ok but need to be reviewed for any limitations / possible improvements. Not sure will work in all scenarios because of the number of ifs and else and length of the macro. Referred to ...
0
votes
0answers
34 views

How do I quickly look for parents containing their own code as child?

I have tree-like data that is constructed of Parent codes that contain Child codes which may act as parents themselves, depending on if they're marked as "SA". This data is present in an Excel sheet ...
4
votes
2answers
86 views

Time axis with working days, weeks numbers, month-year

I made the bellow macro to create a time line in excel. It shows the working days, the week numbers and the month together with the year. First I start with projectstart date and projectend date. As ...
2
votes
0answers
37 views

VBA Excel bulk data loop for few columns at once

Good afternoon, I have a set of working code, which works as a loop between values i = 0-90 step 0.25. It gives 360 combinations exactly. I used to do this loop separately column by column. It takes ...
3
votes
2answers
75 views

User-defined function for estimating coefficient of performance

I am using hourly weather data to estimate performance of commercial refrigeration systems under various parameters. The formula for estimating co-efficient of performance (COP) of these systems is ...
0
votes
2answers
65 views

Autofill a table based on the input provided in a userform

Good morning, I have the following code: ...
3
votes
1answer
43 views

Write Excel range containing names to .pcs script file for PABX programming

I'm a newbie PABX tech with a hobby for programming so when I learnt most of the telephone system programming can be completed with scripts I got curious. With a bit of trial and error to work out ...
3
votes
1answer
70 views

Calling an Excel User Form from Outlook

I have an Outlook Module that contains the VBA Code below. The VBA code opens an Excel Add-In called TMAPAddIn.xlam, which then displays a User Form. I exported the Module and gave it to other ...
1
vote
0answers
119 views

Optimizing VBA code , Takes more than 50 minutes to update

Could you please help me optimize the macro, Its taking more than 50 minutes but still no success. The For loop is looping untill 1.0 million + rows. Screen is flickering. I have tried Application....
6
votes
0answers
109 views

An over-the-top approach to data entry

My goal: to make the already easy task of filling out an excel sheet 1% easier by putting in hours and hours of effort. On a more serious note, I'm currently developing a system to manage inventory at ...
-1
votes
1answer
23 views

SQL Group qry by codeProduct and Last(description) [closed]

For the ADMIN: I wrote this tread on S.O. questions/61183026, but I think that is more correct to post this tread here, if you think no, please scuse me and delete this message. Hi, I've one xls ...
3
votes
1answer
1k views

Python script for refreshing and preprocessing data in Excel report files

I wrote some code to create marketshare reports. However, I'm sure it can be improved. The tasks performed are: Open the global data file, refresh the data, import its content as a DF. Create a ...
2
votes
1answer
47 views

Finding matches in Excel files, adding to a Pandas Dataframe

I have a business requirement where I have to read excel files and match each cell with a given keyword list and find the matches and write it into a dataframe. I have written the code, but when the ...
1
vote
1answer
59 views

Altering spreadsheet data

I have the below code that helps me do some formatting. But I want to increase the efficiency of the code by making it faster. Below are the formatting steps of the macro. Convert "Q" and "S" column ...
2
votes
1answer
48 views

Loop through a worksheet and insert a row with layout when value is true

I have a code that does a loop through a worksheets, if there is a value 2 inside a cell in column S, then I want to insert a row with a specific layout. I have the code, but it takes ages to complete....
1
vote
0answers
63 views

Assign random shift with restrictions

Based on this question Thought it was a nice puzzle Main idea: How to randomly assign shifts to employees based on these restrictions: As per the O.P.: Randomly write to cells "1" or "0" ...
5
votes
1answer
130 views

Filter a two dimension array

This is the function I've wrote to filter a two-dimension array. I use it mainly on forms with user-defined filter (categories, dates, search bar, etc). It works fine, but it's ugly. Do you have ...
-1
votes
1answer
65 views

Worksheet change and worksheet selection change slowing down my file

I have a file that i use as database. It has the records and in the row 1 several cells used as buttons, (open folder, copy text, send mail, ecc.) At any change on any column of any record the file ...
2
votes
1answer
234 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
73 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 ...
2
votes
0answers
151 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 ...
4
votes
0answers
67 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. I ...
8
votes
1answer
148 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 am still ...
2
votes
1answer
66 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
119 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
130 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 ...
4
votes
0answers
63 views

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
108 views

Autofiltering and deleting rows two times too slow

...
1
vote
0answers
95 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: ...
5
votes
1answer
478 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 ...
6
votes
1answer
904 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
124 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
68 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 ...
2
votes
0answers
1k 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
91 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
99 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
1k 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
129 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 ...
4
votes
1answer
371 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
112 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 ...
3
votes
1answer
500 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
98 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
87 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
43 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 ...
5
votes
1answer
337 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
154 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
113 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
89 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
44 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 ...

1 2
3
4 5
22