We changed our privacy policy. Read more.

Questions tagged [excel]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
104 views

PCR analysis on data imported from Excel

I'm writing a program that is going to analyse some data imported from an Excel spreadsheet. It is currently running quite slow (couple seconds on an average machine) and I was wondering whether it ...
0
votes
1answer
87 views

Get data from Access SQL database with ADODB and weather data using web service and Excel VBA

This is a follow-up from this post. It all works, but I think the code could be made to work faster and to be more stable. I have made improvements and updated the code in this new question. ...
0
votes
2answers
121 views

Removing space and ChrW from cells in VBA

This code is working when a paste is done it will force the formatting to be the same as in the destination sheet and will remove space and ChrW from the cells as soon as the paste event is detected. ...
0
votes
1answer
174 views

Transferring information between sheets based on column headings

This function conditionally copies and pastes information from one sheet to another based on the column headings to standardize data before exported to SQL database. I am not an expert in VBA and ...
0
votes
1answer
9k views

Find a string in a Excel cell in the fastest way

I have to implement a "filter" in a Excel file which deletes/shows particular strings found in specified columns. I save the rows numbers that have to be deleted in a list. I have my filters in ...
0
votes
1answer
1k views

Excel table filling with EPPlus

I am making a tool to read 3 input files in CSV and then filling an XLSX file with the information from the CSV. I want to know if I am repeating myself and if I can make it better and faster. ...
0
votes
1answer
57 views

Excel sheets with employees and dates

I have more than 20 sheets in Excel and one main sheet (all programs with 200 names). Each sheet has a column with names and 24 months (Jan 18 to Dec 18, Jan 19 to Dec 20). Each sheet names is a ...
0
votes
2answers
60 views

Searching multiple Excel sheets for the cheapest item

I am creating an estimation tool, where users can input part numbers and quantities, and the tool will output the lowest cost for that part number based on searches through multiple databases. I ...
0
votes
1answer
306 views

Class Module of Table properties, Record Table HeaderName and Column number to dictionary

This code creates a class module that record headers in to a dictionary which then allows for copy and paste data from another file where by the headers match. This helps to create a more dynamic ...
0
votes
1answer
105 views

Generating output comment for 70000 rows

For traversing 70,000 rows (using a for loop), my macro is taking a lot of time to give output comment as per various conditions (...
0
votes
1answer
135 views

Macro that combines data from multiple worksheets

I have created a macro to combine data from different excel sheets into one final report. As it is obvious from the code provided below, there are very clear steps in the code. The code has no issues (...
0
votes
1answer
698 views

excel vba code for a report generating then save & open in pdf

I am pasting here my working code which generate report in worksheet then save it in pdf format then open it in pdf after selecting a name from a combobox in userform then press commandbutton1 to ...
0
votes
1answer
137 views

VBA code which creates a daily report, based on data gathered in Worksheets in an Excel Workbook

I'm looking for some enlightening, since I'm still learning to code in VBA. I'm running code to create a daily report. It has to compare dates and check certain values in those dates and based on that ...
0
votes
1answer
1k views

Excel VBA Filtering: AODB vs Autofilter vs SQLite

I have an Excel sheet with data in about 100,000 rows, 16 columns. I have to extract data (one value from the 1 row I find) from this table a few thousand times. I have been using Autofilter to ...
0
votes
1answer
88 views

Create a table of errors in ActiveWorkbook or ActiveSheet

I've been working on a large spreadsheet that has many errors as options get changed and I needed a better way to know what was erroring to mitigate them. I recently learned about DI (Dependency ...
0
votes
2answers
51 views

Create Lists for Drop-Down Menus in Different Sheet

I'm currently working with a workbook utilized at my work that has the following code. It currently takes about 10 seconds to complete, and needs to be executed several times throughout utilizing the ...
0
votes
1answer
265 views

How to check if workbook not corrupted

I have asked this on the main stackoverflow.com site, but I have been redirected here. My problem is, how to check, if a workbook that is downloaded from sharepoint is not corrupted and can be open. ...
0
votes
2answers
280 views

Collecting data from General Ledger accounts lines

I have a pair of General Ledger accounts to scan for data. I need to find a keyword or phrase from the descriptions and then collect certain bits of data from those lines. The source tables (there are ...
0
votes
2answers
3k views

VBA- Retrieving data from an access database by referencing a column in excel

I am not able to run the for loop when number of rows exceed 8-9k. Can you suggest an alternate method for this? can you suggest the syntax to referencing the data using a tablename(or column name) ...
0
votes
1answer
533 views

Compare Sheet1 and Sheet2 for every match and then write them on Sheet3

I have the following code ...
0
votes
1answer
44 views

Search a Workbook, Then paste results on Search Page.

I posted this earlier this week, but I am finally done with it, and I am submitting it tomorrow. I wanted to get a final opinion/review from anyone on anything that could be refined. This code ...
0
votes
1answer
956 views

VBA faster calculating

I'm newbie in VBA world. I have recently work with a spreadsheet with over 25000 rows and about 50 columns. Every time I calculate this sheet, it takes about 30 minutes to 1 hour to perform the ...
0
votes
0answers
9 views

PRINTF LAMBDA function in Excel with ParamArray arguments - no VBA

The TEXTJOIN function has a really nice interface: =TEXTJOIN(delimiter, ignore_empty, text1, [text2], …, [text252]) ... where ...
0
votes
0answers
28 views

Creating Pivot Table taking time at average vales

I have created a VBA macro to create a pivot table automatically. But taking 15 to 20 minutes of time to complete the macro. Especially at the point of below code taking half of the time. Review Code ...
0
votes
0answers
27 views

NIQE score and PIQE score calculation for batch of images in Matlab

There are some image quality assessment methods for "no-reference" image quality analysis. Here, I am attempting to calculate the NIQE score and PIQE score for batch of images in Matlab. The ...
0
votes
0answers
43 views

Fastest Way To Compare 2 Excel Worksheets And Output Differences To 3rd Worksheet

I have a workbook that loads in the results of an SQL query into two worksheets called Old and New. The New worksheet is then edited by an end user. Rows can be inserted, deleted and values changed. ...
0
votes
2answers
70 views

Improving Speed of VBA Code - Copy/paste two sets of variable, Excel does a calculation, returns a value then copy/paste the output value

I am attaching the code here. I am very new to VBA and trying to do a complex calculation using Macro. Please help me improve the speed of the attached code. The code works fine and produces the end ...
0
votes
1answer
107 views

Improvement for generating excel with many data

I have the problem, my methods become slower and slower after many data. My methods can generate 100 rows with 20 columns around 1-3s, but after that my methods become slower and slower. And for ...
0
votes
0answers
31 views

Calculating total payment value between date periods with different pay frequencies

For this problem I originally wrote some VBA code which worked perfectly. I've since been tasked with integrating the results it produces with the spreadsheets data model so thought a PowerQuery would ...
0
votes
0answers
88 views

Performance issue “not enough memory” Macro vba Excel - Parsing data

I have built some code that should parse the data according to a unique value and then create a new Worksheet for each unique value. My initial table has 10 Columns and around 25K rows. The code works ...
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 ...
0
votes
0answers
34 views

Performance of ID's checking between Access and Excel

I want to increase the performance of this code: ...
0
votes
0answers
72 views

Can Excel Vba code be updated via an Excel Add In for multiple users

I have created an XLAM file called "MyCustomAddIn" from an XLSB file called "Call Tracker" which contains all my Subroutines, Functions and UserForms. I have referenced "MyCustomAddIn" inside of "Call ...
0
votes
0answers
647 views

Excel: read data into ADODB recordset

I wrote the function below, but I feel it could be improved and so I am open to your wise suggestions. The use case for this is to manipulate Excel data. As a freelance dev, I cannot always choose the ...
0
votes
0answers
49 views

Looping through table rows and replacing key terms in a word template

Here is my code for a sub which does the following: read header of a table into an array reads first row of said table into a 2nd array loops through the first array and replaces the marked ...
0
votes
0answers
115 views

VBA processing multiple files

...
0
votes
1answer
87 views

Copying ranges from multiple Excel sheets into a main sheet

I have a VBA code which copies same data from Multiple sheet and then paste it in "Main" Sheet. It then auto fills the blank cells for values from above and then it delete all the rows Where H:H is ...
0
votes
0answers
38 views

Program that uploads and process excel files current limit is 20,000 lines

My program is called "Cleaner". What it does is that we have a "Dirty" excel file with a good number of lines in it around 20,000 - 400,000 lines. The process of cleaning the records is basically ...
0
votes
1answer
5k views

Convert Excel files to CSV

I wrote the following script to run through several excel files and format them before saving as a CSV for upload to a Quickbase app I'm creating. Each excel file is roughly 100k lines and the code ...
0
votes
1answer
158 views

Retrieve, remove duplicates and total ingredients into array

first time second time Note: The input meal is data verified - it cannot be something that doesn't exist on the lookup sheet. The sheets are all named, as are the named ranges. An (Excel) user ...
0
votes
1answer
79 views

Iterating worksheets and cells, copying data to summary sheet

I have been working on this particular sub for a while and it was very very slow from the beginning. Compared to my other subs that go through a lot more data the task of this one is almost minuscule. ...
0
votes
1answer
99 views

More efficient way to narrow down a range

I need to get data from a spreadsheet where there are three parameters. A product ID which is multiple rows, within the rows of product ID, there is another set of rows with the charge type, within ...
-1
votes
2answers
104 views

Clean up VBA search

I have code that is identical minus two changes that would happen each time, which I can use variable for, but I don't want to use a bunch of if statements. ...
-1
votes
3answers
92 views

Populate array with random numbers efficiently

I have an initial Excel workbook with about 100 000 rows. I put those rows into array and then use that array to create Client ...
-1
votes
1answer
71 views

Standardize and reduce repeating same procedures in my coding Excel VBA [closed]

I am aware that my VBA code can be improved.I would like to standardize and reduce repeating same procedures. Can I have some guide lines for this? Where to start? I would be glad to have some ...
-1
votes
1answer
115 views

Changing Excel configuration

This contains some complex logic and it's very difficult to provide all the things here. My intention is to simplify the loops, variable naming, and other stuff. I am thinking about splitting this big ...
-1
votes
1answer
63 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 ...
-1
votes
1answer
261 views

Increase the execution speed of VBA macro code

I am providing you with the code of my macro and hope that somebody can tell me what is making my macro slow and provide me with a solution as to how to make it run faster. Currently the execution of ...
-1
votes
2answers
90 views

Code iterates through all rows and inserts value in cell for each

I would like that this code would now be done in a faster way: ...
-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 ...