How to import data from 2 different tabs in a single sheet

[Divyaverma2906]

How can I input 2 different tabs from same sheet without adding multiple input tools

[danilang]

Hi @Divyaverma2906 

In your case the easiest way is just to use two different Input Data Tools.  The data in your 2 sheets have completely unrelated schema, so any batch macro solution would give you a union of these schema in a single table.    

If you really want to go the macro route, here's an article that explains the process.  Just be aware that you'll need to separate the resulting data to get 2 usable datasets.

Dan