This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to import an xls file with 2 different sheet names. This data always comes as an xls and is not able to be converted to an xlsx.
What is the best way to do this? I know the dynamic input tool can be used for xlsx, but not sure how to bring both sheets in with an xls file.
I would recommend looking into a macro posted in the link below. It should get you what you want!
Let me know if you have any questions.