how i can get A1 cell value of each work sheet in one single sheet while dragging ?
- Thread starter kamal1977
- Start date
Somendra Misra
Excel Ninja
Hi Kamal,
Welcome to chandoo.org forum.
If sheet names are uniform like in the sample use below formula in A1 and copy down:
=INDIRECT("Sheet"&ROWS(A$1:A2)&"!A1")
Regards,
Welcome to chandoo.org forum.
If sheet names are uniform like in the sample use below formula in A1 and copy down:
=INDIRECT("Sheet"&ROWS(A$1:A2)&"!A1")
Regards,