excelvba

  1. M

    Extracting the content of Email Attachment into excel

    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...
  2. M

    Getting Key value from last occurrence of another table

    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...
  3. M

    Deleting Duplicates based on Active condition

    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...
  4. S

    .Send function is not working for by below code

    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...
  5. S

    vba code to automail user based on user input

    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.
  6. S

    How to copy the highlighted text from ColumnA to ColumnB, ColumnC

    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...
  7. W

    Create and Increment Numbers with Letter Combinations to make a serial number in VBA

    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...
  8. T

    expand/collapse pivot table based on slicer selection in pivot

    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...
  9. J

    How to merge rows so whole sheet shows “text” and “url” one under the other

    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...
  10. Z

    Modification required in VBA PDF to excel conversion

    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)...
  11. C

    Modifying code hat inserts Digital Signature BLock into PDF Output form Excel using VBA

    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...
  12. J

    Create Multiple Worksheets and Copy data from Raw File 30 rows at a time and Paste to Newly created worksheets

    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...
  13. Z

    Combining TWO buttons operations into ONE

    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...
  14. Z

    Clear data on two different sheets with different ranges

    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...
  15. Z

    Conditional Copy Data from One sheet to another workbook

    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...
  16. Z

    Search multiple headings(Columns) in other sheet, copy data and paste in main file

    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”...
  17. A

    Application.WorksheetFunction.Exact

    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.
  18. M

    subscript out of range issue. I have a workbook and I need to copy data from a sheet to another which already contains data in it of the same workbook

    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...
  19. C

    Sorting Multiple Columns in a Listbox

    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...
  20. W

    vba macro with 3 command buttons

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top