Forum Discussion
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 your help.
Thank you
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
4 Replies
- 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 !!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.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.
