Combining multiple xls sheets into one but retain the formula in sheets

Hello all,

I was able to successfully combine my excel sheets from a folder into one workbook using this solution shared by @andrejz in this post Combine excel files into single workbook in sheets

From my understanding, columns read by Excel are usually in string/int format? Is it possible for me to combine these files into a workbook but retain the original formula.

Many thanks for your help!

Hi @kkmak13
You may check this out.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.