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