vba macro excel

Hi Team, I want to extract outlook emails data in excel using VBA according to specific words in subject of email. The subject of emails keep on changing but some part of the subject remains same of all the emails. eg. My email Subject is "Prod - Work Daily Alert for user Steve Johnson...

Hi, I am currently working on returning multiple values from large excel data base. The headers of data from A1 to J1 - Figure- Gross - Net - Exchange -Amount - Transaction id - Ref. id- Recipient - Date - Type And all these containing the data upto 400 rows. The header FIGURE contains data...

I need help with my macro. I've got a table of data A1:R35 in sheet "Active" and when the value in column R is 100% and you press this button I want it to copy and paste that whole row into the next available row in sheet "Completed". Here is my current Macro: Private Sub...

Hi, I would like to alter the below code to include saving the file as an excel as well as pdf into the folder... Additionally, I would like for there to be a hyphen and spaces between the cell values for file name if possible: Sub SaveAsPDF() Dim fName As String With ActiveSheet fName...

Hi, I have a workbook with 4 spreadsheets- Finance1, FixedFee,T&M,Basic. I need to copy columns A&B from Finance1 from to the supporting spreadsheets based on the Type in column C ( FixedFee,T&M,Basic)- fixed fee would be copied on FixedFee tab,T&M on the T&M tab and Basic on basic tab. I...

I have a sheet with 1500 rows and columns from A to EZ, each cell contains the data are very diverse. I want to use VBA to find each cell that has the sign "/" and if found "/" will add the letter "cm:" in front of the cell contents. example: cell contents "cigarettes/marlboro" to...

I want a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0)...

Hi, I have a sheet containing duplicate employee ID in column B. So what I would like to do next is to delete those duplicate entries (by row) and will just retain the last entry in the sheet. Row Column A Column B Column C Column D 1 PHMBIA Maricel A. Chemical...

I use this VBA in a macro. Excel2016.: Option Explicit Sub LastRowWithData() Dim lastRow As Long lastRow = ActiveSheet.Range("E" & Rows.Count).End(xlUp).Row Range("Control!B2") = lastRow Range("J1") = lastRow End Sub The debugger indicates that the red highlighted row is the problem. I can't...

Hi all I need your valuable expertise in modifying/tweaking the below code a little bit to make it work wonder. From below, myCell is a range of values containing the name of the files to be saved got produced out of this macro. Instead of providing the fixed path/folder to save produced...

Need help with a code that will copy data from one spreadsheet that contains only one worksheet. (this is a CVS file exported daily from our software) and paste it into another spreadsheet that has multiple worksheets to a specific worksheet within that spreadsheet. I need a code that will...

Hi, I want to create VBA Macro code to create a drop down list in sheet. and values of that list are copied from another sheet. It should be dynamic code. Values to be copy are not constant. they are increasing often.

I need the Macro VBA code for the below scenario Sheet 1 of the excel will have data from column A to F. column A will have vendor number. Column B to F will contain the data related to that vendor it could be multiple lines of data. sheet 2 will contain the vendor number in column A (Same as...

I have searched through several threads already posted and some of them "touch" upon what I have trying to do, I try out some of the suggested solutions, but nothing seems to work the way I need it to. So let me start off by explaining what I am "trying" to do. I have to track employee...

Hi Guys, I need a small help from you guys, I have a excel file where i am importing data from different files. What i need is to delete the whole row when the user write "Done" on the last column called 'AT'. Like this: Name ID Status Abdul 1 Done Rag 2 Done Roh 3 Undone Zai 4 Done So the...

i am working on a macro that will transfer the data from multiple workbook files with differents worksheets to one work book with 2 worksheet Example Like i have 3 workbooks as (A)sales order with coulmn (1.)orderno (2.) orderdate (3.)shipto (B) shipment (1.)shipmentdate (2.)quantity...

<tbody> Sr.# Account ID/ Name & Address Book#/ Meter # Bill Due Arrears/ Security Payment/ Total Due Old Acct ID Page# Date/Current BillL Month Held Date 1 4934891512 MR KASHEV KUMAR S/O JASHEN 000 GN26189255 07-May-12 5,423.54 1,500 5,740.00...

I wrote the following VBA macro that cycles through different border formats each time a unique keyboard shortcut is pressed. It is supposed to progress from a thin solid bottom border, to a thick solid bottom border, to a double-line bottom border, then return to "no border." It works as...

Hello, I am trying to make a pie chart that will have a variable number of items. I am trying to make a dynamic range. ActiveChart.SetSourceData Source:=Sheets("Sheet2").Range(Sheets("sheet2").Range(Sheets("sheet2").Cells(2, 5), Sheets("sheet2").Cells(1 + eunval, 5))...