3 Replies Latest reply: Oct 28, 2018 4:53 PM by Ruben Marin RSS

    Excel Tabs, Concatenate all Tabs

    Alex Tomlins

      Hi Guys and Gals,

       

      I have managed to avoid loading in any multi-tab Excel files until now. We have a spreadsheet with Change Requests but every month we create a new tab for the current month.

       

      How do I Concatenate all the tabs data into one table automatically - even if they have added a new tab for the new month.

       

      If this can't be done is there a way of taking the first tab or the tab with '*CURRENT*' in it?

       

      It would be helpful to know all methods for my learning if you have the time but if not only to auto concatenate the sheets even if they are always adding them?

       

      Thanks,

       

      Alex