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...
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...
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:
Source File Name
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...
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.
' Final Macro
Workbooks("Mobile devices report").Worksheets("Devices list").Range("A1:A10000").Replace...
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.
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
Dim FSO As Object
Dim oApp As Object
Dim Fname As Variant
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...
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:
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)
Dim n As Long
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...
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].
Since I added the time format the code stopped working, is there any way to include the time in the file name?
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"