help - macros

Hi Guys and Gals Bit Stumped on wraping my head round how to get his done but basicly am looking to make a macro that would look threw a list of unique code then delete any codes that are not on the list in a complete list The complete list of products looks a little like this(information...

I have two sheets. On sheet one, column B starts from row 6 with a list of dates. On sheet two, column D starts from row 2 with another list of dates. I am trying to create a macro that highlights the whole row starting from column D in sheet one if there is a match between the dates in sheet...

I have a pre-built Word form document that I use that has multiple fields that I fill out (customer name, dates, etc.). I usually copy/paste information to this document from other sources (Excel, Word docs, etc.). QUESTION: I need to create a way to automate moving the required data from...

Greetings, I have a macro workbook that was created in Excel 2016, however VBA was added to it in Excel 365. It works fine when opened using MS 365 however the users that will need the from/wb have 2016. When opened in 2016 I am receiving a !VALUE error in the cells that should be calculating...

Hello, I was trying to help my wife out with this code for her job. I've used Excel like 2 times ever so that doesn't help. My understanding is she has 2 codes that work individually but not when put together. From browsing other topics I see you can only have one function in a doodad. I don't...

hi there, i've been trying to get this excel to work with no luck.. attached below is 2 pictures first picture is the data dump that I update regularly second picture is a table chart that I am trying to get the data to populate from the data dump based on 2 factors: date of shift and team...

Hi everyone! I am relatively new to using macros and have been having some trouble using macros to compile data into a new excel sheet. My goal is to have a sheet that looks as follows: Item Name Measured Value Source File Name A X Patient1.xls B X Patient1.xls C X Patient1.xls A X...

Hello everyone! I hope you are doing well I'm working on a project and I need help please!! I have 2 sheets in my workbook Report and email.. The sheet "report" have all the data and sheet "email" have all the users email.. I would like the data shown in the report to go to the appropriate...

Good morning!! Can you please help!! I wrote this code but I keep geting error I want to assign this code to pacific sheet the sheet name is Devices names. Sub Final2() ' ' Final Macro ' ' Workbooks("Mobile devices report").Worksheets("Devices list").Range("A1:A10000").Replace...

Good morning!! Thank you so much for taking the time to help each other!! I receive a daily zip folder inside the zip folder another folder and inside the 2nd folder all the files I want all the files to go to documents. thank you!

Good morning guys!! please assist if you can!! I want this code to unzip the latest folder in Dir and copy all the files inside that folder to a different folder and open the bigest file in the folder Sub Unzip1() Dim FSO As Object Dim oApp As Object Dim Fname As Variant Dim...

Hi, I have just got a hang of macro but need some help with coding in VBA! I have a calendar with a lot of different activities placed in different cells. Let's pretend that my activities are A,B,C. The cells in the calendar (workbook A) will be externally referenced with data (dates) from...

Hi, I wrote a code in VBA for calculating the simple formula as gaussSum= [n*(n+1)] / 2, the number is given by the user. But the program does not perform the calculation it just gives me the number inputted by the user. How can I connect these two, so the program could take that number and then...

So i've been working on a little personal project for a better way to sort out my stuff in a game, what better way than to use excel, in my means to do this, i also wanted to make the excel super cool so i've ran into a problem i don't know how to solve because of my lack of knowledge on...

I have managed to get a msg box to pop up with the translation but really what I want is to be able to enter text into cell B2, press a button and have the translated text appear in cell M2. Thoughts?

So I made this macro to import a csv file from the downloads folder. I tested this on 2 different computers using the same version of excel. Both worked but when i sent this to the person I made it for they had error 5. I have the 2016 version of excel. And the other person has the 2013 version...

Hi, I'm trying to create a league tournament for a 10 deck vs. 10 deck card game. For each victory I fix the score of the duel and click on a button to launch the macro which will implement the different tables. I name my tables with the name of the decks. My question: I have 2 dropdown menus...

Good afternoon excel wizards, I am struggling here after not having used VBA in so long. I am working off of Rijnsent's amazing work that generates a crossword puzzle using excel and macros: https://www.mrexcel.com/board/threads/crossword-wordsearch-puzzle-maker-with-excel-vba.1125740/ I would...

Hi, I'm trying to learn a bit more about conditional statements in macros. Can you help me adjust my VBA code based on a condition in a different sheet? On sheet2, I have the following data on which I am running a macro (see code below screenshot) Sub MyMacro() Dim n As Long Dim lc...

Hi Everyone, I am trying to create a VB with very little VB experience. I would like the VB to create an email for each different email address that is on “sheet 1” with the data relating to their customer code if it has a ‘x’ in the send price advice code column. Each email would need to show...