Excel - create a list from each cell of a sheet range
- by CharlesB
I have a bunch of sheets in my workbook, in each one there is an email address at B6.
What I want to do is to make a list with all the email addresses. I'm familiar with sheet range (all my sheets are between a sheet "first" and a sheet "last"), so I can do something like first:last!B6 to refer to the range. But what is the formula?