macro - auto run

  1. A

    Looping the Solver function using Macros

    Sub Macro1() ' ' Macro1 Macro ' ' SolverOk SetCell:="$BD$8", MaxMinVal:=3, ValueOf:=0, ByChange:="$AJ$8", Engine _ :=1, EngineDesc:="GRG Nonlinear""" SolverOk SetCell:="$BD$8", MaxMinVal:=3, ValueOf:=0, ByChange:="$AJ$8", Engine _ :=1, EngineDesc:="GRG Nonlinear"""...
  2. A

    Automatically Merge data from a specific range from multiple sheets(avoid blank cells)

    Hi, I need help please! I have this code but I need it to work automatically. The idea is= I need to gain the data from the range "A6:W29" but only cells with data and to do it in every sheet except for "RESUMEN" "S.Inicial" and "S.Final". Right now I can merge all the info but running the...
  3. T

    Multiple Line Charts Based on DataRange Sheet

    I have 2 sheets in my excel file (Data and DataRanges). DataRanges sheet includes Start & End columns (multiple rows) which represent the range for each graph. The data sheet includes Data Serial which will represent data in serial for those ranges (start, end) to plot a simple line graph...
  4. H

    Running Macro on all sheets that meet cell criteria

    Hi, I'm trying to make a macro run on every sheet in my workbook, problem is macro doesn't work if cell value is 0: Sub Ola() Dim Rng As Range Dim InputRng As Range, OutRng As Range xTitleId = "KutoolsforExcel" Set InputRng = Application.Selection Set InputRng =...
  5. A

    macro run in multiple locations but uses the same file in the multiple locations ie the macro needs to select the file in same folder its in

    how do I add a Macro that will work with multiple CSV files of the same name. but only search the one thats in the same(file) location. as the spreadsheet using the macro normally you could use .\ to reference the same folder, but this doesnt work. any help would be great My spreadsheet...
  6. A

    Macro crashes with button, works perfectly if run line by line

    I'm using Office 365 and am importing data from an external database, creating a query as I do. I then have a macro that does some formatting and copies the table, without headers, to my main table. The code works perfectly if I open the editor and run it line by line. When I create a button to...
  7. jaeremata

    Compare 2 worksheets

    Hi Everyone, I need you help regarding with my problem. I don't know how to do it. I have 3 files, 1. Result 2. Files 3. Score On the result worksheets, I have a list of vendor including the path of each worksheets( Score and Files). What I want to happen is to find the latest date on...
  8. S

    Run a macro on save sheet

    Note: I'm too basic in VBA/macros... I have a macro that exports my sheet as CSV without leaving the XLSM file, that works great: Sub ExportCSV() Dim MyFileName As String Dim CurrentWB As Workbook, TempWB As Workbook Set CurrentWB = ActiveWorkbook...
  9. C

    How to modify code to update multiple workbook files which has the same format but different data?

    Hello excel programmers. I don't know if you can help me. Yet again, if you are comfortable to view the files below for testing. This is my concerned. I have a code for each of my workbook files below. (I have over 100 workbooks which has the same codes and excel layout, but different data)...
  10. D

    Macro used to send automatic emails

    I am using the Ron de Bruin macro to send automatic emails to various users and that is working perfectly. As below: Sub Send_Files() 'Working in Excel 2000-2016 'For Tips see: Dim OutApp As Object Dim OutMail As Object Dim sh...
  11. X

    Auto Populate Cells In A Table, Based On New Month

    Hi everyone! I have a table, with Monthly Expenses. Each Month should have recurring Expenses, and I don't wish to have to type the information every Month. If there's a way to automatically import the data into the corresponding cells in my table, it would be greatly appreciated! I have...
  12. T

    Running graph-creating macro through multiple rows

    Hey, I dont and cant use VBA nor any other programming language at all but need this thing for my work, so sorry in advance for my phrasing; I created a macro simply through "record macro" button in excel. The pourpose of it is to create a simple graph out of one row of a table. Now I need...
  13. T

    Need Macro Created for pulling info of files inside a folder

    Hey have a workbook called "Office Invoice.xlsx" What i want is to open a folder i have and go through each file and pull data from certain cells and put them in on the Office invoice file. We add 500 or more invoices in an excel sheet on that file for each year, and it auto update when they...
  14. MrDB4Excel

    Autorun a macro upon opening of excel file

    I am trying to get a macro to autorun when I open a workbook. I want this macro to run automatically as soon as I have selected the "Update" selection that appears in the "This workbook contains links to one or more external sources that could be unsafe." Obviously these sources exist only on my...
  15. B

    Excel to PDF Naming convention

    Hi. I have the macro below which upon running converts the active sheet in excel to pdf. Sub SaveasPDF() Dim wsA As Worksheet Dim wbA As Workbook Dim strName As String Dim strPath As String Dim strFile As String Dim strPathFile As String Dim myFile As Variant On Error GoTo errHandler Set wbA...
  16. G

    Automatically email based on cell value

    Hey all - I would like to create a macro that automatically creates an email for a group of people based on a cell value that's selected from a drop-down menu in a range of cells. There would only be 2 or 3 status options from the drop-down menu, but a specific group of people would be emailed...
  17. D

    Private Subs to run at opening a workbook

    Dear, I need to run automatically three events upon opening the workbook; it seems that when I put them together within the same sub, only one runs and by-passes the others. The first sub I need to run is to enter a user name, it should be enforced, otherwise to close the workbook. At the...
  18. A

    Macro for downloading files from website into excel

    Hi Community Members Is it possible to do a excel vba to automate the following? Initially, I was intending to record a mouse & keyboard movement macro, please advise :) Step1: Open a website URL and login using credentials (Username and Password) daily Step2: Navigate the website via a few...
  19. D

    Copying Data from one excel to another Matching Headers

    I have a few excel which has 23 columns and another few with 7 columns with headers which I get daily with new data. I have another excel which is the master excel where I have all the data updated. My master excel has only 12 headers and columns. The headers are not the same on the master excel...
  20. W

    Making a command button dynamic

    Hi everyone, I'm fairly good with google and fairly beginner with VBA. I've found a VBA command to return a "no data" message in a row I've assigned to allow customers I am sending this file a quick check on the validity of the data. I basically want "no blanks" back from the customer in...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back