Forum Discussion
copy a particular cell in multiple sheets and list them on another sheet individually
I have a 31 day spreadsheet. Each sheet represents one day. I want to copy the same cell from every sheet and list all those values individually on another sheet within the same document. Is there an...
You can use VSTACK with a 3D reference:
=VSTACK('1:31'!C24)
Another option would be TOCOL, if you need to omit blank cells:
=TOCOL('1:31'!C24,1)