excelvba

Hi All, I did an excel macro that will take the server logs from my outlook inbox and populate in excel sheet, in which my subject itself say on what date it ran, what job and the status(PASS/FAIL).Every thing is smooth here. But i wanted to take it further, for the failed emails we get logs...

Hi, Im fairly very new to VBA Scripting. i have a problem please find the below table Output column is Comments Name Comments Alert A1 Phone P2 Email Not started The comment column gets the value from the below table Name subname value Alert A1 1 Alert A2 0 Alert A3 0...

I'm new to VBA scripting trying to write a condition for the table, The condition is to take the fail status and loop through the same table and find if the appropriate ID has a pass status, if yes i need to delete the record, if no i have to retain the fail status. so my output will be i...

Sub Mail_workbook_Outlook_1() Dim UserInputToEmail As String Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0) UserInputToEmail = Application.InputBox("Enter your email id") On Error Resume...

Is there a way to take input(email-id) from the user and automatically mail the same excel sheet using vba code ? any help would be greatly appreciated.

Hello There, I want to copy the highlighted text from one column to other columns. There are two options. 1) Highlighted text is "BOLD" 2) Highlighted text is "COLORED" Ideal two separate solution each for "Bold" and "Color" If either of one is not possible then please give any one solution...

I have a data sheet that I input data from a user form. One aspect of the form is that as you finish adding the data and before you submit it to the data sheet a ID number is generated using the MAX function +1 in the VBA code which just increments 1,2,3,4. The user form is used to enter, add a...

Hello All, Please find below the raw data and pivot table My requirement is, If i select "India" in "ops_center" slicer, the chart has to show only the "Mgrs Name" for "India" center like below The same way, if i select "Australia" in "ops_center slicer, the chart has to change like below...

There are a bunch of highlighted yellow text. I want to merge rows e.g. 6, 7, 8 and 9 into 6. Similarly 17 & 18 into 17. So and so forth So the final output I want is Text URL Text URL Text URL Note: 1. This is sample file but it could have hundreds of rows with uneven rows to be merged. I...

The following VBA converts PDF file to excel. But i need some modification with it, At address A2 path of PDF file is entered and at B2 type is selected like .xlsx. When convert button is pressed it converts PDF to excel at same location. Now what i want with this code to be modified is that: 1)...

Hi all, I tried to ask from the original post by John_w, but am guessing that no one is watching that so...here goes. This code was originally posted by John_w back in 2019, and works beautifully, but had modification questions... How could this be modified to allow for two (or more) signature...

Hoping someone could help me out. I have 17,000 rows and I need to copy 30 rows at a time under the header and paste those rows on the worksheet named Page 1 on row 13 column B. Then create a copy of Page 1 worksheet, rename it to Page 2 then copy the next 30 rows, repeat the same exercise after...

I have two buttons in my workbook, they perform different operation by importing data from same workbook but different sheets. I want to combine this into one button, please help me with this. Button 1 Code is: Private Sub CommandButton1_Click() 'Sheets("RawDataChamla").Visible = True...

I have a workbook with different sheets, when i try to clear some ranges through vba code, it gives me error, please help me with this. Private Sub CommandButton5_Click() Range("B13:F13").Select Range(Selection, Selection.End(xlDown)).Select Selection.ClearContents...

I need to copy data from one sheet to another by following these conditions: 1) User should select/browse for a file, from the opened file, it copies data from column A to Column D from sheet1 2) Column A has unique numbers while column C & D has duplication, it should ignore duplicate.it...

I need a VBA code for a button which when clicked browse for other excel file, search for specific sheet named “Farmer History” in it. In this sheet it looks for A1 complete row and search heading “Crop Area” and copy this column data to main file(where button embedded) in sheet named “Berkhund”...

Hi all.. Is there another option in vba codes to compare 2 cells whether it is "TRUE" or "FALSE"? Because it didn't work if I'm using Application.WorksheetFunction.Exact() Thank you for your help.

Sub customercheck() Dim i, j, k, lastrow, lastrow2 As Integer Dim arr(), outputarr() Dim customername, kam, segment, unit As String Dim endurid As Variant Dim wb As Workbook Dim ws As Worksheet Dim target As Workbook For Each wb In Application.Workbooks If wb.Name <> "Offline Deal...

All...I found the below on this site, and it works beautifully, but... Was wondering if there is anyway to mod the code to filter two separate columns? i.e. First by Date, then by Name (Columns 15 and then 2) Any help would be greatly appreciated. This is a hard code sort...no checks, combo...

Hi, I have created a macro but puzzled on how to apply with three command buttons ( for neat look ). cmd button1: browses the main raw data file. cmd button2: vlookup data file for the main file. cmd button3: Run the macro on the main raw data file from cmd button1. your comments will...