1. H

    VBA for excel to send multiple emails; subject; body (Content)

    <tbody> To Subject Content; ABC - 1 Content 1; 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...
  2. Q

    Query Count

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

    data from large database

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

    Need to validate that all documents are appearing in a file

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

    Help with the basic formula

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

    Pick detail of specific GL account with details

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

    Subtract two strings from two different cells VBA

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

    Duplicate cells on col A and looking at another Column and taking the max of the another column if that col doesn't have zeros

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

    How to extract a particular set of string from a given set of sting?

    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)...
  10. K

    Find out differential value of two sheets based on criteria match

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

    need a solution for following scenario

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

    Sorting Rank Results

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

    VLOOK-UP Formula

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

    Create multiple workbooks

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

    Show date value where the company name matches and date is not null

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

    VBA code to return all rows matching multiple criteria

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

    VBA - filling in blanks in Table column

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

    Applying the Excel's Trim Function on the Entire Workbook.

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

    Formula needed for removal of [] and data in.

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

    MAX date, item match and empty cells

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

Some videos you may like

This Week's Hot Topics