Using Combine macro to combine multiple worksheets - need to modify to paste formulas

Good evening,

I'm using the following code to combine multiple worksheets with the same layout into a combined worksheet within the same book (thanks to Jerry Beaucaire for the original code). I need to paste the formulas within the spreadsheet as well and think I just need to change the PasteAll to PasteFormulas and probably need to add PasteFormats as well, but as I am relatively new to all this, I'm not 100% sure how to do it. I tried a couple of combinations where the PasteAll function exists and still didn't get the desired result.

Thanks in advance!

Please Login or Register  to view this content.

Thank you!!