macro

I am trying to apply the following conditional formatting to a macro. It is creating the formulas and applying them to the correct range, but it is only setting the format for the first formula. Any ideas? This is my code: Sub CondishFormatMulti() Dim MyRange As Range Set MyRange =...

Hi, we want to transpose some data from multiple column, is there any option to do it Query Table CodeAmountQty123456789101234567891012345678910807808824793812109113165266101112118081131SD-DE-16853808125901132428661651 Result Table...

Hi, we have the following sheet where we want to split in row wise instead of column wise, can we do this from macro or any formula, its a large database query sheet...

Hello. Please help me if it is possible to do a macro. I have a list in Column A1-1000 and I need to search one by one from a website and then based on the result, I need to copy the result under the second table and paste it in my Excel file (maybe in another sheet). Here is the example...

Hello Everyone. I have a file which will contain a different amount of rows and values and i want to be able to click a button (macro) which will look at the numeric value in column L and depending on that value it will create and copy the whole row. Data before...

Hello! I am new here and I hope you can help me as I am a noob when in comes to macros. I have a macro that I want to create that can list down all the file name and the file path of each item inside a folder. I also want this macro to list the items inside a subfolder. Note that there is also...

Hello. New to this board. I found some code that compares two worksheets (sheet 2 with sheet 1) to determine if there are any differences in the rows. The code works perfect for highlighting the entire row. If there is a difference in the row on sheet 2, it is highlighted in red. Instead of...

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