macro

I have a spreadsheet in which the user will enter data in Column A. Every time that data is entered, I need that data to be stored as a string "Asset" for additional steps. I cant get this to work: Private Sub Worksheet_Change(ByVal Target As Range) ' Check if the changed cell is A1...

Hello, I am trying to come up with a function or a VBA macro that is able to automatically update a cell with the next days date (based off previous worksheet) on the newly copied shoot Example: make a copy of the current worksheet (Sept 8), but the date in cell B1 updates incrementally to Sept...

I've got 2 macros that would run one after another (A4ResetFormulaOnBlankRow, then A5ClearToRight), but the problem is the A4ResetFormulaOnBlankRow macro runs really slowly when I've got 5000+ rows of data. If there isn't many rows of data, there isn't really a problem, but I'm working with lots...

I don't know why it's not working honestly, I assumed it was in case the cell has no value or is blank and that's why it won't run but I'm not sure. Posting almost my whole script because I'm not sure if it's really the sumValue that is the problem or did I break a rule somewhere: sumValue =...

Hello, I recorded a macro just clearing inputs in my file that I'm working with and I've inserted a button onto the sheet and done the 'assign macro' step but it doesn't run my macro. I'm not getting any error or anything, the button does nothing. The macro works if run it from the 'View...

I need to compare two sheets (Sheet 1 titled Client, Sheet 2 titled Advisor), each with a table with identical column headers and first column. The first column has the property names, and the additional columns have the information Fields about those properties. I would like the Macro to...

Hi everyone, I appreciate everyone who takes a moment to read over the problem I'm trying to solve. The image below is a list of 10 records that equal a total of 4 sets of "Washes". Problem: Humans have to manually identify washes and remove from "Master" Sheet. We currently have to highlight...

Hi All, I have been stuck thinking of a way to implement a "Sanitise Sheet" macro for one of my template and was hoping to crowdsource a couple of ideas. The mission, should you choose to accept, is to have a macro assigned to a button which creates a new .xslx file of a tab, which...

Hi all, I have the below code which saves the current worksheet as a PDF file and then sends the worksheet out, but I would rather it send the PDF, can someone help? Thanks, Karl Dim OutApp As Object Dim OutMail As Object Dim saveLocation As String Set wb1 = ThisWorkbook saveLocation =...

Hi all, I have a macro that will send an email automatically, but I can't get it to include the CC. I am guessing I have to "get" the value in Worksheets rather than just set it :/ Any help greatly appreciated. Sub A2_Decline() Set Authoriser1 = Worksheets("Process").Range("B5") Set...

I would like a macro that will jump to the referenced cell within the formula of the active cell. The active cell and referenced cell could be anywhere within the current workbook. In other words, if Sheet 1 Cell A1 has the reference formula ='Sheet 2'!B1 in it, and assuming I have activated...

I would like the following code to create a duplicate window, tile these windows vertically, follow the reference from the originally selected cell, then select this cell's referenced cell in the second window. Everything seems to be working correctly until the last line of code where it will...

Hello, I am looking for a Macro that I can use to print a PDF: 3 tabs document, but print 1 time Tab#1, "n" times Tab#2, and 1 time Tab#3, where "n" is a cell in Tab#3. Hope someone can help me with this request. Thanks, AR EDIT: The output should be just one document

Good afternoon, I need help to develop a macro for a button. I have an SS where i paste in a string of text to cell A1 for example HLX/DBI/123456 Bloggs, Mr Joe I have a button and macro that removes the forward slash /, the spaces, the comma and full stops and replaces them with an...

Good morning all, I am working on a macro for a spreadsheet that has 20k different rows. To make it easier, I am trying to see if I can build a macro for it, but this is not my strong suit. My end goal is that if I input values to look up, and it finds a matching value, I want to pull the data...

Hello all, I have created a production spreadsheet for work and and have set it to automatically print everyday of the month. The below is the macro that I used for this (stolen from Google) Sub meddaydate() Dim d1 As Date Dim d As Date Application.ScreenUpdating = False d1 =...

Dear, I hope your day went well! I need help in writing the one VBA to create an automatic email for monthly KPIs updating across all departments with the live Excel file (link file), and I want to send a separate e-mail to each proponent with its live link so they can update their inputs...

Hi, I am using this code to fill a selected range of cells with zeros if they are blank, the thing is that this code fills the blank cells one by one, and could take some time to finish. Can you help me please modify this code so it fills blank cells from a selected range all at once...

I am working on a Spreadsheet for work for the safety checks we do every 15 minutes. I have it completed all except this last part. I need help with a Macro or something so that each spreadsheet opened will autosave using a different filename with the date of the spreadsheet autosaved in the...

Hello, I was using this macro for a form and one day, it stopped to work and I got the error 91 The thing I don't understand, i have this error only for lines in bold and red. Does someone have a solution for this please ? Thank you ! Sub Save_SharePoint_A_Initiation() Dim Leader As...