Splitting Sheet into two Sheets using macro

Hi Everyone

Thanks for looking at my post. I really appreciate it

I am trying to save hours of work by making the following macro.

You Start of with one Sheet called Raw_Data.

And end up with three sheets.

I want it to split the Raw_Data into two sheets called Raw_Sheet_1 and Raw_Sheet_2 as soon as it has passed 3 different birds.

To make this easier to understand I have provided a final which shows what the final data should look like.
Note that it must transfer the header to both new sheets.

Also the number of rows can change and so can the number of columns ( hence why a macro is required ).
So can the number of total birds.

Note that I have attached an excel file of how the excel file should look like at the end.

Thank you so much to everyone for looking even if you were unable to help

Jessica

Hi jasper

Thanks for all the help.

Unfortunately, it does not seem that code works on the sample sheet.
When i simply start with the one sheet it creates two sheets called sheet1 and sheet2 but they are empty

Any ideas

Am I missing something ?

Love,

Jessica

Thanks Jasper !!!!

That works perfeclty. I can't even begin to tell you how helpful that was

Is there a way that I could get the new sheets to be called

chicken_1
chicken_2

and so on, instead of Sheet1
Sheet2
Sheet3 ?

That module code just works perfectly !

sure, adjust as follows :

Please Login or Register  to view this content.

Hi JasperD

Thanks for all the help

I know that now i am being difficult.

Is it possible to write a macro which will create entirely new excel files instead of sheets ?

And would it be possible to have a macro which would bring them back together.

The issue is that I am running a bunch of macros in a row and eventually I get the following error message:
"Excel cannot complete this task with available resources. Choose less data or close other applications ".

Thanks