copy last 5 populated cells

[redspanna]

Can I please have help to get code to carry out simple task below

Find last populated cell through Column A of Sheet1

From that cell select the next 5 cells UP for both columns A and B and copy that data into cell D1

So if A50 is the last populated cell, the code would copy A45:B50 into D1

Many thanks in advance

 

[AliGW]

You're welcome! Happy New Year to you, too.

 

[navic]

Yes, you are! If these are numbers, try this:

May be easier to copy

in D1 and copy down

=INDEX(A:A;COUNTA(A:A)-(5-ROW(A1));1)

or

=OFFSET($A$1,MATCH(MAX($A$1:$A$12)+1,$A$1:$A$12,1)-(6-ROW(A1)),0)

my regards
Any good I want you in the New Year

 

[AliGW]

Yes, there are always neater ways! Mine was a bit rough and ready ...

Happy New Year to you, too, Navic!