Grouping sheet in a workbook

  • Thread starter Thread starter Ben T
  • Start date Start date
B

Ben T

I have a workbook with 20 tab(sheets) in it. In each of
these tab at cell C5 is a name. Is there a way that I
can group these tabs by cell C5 so that they are right
next to each other without me manually doing so? Thanks

Ben
 
One way:

If u prefer by COLUMN, put this formula in the target
worksheet cell B1:U1
=INDIRECT("Sheet"&COLUMN()-1&"!C5")

If u prefer by row, put this formula in a your target
worsheet cell B1:B20
=INDIRECT("Sheet"&ROW()&"!C5")

HTH
Edmund Seet
 
Back
Top