Forum Discussion

mengsheng's avatar
mengsheng
Copper Contributor
Sep 18, 2019

How to extract specified work sheets

I have a excel contains 186 sheets, naming like 1, 2, 3, 4, ..... 186.  If I want to get sheets numbered  33, 47, 67, 89, 101, 111...（like 30 sheets）. Can I get the result without select them one by ...
excel
office 365
tauqeeracma's avatar
tauqeeracma
Steel Contributor
Sep 18, 2019

Hi mengsheng 

You can get data from desired sheet without selecting them one-by-one. Please mention sheet names in one column and try below formula:

 

=INDIRECT(B6&"!A1")

Hope it will help

 

A sample file is also attached for your reference.

 

Thanks

Tauqeer

 

  • mengsheng's avatar
    mengsheng
    Copper Contributor
    Sep 19, 2019

    tauqeeracma 

    Though I need the whole sheet rather than a cell in it, your answer inspired me. Thank you .  😄

    • tauqeeracma's avatar
      tauqeeracma
      Steel Contributor
      Sep 19, 2019

      mengsheng You are welcome, you may share actual data so that more relevant and specific solution can be suggested.

      Thanks