Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Fetch data from multiple sheets in excel to seperate collection

SudheerReddy
Level 4

‎04-03-18 07:39 AM

I have a workbook which contains 20 worksheets for now. Data available in each of these sheets are completely different. No. of sheets available will increase/decrease as per the business requirements. Now, I want to collect the data from each of these sheets to seperate collections.Can anybody help me achieve this?
0 Likes
2 REPLIES 2

DavidEdwards-Da
Level 5

‎04-03-18 09:14 AM

Is there at least some form of structure for this data? Is each sheet a single table, with the first row being the table headers?
0 Likes

Denis__Dennehy
Level 15

‎06-03-18 05:05 PM

There is a select worksheet option in the Excel VBO.  
0 Likes