Code to add to last row in named range

[Tony2021]

Hello,

I have data in cells A5-A10
I want to automatically add this same data to the last row in a named range “Borrowers” but in cells D5-D10.

Could someone be so kind to assist? Grateful for your help.

Thank you

[#2]

It's simple Select A5:A10 the hold Ctrl button then Select D5:D10,, now go to Name box is left to Formula Bar ,, assign a name,,, them when U select the Name you find both A5:A10 & D5:D10 been selected ... OR reach to Name Manager ,, select the Name given to D5:D10 , press EDIT,,, and in refer to add the new data range looks like
=Sheet1!$D$5:$D$10,Sheet1!$A$5:$A$10
Hope this help you !!

[#3]

@Rajesh_Sinha 

Hi Rajesh,

Thank you for your respose. However I am not sure if I follow it. I do not see how the data will be appended to the last row of the named range in D5:D10.  Maybe I am missing something. 
I have uploaded a sample file. Please let me know your solution.

[#4 · Accepted solution]

@Tony2021 

It could be

=INDEX(B:B,COUNTA(B:B))

in first cell and drag to the right

[#5]

@Tony2021 

In fact your need is different than your original post but anyways check the attached WB, I've suggested an improved formula which adds as many rows required.