How to omit rows from Sub parse data VBA

Hi

Please could someone help me modify the below VBA? I am trying to omit the first 6 rows (only 2 are populated) so that when the split into different worksheets occurs, the first 6 rows are not part of the split. I am a macro novice so if you could make it easy to understand, that would be much appreciated. Also, I was trying to use two rows for my header (title from A5:P6), however this didn't seem to work and I have had to resort to using A6:P6, if there is a way of using two rows, please could you let me know?

Many thanks in advance.

Please Login or Register  to view this content.

Hi Ninzzii,

Welcome to the Forum!

Sorry to say that:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

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, it also maintains VBA formatting.

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

Please attend to this directly.

Hi Ninzzii,

Thanks for the rep!

You say it's working and all you want is to skip the first 6 entries - try:

Please Login or Register  to view this content.

But, if that doesn't work then:

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

This seems to do it:

Please Login or Register  to view this content.

You're welcome!