macro

Hello, My excel is a master document that pulls in data from different excel sheets in different departments, each of which are all updated daily. I need to save the "master" excel once a week into a different excel with all the values pasted. This creates a weekly snapshot of the data as it is...

I have been using Excel for a long time but am very new macros and would consider myself a novice at coding even. I have been trying to write a macro to basically batch print multiple documents available in web hyperlinks. I'm not even sure if what I am trying to do is within Excel's...

Hi All - I'm looking to develop a spreadsheet which can collate all of the contacts that we receive as a team. We have developed a template page for each company/ organisation that contacts us. I'm looking to create a summary page which provides a line with each company/ organisation number and...

I wonder if any VBA experts can help - I appreciate this applies to MS Word. I found the following macro to remove square brackets. Sub RemoveSquareBrackets() Dim oRng As Range Set oRng = ActiveDocument.Range With oRng.Find .ClearFormatting .Text = "\[*\]" .MatchWildcards =...

I have a large data set that I need to set an increasing number sequence in column A based on the value showing in column D. i.e. The number in column A increases by 1 each time the value in column D changes: A B C D 1001 AX11172 ILC010377, VSC003830 ENT002281 1001 AX8170 ILC006062...

How do I make a macro to update the pivot table and keep the filter selecting all values except #N/D as in the images below? Thanks in advance I inserted a new row and updated the pivot table, but the value 20 should be selected in the filter

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...