Posts by jonny

    Thanks,


    This helps if comes one person only, however I'm managing a row of the entire family.
    Instead of counting I wish to sum "number of persons" data that located in "C" column. What's the right syntax of that?
    Something with "offset", I assume?

    Hi Guys,


    I've upcoming event and the list of guests:


    What I'm trying is to build a function that summarizing number of person per each table.. Please your kind help with that.
    [TABLE="border: 1, cellpadding: 1, width: 500"]

    [tr]


    [td]

    Guest Name

    [/td]


    [td]

    Table Number

    [/td]


    [/tr]


    [tr]


    [td]

    A

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    B

    [/td]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td]

    C

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    D

    [/td]


    [td]

    1

    [/td]


    [/tr]


    [tr]


    [td]

    E

    [/td]


    [td]

    3

    [/td]


    [/tr]


    [tr]


    [td]

    F

    [/td]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td]

    G

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [tr]


    [td]

    H

    [/td]


    [td]

    2

    [/td]


    [/tr]


    [/TABLE]
    [TABLE="border: 1, cellpadding: 1, width: 500"]

    [tr]


    [td]

    Table Number

    [/td]


    [td]

    1

    [/td]


    [td]

    2

    [/td]


    [td]

    3

    [/td]


    [td]

    4

    [/td]


    [/tr]


    [tr]


    [td]

    Number of persons

    [/td]


    [td]

    ?

    [/td]


    [td]

    ?

    [/td]


    [td]

    ?

    [/td]


    [td]

    ?

    [/td]


    [/tr]


    [/TABLE]

    I have a code that moves one chart from Excel to Powerpoint. May someone help to modify it so that it will move all charts within the active worksheet to Powerpoint?


    Thanks

    The below code is creating an email with the list of tasks, the only issue i that each row is starting with task category.
    Please your kind help to modify the code , so I can see the task category and below it the tasks.



    Re: Creating Contacts From Incoming Emails (USD $20.00)


    The only issue could be is to extract sender title, but I don't see a problem to extract the below :
    1. Company name - could be extracted from the sender email.
    2. Sender name first and last - could be extracted from the sender email.
    3. Sender email - could be extracted from the sender email.
    4. Phone number - could be extracted from the email body.
    5. Company website - could be extracted from the email body.

    Re: Selecting multiple rows


    Working great!
    If I want to copy constantly the rows A1:A16, what's the correct syntax to do that?

    Code
    Union(Range("A1:A16"), Range(RowCollection)).EntireRow.Copy

    Re: Selecting multiple rows


    The code is very simple, a user form with two option buttons. After both buttons are being pressed, two rows should be copied into a new workbook.


    Re: Selecting multiple rows


    When I trying to copy a range , I'm getting an error : "That Command Cannot Be Used on Multiple Selections". How could be copied the unique rows only?

    Code
    Private Sub optPlastic_Click()
        RowCollection = RowCollection & "A26" & ","
    End Sub
    Private Sub optSemi_Click()
        RowCollection = RowCollection & "A26" & "," & "A33" & ","
    End Sub

    Re: Selecting multiple rows


    1. I have a userform with the groups of OptionButtons
    2. Pressing each OptionButton appends predefined row numbers into global variable, called : RowCollection
    3. Once I press a button "Copy" the row numbers stored in RowCollection should be copies to the new workbook.



    As a delimiter I've set "|" , but it certainly could be changed (or entire concept could be changed).

    Re: Selecting multiple rows


    I'm actually have to run thru the RowCollection array, to append the rows into the range and then copy them into new workbook.
    Here is a kind of psevdocode:

    Code
    For Each MyStr In Split(RowCollection, "|")
      If MyStr <> "" Then
         RowsToCopy = rows(MyStr).EntireRow ==> New Workbook
      End If
    Next MyStr


    Will much appreciate your help..

    How the below code could be replaced into one line where a row number is variable?

    Code
    Rows("8").EntireRow.Select
        Rows("11").EntireRow.Select
        Rows("14").EntireRow.Select
        Rows("20").EntireRow.Select


    Thanks

    Required to scanning thousands of email in Outlook inbox and the subfolders. From each email to retrieve the sender details and add into the contact list (only out of corporate senders).
    For those senders who have auto signature , need to extract the data as phone# , company , e.t.s into relevant contact fields. The purpose is to have a contact list with full contacts data.
    Once all this done , the script should run in background for all new incoming emails.
    I want to get a VB code as well.


    Thanks

    Re: Searching partial string


    Sorry for confusing, the logic as following:
    Need to search full string from "Code" column within the column "PN". Once it's found, to get the associated "Model".


    Thanks

    Re: Searching partial string


    Three rows given only for a reference. The original file is huge with a thousand of rows.
    I would prefer to have a function , equivalent to VlookUp. So finally I will get :
    [TABLE="width: 233"]

    [tr]


    [td]


    PN

    [/td]


    [td]


    Model

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    SN74LVC1G08DCKR

    [/td]


    [td]

    Golf

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [/tr]


    [tr]


    [td]

    TLV3492AIDCNT

    [/td]


    [td]

    Polo

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    TPS2031DRG4

    [/td]


    [td]

    Bora

    [/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]