Posts by jaslake

    Re: Help needed to modify the following code so that the data is copied only once.


    Hi raghuprabhu


    Welcome to the Forum!!


    Replace your LoopThroughDirectory Code with this...


    Re: help with send an Email with Excel VBA Code


    Hi pacedove


    Welcome to the Forum!!!


    Try this Code...

    Files

    • Send Mail.xlsm

      (43.59 kB, downloaded 66 times, last: )

    Re: Delete entire row if a cell does not match the keyword/data


    Hi Jomz07


    Yes, this is correct...

    Quote

    if I change Field:=6 to, let's say 3, would that be filtering column 3?


    However, if your Filter Range reads like this Column C would be 2...

    Code
    1. .Range("$B$2:$JH" & LR).AutoFilter Field:=2


    Further, if it reads like this Column C would be 1...

    Code
    1. .Range("$C$2:$C" & LR).AutoFilter Field:=1

    Re: find rows and replace each with several rows


    Hi catcat111


    As I understand your requirements, this Code in the attached appears to do as you suggested...let me know...

    Re: Delete entire row if a cell does not match the keyword/data


    Hi Jomz07


    Welcome to the Forum!!!


    Try this Code in a General Module...

    Re: Find Key Word in Col A, Select Content, Paste Consecutively on Newly Added Sheet


    Hi Chris


    There is no closing "TABLE" line on this "DOC" record...why? This is the cause of the failure...it's not consistent...

    Excel 2007 32 bit

    [TABLE="class: head"]
    [TR="bgcolor: #888888"]
    [TH][/TH]
    [TH]

    A


    [/TH]
    [TH]

    B


    [/TH]
    [TH]

    C


    [/TH]
    [TH]

    D


    [/TH]
    [TH]

    E


    [/TH]
    [TH]

    F


    [/TH]
    [TH]

    G


    [/TH]
    [TH]

    H


    [/TH]
    [TH]

    I


    [/TH]
    [TH]

    J


    [/TH]
    [TH]

    K


    [/TH]
    [TH]

    L


    [/TH]
    [TH]

    M


    [/TH]
    [TH]

    N


    [/TH]
    [TH]

    O


    [/TH]
    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    336


    [/TD]

    [td]

    DOC

    [/td]


    [td]

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [td]

    PUBLIC

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    337


    [/TD]

    [td]

    ID

    [/td]


    [td]

    SUF

    [/td]


    [td]

    TIV-11

    [/td]


    [td]

    TIV-12

    [/td]


    [td]

    TIV-13

    [/td]


    [td]

    TIV-14

    [/td]


    [td]

    TIV-15

    [/td]


    [td]

    TIV-16

    [/td]


    [td]

    TIV-17

    [/td]


    [td]

    TIV-18

    [/td]


    [td]

    TIV-19

    [/td]


    [td]

    TIV-22

    [/td]


    [td]

    TIV-24

    [/td]


    [td]

    TIV-25

    [/td]


    [td]

    TIV-26

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    338


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    F

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    339


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    G

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    340


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    P

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    341


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    J

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    342


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    J

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    343


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    J

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    344


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    J

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    345


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    J

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    346


    [/TD]

    [td]

    H42K-BBR-004

    [/td]


    [td]

    J

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [td]

    Yes

    [/td]


    [td]

    [/td]


    [td]

    Yes

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    347


    [/TD]

    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    348


    [/TD]

    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    349


    [/TD]

    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    350


    [/TD]

    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [/TR]
    [TR="bgcolor: #FFFFFF"]
    [TD="bgcolor: #888888"]

    351


    [/TD]

    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [td]

    [/td]


    [/TR]
    [/TABLE]
    [TABLE="class: grid"]

    [tr]


    [td]

    Sheet: Sheet1

    [/td]


    [/tr]


    [/TABLE]

    Re: Find Key Word in Col A, Select Content, Paste Consecutively on Newly Added Sheet


    Hi Chris


    Here's the Annotated Code...something makes no sense let me know...