vbacode

I have a simple code to draft emails to different sub-recipients. This is a draft closeout email and I would like to include the dollar amount of the check they need to send back. The $$ check amounts are in column B, rows 2-43. Column A has the sub-recipient name. The code below works great...

I have a form where information is being from a form is being added to a sheet "Database". How can I add to the current VBA and have the the same information added to the "Database" sheet on the Active workbook and another workbook "WF Manager-Database.xlsm Sheet "Activity Database". Code below...

Create a sub that records in a list how many times you pressed the return key in the current session (it should write on a new line each time you reopen the file). It should also record the files opening date and times on the same line.

I am working on a sheet where we are tracking a person by the number of issues during the year and the reason. I have included an example spreadsheet. Columns A-C will change depending on what is found during the review, but Column D has three options to choose from. Once a row has been updated...

Hi Everyone, I'm working on a project and am new to VBA. I've followed tons of tutorials online but I am stuck trying to delete a row in my table based on a selection made in a listbox within a user form. The purpose of the userform is to collect data on reallocating medication that was taken...

Hello everyone, Last year I received help in creating the code attached. My export changed and now I need to update the replace parameters, however, are there limits to what can be replaced? I'm trying to replace an entire paragraph with a simple 'Y' but I keep receiving a 'Syntax Error' when I...

Hello, I would like to move rows from one sheet to another, depending on the content in Column Z. The value for go-ahead is "0" (as this means there are 0 blank cells in the row). I have managed to move my completed rows from "Complete" to the next available row in "Archive". This pasting into...

Hi Experts, I have a workbook which has multiple sheets (around 150 sheets). I also have a list of names of all those sheets. Now what I want to do is delete few sheets (may not be in sequence). Can I delete sheets by their name? VBA code would be in a way that when I execute it, it asks me a...

Can some one help me with a VBA code that gives distinct count of data in in "I" Column of sheet1 (dynamic) after filtering "Temp" and "Tem" in A column and "MX" in E column. I have a code as below which gives distinct count from "I" column but not able to add the filters. Would be great if get...

Hey guys i'm trying ot get this macro in which i can call many other macros within it, sort of like a master macro, but i keep getting the problem of expected variable or procedure, when I compile to see any errors. I don't know, this may be due to how extensive all the other macros are. Any...

Hi All, I have a sheet in which I have 2 images within a cell to the left (A4) and a product code in the next cell (C4). I have to screenshot cell A4 and save the file as the product code in C4 (another program uses this data so they have to be saved in this format). I’m currently using the...

I am creating a break calculator which will help user to keep a track of his login hours and break time. I have already created a the excel file Please find below the format. <colgroup><col><col><col><col></colgroup><tbody> DATE 08/01/2018 Login Time 09:30:00 Logout Time...

Hello, I have two set of data: First data set: This data set contains monthly base cash flows for a project: <tbody> Month 1 2 3 4 5 6 7 8 9 10 11 12 Cashflows C1 C2 C3 C4 C5 C6 C7 C8 C9 C10 C11 C12 </tbody> Second data set: This data set contains business...

I have list of Tables and their field names in sheet 1 like below Table 1 - T1 Field 1 - T1 Field 2 - T1 Field 3 ... Table 2 - T2 Field 1 - T2 Field 2 - T2 Field 3 ... Table 3 - T3 Field 1 - T3 Field 2 - T3 Field 3 ... In sheet I have drop down which will populate all table values (Table 1...

I NEED TO EXTRACT DATA FROM 3 DIFFERENT SHEETS FROM 150000 FILES ONTO A SINGLE NEW WORKBOOK. FIRST SHEET IS 'INFO' I NEED 'B9' 'B11' AND 'C2' SECOND SHEET IS 'fSC COMM' RANGE 'H9:H79' THIRD IS 'PCF COMM' RANGE 'H15:H84' THE MASTER WORKBOOK NEEDS TO HAVE THE FILE NAMES AS FIRST COLUMN AND EVERY...

Hi, I am absolutely new to the world of coding and I need a simple code to do the below: Open up files using data import from csv, (however many there are) and save files as xls. All files are saved in a central location. Can anyone please help me with the code? I have to open up so many...