Need to Paste Formulas and Not Values in Current VBA Code

I have a pre-written VBA code that splits one worksheet out into multiple different worksheets based on the value in column B. It then saves each of the new files using the path in the tab "Settings". The only issue with the current code is that it only pastes the formula in column E to the first file created - all files created thereafter simply paste everything as values.

Is there a way to edit this code to ensure that the formulas carry through to all of the newly created files, and not just the first one? Sample excel file with the code is attached.

Thanks!

Here is the current code:

Please Login or Register  to view this content.

hi, Try the corrected code

Please Login or Register  to view this content.

Regards.

Hmm it is keeping the formulas in column E but no longer splitting the documents out by the value in column B.

Try

Please Login or Register  to view this content.

This works perfectly, thank you!