Copy Text based on Criteria

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

  • Re: Copy Text based on Criteria


    Your initial post should have started "I have a spreadsheet ...". Everything before that is pointless.


    You want to copy the values from Cols A, D & F to the sheet Dashboard where F contains a numeric value?


    Where on the destination sheet do these value go?




  • Re: Copy Text based on Criteria


    Assumptions as there has been no reply:
    The values go to the last used row on Dashboard
    The code runs in the code module of the sheet 'InsufficientSoH'


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!