Posts by CarpetPerson

    Assumptions for this code:
    1. Employee Inventory sheet has heading in row one so it will start checking the data in row 2.
    2. Column Q does not have any empty cells.
    3. EEs sheet will have headings in row one so the data will start copying in row 2.



    Set I = Sheets("Employee Inventory")
    Set e = Sheets("EEs")
    Hi



    I have a spreadsheet with the following headings:
    A B C D E F
    SKU SiteID HelperColumn Description May-16 ActualOrder


    [TABLE="width: 766"]

    [tr]


    [td]

    [ATTACH=CONFIG]69185[/ATTACH]

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]


    I need to copy information to another sheet based on the value in Column F(ActualOrder).
    But I also need the vba to ONLY copy Columns (A)(D)(F) To the other sheet in the same workbook.



    First sheet from where the data needs to be copied is: CheckAgainstSOH, and the sheet where the data needs to be copied too: Dashboard.



    In Column F, you have values such as 50 etc, and "InsufficientSOH", I need the vba ONLY to copy the ones where there is ONLY a number value. And stop when Column F is blank. THis is so very important.