'Is there a way to import multiple sheets at once from another workbook based on criteria?
I have an excel workbook containing 300 exam questions. Each sheet (tab) represents one question along with answers. Also, each sheet is named item#1,item#2,item#3,etc.
I have multiple sets of 30-questions items. I wonder if there is a way to import all 30 sheets based on the list of 30 items I have. For example, if I put in 30 item numbers, I hope it will automatically import 30 sheets into a new workbook based on the items I put in.
I've been looking for solutions to this, but most of the available solutions are to pull data into a table. But I want to pull multiple sheets at once based on criteria. Microsoft excels or google sheets solutions are both fine. Thank you very much in advance for your help.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
