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 one?

 

excel
office 365

3 Replies

  • 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