The title here may be a bit misleading - this is a little more complicated than just referencing data.
I'm trying to reference data from one worksheet to another - that's the easy part.
The data I'd like to output comes from a list on a different worksheet. Is there a function (or group of functions) that looks at what data has already been output to the cell above it, then outputs the next item from the list on the other worksheet? Eventually, the goal is that once the last item on the list is output, the formula would know to start over with the first item.
Here is an example - View attachment sample list.xlsx
I've tried looking into manipulating cell positions, but there doesn't seem to be a straight forward way of doing that unless you go to R1C1 format.
Thank you in advance to anyone that can nudge (or shove) me in the right direction!
I'm trying to reference data from one worksheet to another - that's the easy part.
The data I'd like to output comes from a list on a different worksheet. Is there a function (or group of functions) that looks at what data has already been output to the cell above it, then outputs the next item from the list on the other worksheet? Eventually, the goal is that once the last item on the list is output, the formula would know to start over with the first item.
Here is an example - View attachment sample list.xlsx
I've tried looking into manipulating cell positions, but there doesn't seem to be a straight forward way of doing that unless you go to R1C1 format.
Thank you in advance to anyone that can nudge (or shove) me in the right direction!