excel macro

Good Morning, I need some help from you guys creating a macro in excel/outlook. My excel spreadsheet contains details as under. Column A : Client names Column B : Outstanding Amount Column C : Due Date I want to create a macro which can perform as under. 1) Macro should take Client names...

Hi Guys, I am running macro which prepares report for me from excel and save file it in csv format at the specific path. Now my problem is that while saving the file, it give me pop up "xyz file named already exist. Do you want to replace it ?" Surprisinlgy, no any file exist with the xyz file...

Hello everyone, I have a macro set up that asks for a beginning date and an ending date, then scans columns J-Y for a date that falls within that range. If the macro finds a valid date, it copies and pastes the cell containing the date and the cell directly to the right of it onto another sheet...

Many thanks for reading this post. The column "H" in my excel spreadsheet contains dates. I require a macro which can delete entire rows if cell value in column H greater than today's date. Look forward to hearing from you. Regards, Xiou Lee

Hie, So basically i have created a Excel File in which random numbers are generated. In which A1 Input Value A2 Low A3High These are the input values and the result is random numbers generated between the Low and high value, B5:B13 has this formula =ROUND(RANDBETWEEN($B$2,$B$3),-1). and B15 has...

Sub Button3_Click() Range("B19", "B22").Copy Sheet4.Range("B" & Rows.Count).End(3)(2).PasteSpecial xlPasteValues Sheet4.Select Application.CutCopyMode = False End Sub I need only to copy the value of B19 and B22 on "Sheet4" B & C Cells respectively but when I use the above formula, it copies...

I need a macro that deletes all tabs not named "Address," "Phone Number," and "Birth Date" (there will are varying tab names depending on the report, so i want this macro to work regardless of how many and the names of the other tabs [if possible]. I would also like it if one of the above stated...

all data is in excel in A column need a vb were it search for @ in each cell and put { diameter before the email id vb or macro in a cell data is "August 5,2004" 06:16:00 PM tonytruex klblessed@hotmail com Chris Green rt 2 box 67 Fort Polk ga 94137 (310)639-4841 ("408,1263-3208 Anytime...

Hi, I'm a novice when it comes to Macros, and I want to be able to use a Macro to create random product SKUs in Excel spreadsheet format - any help would be appreciated. Thanks!

Does anyone know why this does not work? I want to set i and x as values that are entered into a cell. I then want to use i and x in the formula for calculating another cell. If anyone knows anything it will help out a bunch, thank you. Dim i As Integer Dim x As Integer i = Range(Y8).Value x...

hi i am looking to convert numbers to words need vb or macro output in the below formate <tbody> <tbody> Instructions On How To Enter The ANNUAL INCOME (In Words) $50,000 Fifty Thousand Dollars Only $50,250 Fifty Thousand, Two Hundr ed And Fifty Dollars Only $100,000 One Hundred...

Hi, I created a macro that copies a new tab into a new file and completes this new file from the one that it comes and after it finishes it saves this file. When this is over, I check the file and it is not linked, but when I close it and open it again it is linked to the source file (the one...

Hi, I am looking for a macro that will do a spell check on the screen when you open print preview in excel. Thank you

I created this macro to include a Drop Down Box in a worksheet, although I think it is a bit old-fashioned. Any suggestions to make it better? Option Explicit Option Private Module '--------------------------------------------------------------------------------------- ' Module ...

Hello...I would like to find a way in Excel to create a button that will copy from a textbox in an open MS Access form into an Excel field. Lets say for arguments sake the location of the database is C:\Test\Test.accdb, the form is called TestForm1 and the textbox is named TestTextBox1 and I...

Hi there I am using Excel 2007. I have created a macro which is creating power point slides and populating them with data from excel cells. the new presentation is using a template (which is actually a power point with an empty slide). This means my excel macro is opening the template...

Hi All Can anybody assist? I am new to macros so I have very little coding knowledge. I am attempting to set up a printing macro for my workbook which has several sheets. I have been searching the forums for something that would accomplish this to no avail. I did find this Macro which...

Hey guys, Trying to create a macro button that, when pressed, populates empty columns, based on a match between Part_ID in excel sheet called BOM and Part_ID in database table called materials joined with tables manufacturers and vendors The code is as follows: <code style="font-family...

Hello, I am new to vba progeamming. I am looking for a vba macro preferably in excel. It should pick up a file name (e.g.example)from one of the cells in the excel file add .pps extension and then look for example.pps file in subfolders on shared drive (L:\). If it finds the file then it should...

Hi, I have an excel with a column listed with URLs. These URLs would direct me to image files. What I need to do is only verifying if such image file exists. The problem I have now is: Whenever the image does not exist, the website would replace it with "imagenotfound.png", making me really...