Try this method:
In A6 of Sheet1 enter formula:
=IF(B6<>"",1,A5+1)
copied down as far as your column B data validation goes. This serves as a counter. You can hide the column if you wish.
Then in C6:
Confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down same distance.
In D6:
copied down.
Now make a selection in B6, you should have results.
After the last result, make another selection in column B, the corresponding results should appear, then go to bottom and make another selection in B, and so on...
when you are clearing for new entries, make sure to only delete entries made in column B
Bookmarks