macro

Hi All, I have list of 1Million contacts which contains Company Name, Contact First Name, Contact Last Name, Contact Full Name and Email address. I want to source another 100k contacts from the same companies but it should be unique contacts, should not match the existing ones. But i source...

Hi! I've been dealing with a problem which I can not find information about it. So what I want to make is a count of records depending on a criteria, I know I can accomplish it with WorksheetFunction.CountIf but let me explain a bit further. The problem I face is giving the criteria argument as...

I obtained the following macro using "macro recorder", however I need to replace the fixed locations with user input, as indicated. Sub Macro1() Rows("20:20").Select - (replace with user input 1) Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove...

Hi everyone, I would like your help on figuring out an issue I am facing. I have built a macro, where I need to format the source data and map it and transfer it to a template. One of the fields I have to map requires that I put an underscore and a number after the record, the number being the...

My local bowls club has asked me to create a spreadsheet to manage a ladder league. Having looked around I can only find a Google Sheets example that doesn't allow the flexibility we want or hosting sites which are either reportedly unreliable or again inflexible and not really the way we would...

I made this macro that will take a string of text (ex: Test.12048.210384.193287) from a scanned QR code in cell A2 and will perform a text to column function on the string to separate by a period delimiter "." to put "Test" in cell A2, 12048 in cell B2, so on and so forth with the text string...

Hi guys, I need some help. I have a file with a few macros, and it was everything working as expected, but today my excel started crashing and closing when I run one of the macros. I was making changes to the file, and the macro was working, but sudently, It started closing excel. The code is...

HI there. I'm trying to: Copy a range and paste it into another sheet (could I create one on the fly?) Then create a temporary workbook to copy the same information (could I eliminate the step above instead?) Then save the new file as a .txt file on the desktop with a specific name I'd like to...

Hi - is there a way to get the "AutoFillFormulas" property to be turned off for a specific column(s) in a Data Table? My table is called "Cash_Analysis_Revised" and I want the formulas to stop auto-filling just for that specific column. I tried the macro below, but I get the 438 error shown.

Happy New Year! I am working on my yearly calendar which is on one sheet. I usually manually change the cell color to match the month and then bold Sundays (attached is my 2023 calendar) but I have been trying to get into Macros more. Unfortunately, I cannot figure out VBA to change the...

I am using a VBA macro button to export a range of cells as a CSV file to the desktop. This file will be downloaded on multiple computers so I want the macro to save to the desktop regardless of which computer it is downloaded on. Sub seetest() Const CSVDATA = "B1:IG2" Dim ws As...

Hi, I want to allocate the financial accounts based on the narration string in the Bank statement, I have created one sample excel workbook with two sheets. There is a "Statement" sheet, which is the snapshot of Bank statement, I want macro or formula to read "Narration" column and pick-up the...

hi there i am using range() function in my macro with loop for next . part one of this macro the one take most almost 90% of time in this macro . Calculation in part 1 will happened after copying and pasting the new value as input . i have few questions regardsing this . 1-How to improve this...

Excel File Download Link I'm looking to generate a 2D line graph across multiple worksheets with varying amounts of row data. I need help creating the same type of graph depicted in an image for each worksheet. Could someone assist me in developing a macro code to achieve this task across all...

I have been running the same VB code for years and have not run into any errors where my macro enabled workbook performs a Save As, as a non-macro enabled workbook or xlsx. Now I get the error, "VB projects and XLM Sheets cannot be saved in a macro-free workbook." I cannot figure out what is...

Hi there, What could be causing the VBA code to malfunction on Mac? Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range, cell As Range Dim lastRow As Long, lastID As String Dim initialPrefix As String, newRowDetected As Boolean Dim existingIDs As Object...

I have a workbook that has a timer macro in it that will save and close the book after 2 minutes of inactivity. That works fine. When you have another instance of excel open, and you close the workbook that has the timer macro in it, the workbook with the timer macro will still save, you can see...

Hi everyone I have an Excel document with a number of sheets, of which I would like to combine SOME of these sheets into a consolidated sheet. I have picked up a few examples that combines all sheets in the document, but cannot seem to find anything that isolates say only some for the...

It's been awhile since I've created this macro and I'm having trouble. I have a workbook "Sales" with a worksheet "Names" that has 100 names starting in cell A1. I want to copy the name in A1, paste into a new workbook (it updates a bunch of figures), and save that workbook under that name. I...

Hello everyone! I was working in a macro where it will insert for me pictures from my C drive, however, I need to exchange the code to insert the same pictures from a workspace or SharePoint or website. I have tried but I was not success. please I need your help. this is the image address"...