Home

How to extract specified work sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-860724%22%20slang%3D%22en-US%22%3EHow%20to%20extract%20specified%20work%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860724%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20excel%20contains%20186%20sheets%2C%20naming%20like%201%2C%202%2C%203%2C%204%2C%20.....%20186.%26nbsp%3B%20If%20I%20want%20to%20get%20sheets%20numbered%26nbsp%3B%2033%2C%2047%2C%2067%2C%2089%2C%20101%2C%20111...%EF%BC%88like%2030%20sheets%EF%BC%89.%20Can%20I%20get%20the%20result%20without%20select%20them%20one%20by%20one%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F132312iCA738F9AD3DAF603%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-860724%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-860956%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20extract%20specified%20work%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-860956%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398440%22%20target%3D%22_blank%22%3E%40mengsheng%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20get%20data%20from%20desired%20sheet%20without%20selecting%20them%20one-by-one.%20Please%20mention%20sheet%20names%20in%20one%20column%20and%20try%20below%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DINDIRECT(B6%26amp%3B%22!A1%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EHope%20it%20will%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20sample%20file%20is%20also%20attached%20for%20your%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-866505%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20extract%20specified%20work%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-866505%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThough%20I%20need%20the%20whole%20sheet%20rather%20than%20a%20cell%20in%20it%2C%20your%20answer%20inspired%20me.%20Thank%20you%20.%26nbsp%3B%20%3CLI-EMOJI%20id%3D%22lia_grinning-face-with-smiling-eyes%22%20title%3D%22%3Agrinning_face_with_smiling_eyes%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-866545%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20extract%20specified%20work%20sheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-866545%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398440%22%20target%3D%22_blank%22%3E%40mengsheng%3C%2FA%3E%26nbsp%3BYou%20are%20welcome%2C%20you%20may%20share%20actual%20data%20so%20that%20more%20relevant%20and%20specific%20solution%20can%20be%20suggested.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
mengsheng
Occasional Contributor

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?

 

clipboard_image_1.png

3 Replies

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

 

@tauqeeracma 

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

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

Thanks

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies