Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
3
votes
2answers
115 views

How to get the median value faster

Using Excel, I have one sheet ("db") with data extracted from MES. I have to analyze this data and I need: Articolo, Fase, Tipo Confezione, TURNO, Macchina, avg and median. I searched ...
1
vote
0answers
59 views

Trying to speed up VBA macro to generate viable Daily Fantasy Sports lineups

I have created the code below to generate daily fantasy sports lineups from a pool of players that have been entered in my excel file. Right now the code can run through about 16,500 combinations per ...
2
votes
1answer
101 views

Output the rounded sum of each column in selection

I've written something (i.e. frankensteined from stack exchange) that appears to work but I haven't done much testing on the edge cases. Signed up here for some feedback on what optimizations or other ...
24
votes
0answers
487 views

Pacman implemented in OOP VBA

What?, Why? I have been inspired by several other posts on the topic of OOP implementations in VBA to try and create a Pacman clone. I think this task is not all that hard in most languages; but, I ...
4
votes
0answers
73 views

Scraping and filling out a time-off request

In my ongoing quest to automate everything I have to do at my job, I've decided to learn how to do webscraping with VBA. I wanted to start with something easy, so the following simply fills out a ...
1
vote
0answers
57 views

Longer Macro getting stuck when opening Workbooks

I have a longer Macro has sub functions opening many different Workbooks, takes the data, and pastes into a Destination Workbook through arrays and .value. There ...
6
votes
1answer
170 views

Add Default Rubberduck VBA Folder Annotation to VBProject.VBComponents

Currently Rubberduck VBA files all the VBProject VBComponents in that do not have a Folder Annotation in a Folder named after the VBProject. It can be time consuming to manually organize the ...
4
votes
0answers
42 views

Sheet display in function of date and time on open and save (2)

Since I had to almost start all of the code again with first refactor and an eye opening advice on a random Overflow question, here it is again: This is a code that selects the right sheet according ...
4
votes
1answer
41 views

Sheet display in function of date and time on open and save

Here's a simple one for u guys, The code is called upon workbook_open and BeforeSave, it displays the right sheet in function of date and time (Day vs night shift vs date). The code run trough the ...
3
votes
1answer
155 views

Creating a values only copy of an excel workbook without opening it

I have created a working VBA script that allows the user to select a workbook and make a values only copy of it without opening it. This is useful for getting data from a workbook that is very slow to ...
3
votes
1answer
90 views

Copy-Paste-Find-Replace (weekly update)

Heres a code that update weekly datas from production reports Known flaws : Im copy pasting the old line and replacing the week number in it to fit it to the one we want to update. The problem is ...
2
votes
1answer
71 views

Load multiple worksheets from Excel file to multiple DataFrames

The spreadsheet can be found just above the references section at this link. https://www.sciencedirect.com/science/article/pii/S1872497316301429 It's a publication for STR DNA locus frequencies to ...
2
votes
3answers
96 views

Better way to code this code snippet (copy paste)

I am trying to improve upon a VBA code created through recording a macro. Can the code below be optimized (I was informed to avoid .Select as much as possible)? The code itself works fine for me ...
4
votes
1answer
88 views

How to copy and paste a filtered range more efficiently

I have this bit of code that works for copy and pasting an autofiltered range. I just wanted to see if anyone knew a more efficient way to do so as it does take quite a while to complete it the way I ...
5
votes
0answers
360 views

safexl - A Python / pywin32 Excel Application wrapper

Thanks in advance for your interest in my first PyPI project. While there happen to be a number of projects out there to help with creating & consuming Excel workbooks, I was unable to find one ...
3
votes
1answer
79 views

Employee name auto-complete on card scan

Im currently running an employee name substitution on card scan. Overall the code takes the entry trough the gun scan, "scan" trough the hidden reference sheet to find a match and then input ...
3
votes
1answer
84 views

Workbook _open copy-paste reference sheet (30k+lines) from other workbook on change only

Working on finding a way to reduce in-cell formula size and memory usage of my excel workbook, i came up with the idea to "load" (copi-paste) the reference sheet i was mentioning a lot with ...
2
votes
1answer
66 views

VBA Sort-Compile-Write data from multiple worksheet on changes

I finished a code that sorts and compiles daily work data into a weekly summary. Its triggered by workbook changes so it refreshes automatically. Trying to respect "good code writing", and ...
6
votes
0answers
67 views

Shape Text Formatter Class a Builder Pattern

The preeminence is to have every method of the formatter return the formatter as a reference. This allows it to add and format text in chain. Such as: ...
4
votes
3answers
174 views

Excel Data Import and Manipulation

This code imports a list of equipment (around 8000), and then filters the errors and creates some lots for the processes that come next. The code is working, but I'm sure it can be improved, ...
2
votes
0answers
108 views

Copying Data from multiple workbooks -> Into One Worksheet (continuous data)

I have a macro created by my predecessor that I run on a monthly basis. However, it does take a while to get through, and I would like to clean it up for efficiency please. It copies data from ...
1
vote
0answers
117 views

Iteratively Exporting PDF Reports with Excel

The goal here is to notate and produce essential PDF reports. The For loop takes an id number and puts it into specified calculator worksheet. The workbook is set to automatic calculation so all of ...
2
votes
1answer
81 views

VB.net SQL match against Excel data to datagridview

I am importing an Excel sheet where the first column will contain product numbers. I match those numbers to my SQL database and display the product number and description of the matching products to a ...
6
votes
1answer
121 views

Creating a Chart Worksheet from scratch with VBA / OOP Design

I recently posted some code for review, and am now looking to gather some feedback on my latest implementation with that code. Yes, I have fallen into the OOP rabbit hole (thanks Mathieu Guindon) and ...
4
votes
2answers
131 views

A VBA Product Dictionary with a Collection of Product Services

I need to extract unique Product Group names along with its corresponding services from a table in a worksheet. The table is generated by a bot and is not filtered, I have sorted it by alphabetical ...
2
votes
0answers
49 views

VBA Excel loop with offset for extended range [closed]

Good morning, I've made the loop for the range, which is copied from one sheet to another. However I have no solution for trimming my code down, which looks like this: ...
2
votes
3answers
116 views

Getting Rid of .Find in VBA Code

I have a range of two columns that I want to search for a "key" and then find the corresponding value in the directly adjacent column. The key is stored in a dictionary that I populated ...
2
votes
1answer
184 views

Part 2: Send HTTP request for each row in Excel table

This script was previously reviewed here: Send HTTP request for each row in Excel table (Part 1) I've made the changes that were suggested in the Code Review answers as well as added a few of my own. ...
7
votes
2answers
1k views

Part 1: Send HTTP request for each row in Excel table

Update: This is an older version of the question/script. The new version can be found here: Part 2: Send HTTP request for each row in Excel table I have an Excel spreadsheet where users can batch-...
4
votes
0answers
608 views

Excel Chart - Crosshair cursor lines with VBA

Submitting for expert review. I am trying to create a Chart - Crosshair cursor in excel chart sheet. Chart - Crosshair cursor lines are two lines (one horizontal and other vertical) moving along with ...
1
vote
0answers
825 views

Excel to Json getting file data into state in React JS

I am using dropzone and XLSX to load excel documents and then convert them into json. The goal is to upload as many documents as possible and it will create an object with a key of the file name and ...
3
votes
1answer
128 views

COVID model using UVA data

I have built a COVID model using UVA data. Currently that data is unavailable so I'm using another source. The new source is, of course, a different format. So rather than refactor all of my model ...
4
votes
1answer
650 views

VBA function for array of RGB color combinations and procedure to color large number of cells with unique colors

Submitting for review by experts. Inspired by this question to color value cell having duplicates with a different color. So "Apple" will have one color for all duplicates. Then "Banana&...
2
votes
2answers
130 views

Auto formatting and auto validating TextBox VBA

So, I created a class to avoid all the work behind the validation of input in a textbox. The idea is to pass an existing textbox and a type of the desired content and the class will take care of block ...
3
votes
0answers
76 views

Setting a forecast for 2,5k workers intraday for a whole month

I'm working on a large project that requires a ton of data to be processed. I was thinking that using classes would be the best way, and it is, until it has to dump out the memory at the end of every ...
3
votes
0answers
142 views

Looking for more efficient VBA to Move data from Teradata to Excel

I have a simple macro moving data from Teradata to Excel. The process normally takes me 10 minutes to perform manually, however the macro can run for hours sometimes. This is making the macro seems ...
1
vote
4answers
105 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
79 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
36 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
60 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
66 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
118 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
38 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
2
3 4 5
22