May 17 2021 04:32 PM
May 17 2021 11:05 PM
May 18 2021 03:23 PM
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.
May 18 2021 03:52 PM
SolutionMay 19 2021 03:12 AM
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.
May 18 2021 03:52 PM
SolutionIt could be
=INDEX(B:B,COUNTA(B:B))
in first cell and drag to the right