help - macros

  1. S

    Excel to Word

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

    Works fine in 365, !VALUE Error in 2016

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

    Noob Questions.

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

    auto generate from data dump?

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

    How can I post sources file name next to source data pasted into compiled workbook

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

    vlookup match data and send an email

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

    delete duplicate data in the same column

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

    Open the zip folder and copy all files to documents

    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!
  9. M

    Unzip a folder and copy all the files inside the folder to a different folder

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

    Macro to move cells from one column to another column based on value from cell (Calendar)

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

    Perform Calculation in VBA

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

    Quite a Complex Request

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

    Looking for VBA that by clicking button translates English text from one cell (B2) and pastes French translation in different cell (M2)

    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?
  14. A

    Runtime error 5 on older version while importing csv file

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

    How can I code VBA with named table

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

    Help Needed for Word Search Creation - Challenging

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

    Help with IF statement to VBA code

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

    VB help -sending email with multiple rows to multiple users changes

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

    Iferror(Index&Match&Match) formula

    Hi all! I currently have a large worksheet that is similar to this: With the master data looking like this: I want to create a sort of IFERROR(IF(INDEX=0, ,MATCH and MATCH formula (with an iferror that returns "" (blank) if there's an error)) for every column with [] such as [DATE]. So...
  20. K

    Can anyone tell me why my file isn´t save with this code?

    Since I added the time format the code stopped working, is there any way to include the time in the file name? Code: Sub SaveAsPDF() Dim FilePath As String Select Case MachineName Case "A4", "A8.1", "A8.2", "A8.3", "A12.1", "A12.2", "A12.3", "A20.1", "A20.2" FilePath...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top