Unable to split data that fits criteria equally into 2 worksheets in another Excel file

  • Dear all,

    Rows in Workbook 1 that has column H, I, J or K filled up are ready for transfer.

    I would like to copy and paste rows that are ready for transfer equally into 2 existing worksheets (Alex and IMHD) in Workbook 2.

    Each worksheet in Workbook 2 requires different information to be copied over from Workbook 1. I have figured out the copy and paste codes.

    However, I am unable to find the code that can split the data - half executes the 1st copy and paste code (CopytoAlex), the other half executes the other copy and paste code (CopytoIM).

    Note: Feel free to make any clarifications. Tried my best to explain.