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 ...
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.