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 easier way over typing ='1'!C24 thirty one times changing the sheet number each time I type it?
I'm capturing 31 days of the same cell for each of the fifteen cells on each sheet.
These cells are not necessarily next to each other on the sheets. Thanks.
1 Reply
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)
