Conditionally copy selected cells in rows depending on cell contents.

  • Re: Conditionally copy selected cells in rows depending on cell contents.


    The confusing


    There's no reason for this code raise the error.

  • Re: Conditionally copy selected cells in rows depending on cell contents.


    This time I put the code in the ST_Production Schedule file, and ran the macro, and it worked!! Thank you so much!
    I'm sorry for being such an idiot around excel and programming.


    Thanks again.


    If I were to run this macro on other files, would it go into the next blank row within the GT&TT Trial.xlsm file?

  • Re: Conditionally copy selected cells in rows depending on cell contents.


    As you can see from the code, each objects (Workbook and Worksheet) are clearly specified.


    If you run this code from the other workbook, it still do exactly the same as you run it from ST_Production Schedule file.


    Do the rest first and when you stuck, post back.

  • Re: Conditionally copy selected cells in rows depending on cell contents.


    Hi Jindon,


    Thanks for your help, I was able to get it to run on another workbook without any issues.


    As we're currently pulling data based on a cell containing GT, how do I add more conditions so that I also pulls data if a cell in the same column contained TT or DT?


    Thanks again,
    Dan.

Participate now!

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