Forum Discussion
Importing Multiple Selected Excel Sheets from multiple workbooks at one time
Hi, Is there an easy way to import multiple sheets from an excel workbook based on what the sheet name contains. For example, I have 3 excel workbooks with similar data in it. All the workbooks ...
Thank you. Your comments gave me the answer..... It seems that I will have to do each one on its own due to the years that are in the columns? There are 62 sheets in total, so I was hoping that there is a way to do it much faster....without havign to unpivot each. I will try and get sample data and send.