copy/paste valid value between worksheet

  • Re: copy/paste valid value between worksheet


    As the layout for Sheet1 and Sheet2 are different you will need to copy in sections but it is straight forward. For example to copy Advertiser, Engine, Campaign from sheet1 to (my assumption is next available cell on Sheet2) you would reference the sheets and use a simple method to determine the range to copy


    Notice the way to find the last cell in the row

    Code
    ws.Cells(Rows.Count, "A").End(xlUp).Row


    In the paste - you need to find the last row and add 1 if you want to keep appending data to sheet2. This should give you enough information to do the rest yourself. If this is not what you require then please supply more information with some examples in the sample workbook.
    Note: Consider redesign of the workbook so you can copy the entire block of data in one go rather than copying in sections.

    Regards
    [SIZE=3]Anthony
    [/SIZE]&WCF_AMPERSAND[SIZE=3]
    [/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]




Participate now!

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