loops vba

Hello! I currently have a Macro that creates an email for each row of data, then copies and pastes that row into the email. Each row is assigned to an individual (receiver of the email),, but sometimes, the same individual is assigned to multiple rows. I wanted to see if I could change up the...

Hi All I am writing a code in VBA to index and match against a date which runs in each column, and returns down each row. I can do this for each row if i write it for each as attached, is there a easier way so that it loops rather than me having to write multiple macros? ''' Sub test2() Dim...

I'm new to VBA and I'm trying to create a script that allows be to put a selected group of Excel files in a folder and do the following: 1) A pop up window to ask me which folder the files are in 2) Select all the files in the folder 3) Open each Excel file one by one 4) Upon opening the Excel...

I am trying to figure out how I can see if one cell is equal to another one on a different sheet, perform an action once that IF statement has been determined, and then iterate down one row on both sheets to perform the same analysis on the cells in the row directly below. Essentially what I...

Hi all, The goal of the script is to display an email containing one or more attachments and a screenshot of the details of such attachments for each one of the clients within a column. The attachments tend to be Invoices and a single customer may have one or multiple. As of now, I have the...

Hello all, I am new to VBA coding. I had taken a programming course almost 6 years ago and never touched it since but I would like to start learning slowly to automate a lot of my excel stuff. I have 18 folders at a particular location in my drive. Out of the 18 files, 12 are files with names...

<style></style>I need to know how to write a VBA function that includes a loop that prints "Hello" 50 times. Then create a button on tab 4 that triggers this function. Then save the function.

I am in the need of some assistance! I need to evaluate all the cells that contain dates in column R, to the end of the range….however, I can expect that there will be dates missing, where the end users hasn’t input an ‘Agreed CR Due Date’. I have accounted for the empty cells in the if...

Hi Guys, First time poster. Need your help. I've got about 500 excel that are in "C:\Test" Folder. I want to generate a macro that: loops through all the files in the folder For each excel file in the folder (1.xlsx,...) copy all worksheets into a new workbook with the same filename as the...

Think you can solve it? I'm stumped on a homework assignment with VBA. The question goes as follows.. Write a VBA program using For-Next loops to find out how much money you would be paid, if your starting pay was a nickel and your paydoubled every day for a specified number of days. Input...

How to loop through table rows and then the columns? I am new to VBA and what I am trying to do is to pull information into datasheet from user form, that enters 7 rows not 7 columns. Currently the code 'copy the data to the database With ws .Cells(lRow, 2).Value = Me.cboEmployID.Value...