macro - auto run

I'm pretty clueless when it comes to coding and need some help with this excel file. I'm trying to insert a code that will move an entire row from sheet "Ordered" to sheet "Invoiced" when yes is selected from the drop down list in column M. I'd like it to not leave any blank lines on the...

Dear Friends, Please help me to solve the following task: DataTable <tbody> A B C D E F G H I K SomeName xyz xyz SomeName xyz xyz xyz xyz MyCell SomeName a xyz ? xyz 12 SomeName xyz ? 23 ? 3 ? 52 ? 85 SomeName Z ...

I have a Macro that creates a SheetList and then resizes the named range of the List based on the sheets in a work book. The Code works great when I assign the Macro to a button. What I want it to do is run when I select Sheet 1 ("BOM") but excel fails and closes out the application. Here is my...

My code: Private Sub worksheet_followhyperlink(ByVal HL As Hyperlink) Dim linkReq As Object Dim linkStatus As Integer Dim sourceCell As Range Debug.Print HL.Address Application.EnableEvents = False linkStatus = 200 If Dir(HL.Address) = "" Then linkStatus = 404 If linkStatus = 404 Then...

Hi - I'm working on a project, where barcode reader is used read the barcode containing the filepath into A1 cell of a excel spreadsheet, an automation is required to open a the file of the filepath in a application(GerbView), when again a different barcode is read the opened file in the...

Hello, I am still a beginner to macros and learn quickly by reading forums on other's experiences with running macros. So let me explain what I am trying to do and I believe I am failing miserably. I am wanting to get the macro to copy the date from sheet 1 and paste it is cell A1 on sheet two...

I've been looking on forums for the last couple of days and could only get so far so here I am all signed up. My goal is to automatically send an e-mail if a figure drops below zero. I have got as far as knowing I need to set up a macro and that I need some code to activate the macro. I...

Hi I'm trying to run a macro based on another cell value. I simply want to hide rows based on a dropdown value from another cell. Is this possible. I have working code that is hiding rows, but it is not being triggered when the value is selected I have to manually run the macro. Could someone...

Hi Everyone, I am trying to create a code that adjusts to a changing range. In the second to last column I am trying to sort data (A to Z) that changes every time. In the last column I am creating group numbers based on the second to last column. The amount of rows and columns can change based...

Hi guys, often I have data like the following: rose Lilly tulip and I need to autofill the cells in the column (got thousands of names and the position of the names is always different) so I have been double clicking at the lower right corner of the cell every time but it's time...

Hi, I need help. I have 2 different workbooks. Workbook 1 and 2. Let's say when I double click on any cells in range c:c and it will 1. Open IE 2. At the same time, direct user to the sheet (it will copy the cell value on the click cell to another workbook and activate the sheet.) Right...

Hello, I am a first time poster but have used a lot of these threads in the past in increasing my excel skills. I am using Excel 2016 on Windows 7 Pro. My question is how can I get a VBA macro to activate upon either hitting enter or leaving the cell? To provide background in what I am...

Hi, I currently have a worksheet that changes range and zoom when opening on different resolutions on different computers. How can you have a script that automatically resizes all worksheets to the same cell range when the workbook is opened? Many thanks

hello i have developed code but it shows a run time error can some one please advise whats is the issue Private Sub CommandButton1_Click() Range("A2").Select While Not ActiveCell = "" Mail_To = ActiveCell.Offset(0, 0) Mail_Subject = "testing" Mail_Voting = ActiveCell.Offset(0, 4) Set myolapp =...

Hello. I need my macro to automatically multiply the value I enter in the cell (by *9.81) and to return the result to the same cell. I have gotten this code, but I can't set the Range of my macro to work in. I would like this macro to work just in columns BH:BJ, BM:BO, BR:BT, BW:BY, CB:CD...

I am working on a process to remove inactive users from a system that we are trying to automate. The problem is we decided we want a 30 day buffer on deleting users and our current system does not make that easy. I can export a list of all inactive users ever and a list of users made inactive...

Hey guys, I have a macro that I want to keep doing over and over until I change a the value in A7 I have worked out the action of the Macro (rotating pages) But I am stuck with the Do While Here is my code, thanks in advance for the help Sub Rotating()Application.OnTime Now +...

I need a goal seek to run every single time the value in cell F1 does not equal zero. When this cell equals zero, that means my numbers tie, if it does not then I need to create a "plug value" to make that value in F1 equal zero. The cell that needs to change is cell D21. When doing a manual...

Hi everyone I am having problem with a vba code. I design a form, coded everything and it seems to work fine. When opening the file, the form is launching and excel is hidden. my code is: Private Sub workbook_Open() Application.Visible = False FrmRapport.Show End Sub It all works fine if I...

I am doing right now the Daily activity report of our team and I need to consolidate and track the time stamp of each activity. My problem right now is once they filled up the activity with timestamp and after entering to a new activity, I would like to protect or not able to edit the previous...