abc

<tbody> To Subject Content abc@email.com; 123@email.com ABC - 1 Content 1 abc@email.com; 123@email.com ABC - 2 Content 2 </tbody> Hi, i found this code but it only work for email but not suject & content Sub SendEm() Dim i As Integer, Mail_Object, Email_Subject, o As Variant, lr As Long...

This is hopefully a simple one. How can I count records based on criteria? So it would be a count of 'Active' ('Status' Field) for each 'Group'. I'm looking to go from something like this: <tbody> Group RecordID Status ABC 0001 Active ABC 0002 Closed ABC 0003 Active DEF 0004 Active...

Hi Expert, Apologies for consuming your valuable time. I have a large Data base which is showing with Month as well as client. (Following example Month, Client and amount) I want to show to use another sheet as voucher format where All transaction e.g. Month of Jan-18 and a Client of ABC to be...

Hello there! I'm trying to help out a co-worker with an application that's randomly deleting documents from his files. He needs to be able to take a report showing a set of Reference File numbers and all documents that are currently in each file and parse them out onto a second sheet showing...

Hi everyone <tbody> Product wholeseller price/kg Apple ABC Rs 50 Orange ABC Rs 30 Apple XYZ Rs 40 </tbody> Using Product as the key i want to extract all the datas in new table like <tbody> Product ABC(Price) XYZ(Price) Apple Rs 50 40 Orange Rs 30 </tbody> I used formula to get...

I want to bring transactions of specific account 10001 from GL dump need help please. I have 25 columns which all I needed, given below 5 as sample GL dump Date | account| Description | amount | remarks 01/01/19 | 10001 | expense | 100 | ABC 02/01/19 | 10002 | income | 200 | CDE 03/02/19 |...

Hi Everyone, Can we subtract two cells which contains string in it. Like, <tbody> Column-A Column-B Column-C abc_def_ghi _def_ghi abc asdf123_abca _abca asdf123 afshqw_pl afsh_ pl asdff_1234 _1234 asdff </tbody> where Column(C) = Column(A)-Column(B) Regards, Dhruva

Hi, I been looking all over the place for a solution. I created two macros one to highlight the duplicates and other one to filter on the highlighted ones. I have the result set with all the duplicates and I need to take the max of Col L if that column doesn't contain zero, if it does look at...

I am trying to figure out how to remove all data [including opening parenthesis "("] which is appearing after the last occurrence of opening parenthesis "(" in a given string. Refer below example: <tbody> <colgroup><col><col></colgroup><tbody> RAW DATA OUTPUT ABC (P) (L) (30365) ABC (P)...

Sheet 1 <tbody> ABC 40 DEF 25 GHI 35 XYZ 20 </tbody> Sheet 2 <tbody> ABC 45 DEF 20 GHI 10 PQR 18 XYZ 40 </tbody> I want changes in value in 3rd sheet based on name criteria match of both sheet and additional name and value of sheet 2. Could you please solve my issue.

I want to paste option strike and expiry columns data in respective sheets name mentioned on the left. This is how the respective sheets looks like. In sheet ABC So rather than adding data in different row the macro should first look if there is blank in Column B. If there is then paste data...

I have a table that I determine the rank # with this formula:=SUMPRODUCT((ABS(AF7-0)>ABS(AF$5:AF$19-0))+0)+1 To get this: <colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col...

I trying to VLOOKUP the serial number & Description from List_tbl and add to Installed_tbl. If a serial number is available return serial, if not return "EMPTY". List_tbl <colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> FLEET BASE SRD AIRCRAFT WUC POSITION...

Hi Team, i have data from col A to L. in my col B i have names abc abc abc xyz xyz xyz xyz xyz and in col A i have 3 different names for "abc" and 5 different names for "xyz", and go on till last record of col B. so i wanted to create workbook "abc" and it should contain their data in that...

I've been toiling with this one for a few hours and have decided to come ask the experts for help. I'm trying to capture the start date associated with a particular company (in sheet 1) from a list of many stages that each company goes through (sheet 2) Sheet 1: unique list of company names...

I have a spreadsheet that contains multiple rows of data for multiple dates and companies. I am looking for a way to show all of the entries for the specified company within a specified date range. For example, I want to see all of the entries for company ABC between 1/1/2019 and 1/5/2019. I...

Hi all, I have a 6 column running Table (called "CS" - see table below). Each month my macro takes current data from a separate 5 column table and pastes it to the bottom of the CS table. After this procedure, there is always the expected blank 1st column in the CS (which is the "File...

Hey Excel Gurus, I have a large data with multiple worksheets. Please my requirement this time is for a vba code that performs trimming on the existing data present in all worksheets of my workbook. For example if text is (without the quotation marks): " abc def " the code runs and check for...

Can someone help me in providing formula for removing [] and data in it? <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 479px"><col width="349"></colgroup><tbody> DATA RESULTS ABC [2.5], JKB [23.3] ABC, JKB...

Hello Board, Here is my dilemma. I am trying to populate column H with the MAX date from column C where: item code matches (A=G) D is blank If no items in D are blank, make zero. (I will conditional format so it's blank and not 1/0/1900 if I need to) Note, this table A-D will NOT be...