How to: VBA paste UNDER last value?

Good afternoon,

I wrote a code so the values are being copied and pasted on the address i manually selected. But i want to have it more efficient. It should copy UNDER the last value in a row. I am trying to get it done for hours already.

Maybe someone could help me with this problem? (The reason why the data is on a strange place it the sheet "reference" is because i deleted everything wat was in front of it because it did contain personal data from people)

Please Login or Register  to view this content.

Perhab

Please Login or Register  to view this content.

in Training tab in which column you want to paste data

if i understand clearing, you want to paste data under that column where Z23 (reference tab) is match in Training Tab row 23 right ?

if it so then we should not look for the next empty column in 23rd row in Training Tab because you are not copying the date cell in reference tab.

-- if we would be copy Z23 to Z28 then we can paste the data in next empty column in 23rd row in training tab. are you agree with this ?, shall we approach this way ?

okay, you mean to say in 23rd row in training tab will have some date for next empty cell in 24th row right

Try:

Please Login or Register  to view this content.

if its so you can this code

Please Login or Register  to view this content.

Glad its works like what your looking for please mark the case as solved and dont forget hit on Add Reputation