Need VBA to split data into multiple sheets paste formulas, formatting AND data validation

Cross-posted at https://www.mrexcel.com/board/thread...ation.1267167/

Hello!
I am using the following VBA code to split data into multiple sheets based on a value in a column of the "Master sheet". I need it to paste formulas, formatting AND data validation into the newly created sheets. However; the existing code is only pasting/copying formulas and formatting, NOT data validation.
I tried adding .PasteSpecial xlPasteValidation after .PasteSpecial xlPasteFormats but that didn't work, it caused the new worksheets to all be blank.

can anyone help please?

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
For new members: you will not be able to post a full URL, so remove the https://www. section and add one or two breaks to the rest of the address. A Moderator or Admin will then fix the link for you.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I have added the link to your post because it's your first post.

Administrative Note:

We recommend that you include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I have done this for you because it's your first post.

We advise reading the rules of this and any forum when you join.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."