copy range from she sheet to another sheet

  • DarTeam,


    I am having values in range sheet"Training" F14:F23. I want to copy these vales to Sheet"DP" "B3".


    Next time when i was copying it need to copy after the last row+1 of previous copied values.


    For that i had created button named as copy


    But my range on sheet"Training" F14:F23 will be formulas. when am copying the value it is displaying #Ref.


    Kindly help me for copy the values.


    I am attaching my file here for reference

  • Hello,


    You could test following


    Code
    1. Sheets("DP").Range("A" & lastrow + 1 & ":" & "A" & lastrow + 11).Value = Sheets("Training").Range("E14:E23").Value


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • Dear Carim,


    i had tried the following code for copy the other range to column c on Sheet "DP".


    But the range K12 is updating after A & B column last row.


    Can you please check and confirm me where is the mistake


  • Glad you could fix your problem


    Thanks for your Thanks


    If you are copying 10 rows ... just replace 11 by 10 in the instruction ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)