Forum Discussion
Gazz88
Sep 13, 2023Copper Contributor
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...
Patrick2788
Sep 13, 2023Silver Contributor
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)