Forum Discussion

Tony2021's avatar
Tony2021
Iron Contributor
May 17, 2021
Solved

Code to add to last row in named range

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 ...
excel
Rajesh_Sinha's avatar
Rajesh_Sinha
Iron Contributor
May 18, 2021
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 !!
  • Tony2021's avatar
    Tony2021
    Iron Contributor
    May 18, 2021

    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.

    • Rajesh_Sinha's avatar
      Rajesh_Sinha
      Iron Contributor
      May 19, 2021

      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.

Resources