Splitting a worksheet into separate worksheets based on a keyword in a cloumn

Use auto-filter, or better attach your sample. To attach a sample, go to advance then attachment.

I need to use a macro so that it is full automated. I have provided some dummy data in the attachment, my spreadsheet is over 9000 rows long and there are 18 sections I must extract. Imagine this data on a much larger scale and they all need to be split into indivudual sheets for analysis purposes. Unfortunately I don't think it is as easy as simply putting an auto-filter in

That seems to be working for that problem hopefully I can use it on my other table! Thanks a lot Norie and AB33

The code is making new sheets with the names I need on them but doesn't seem to be pulling all the information out of the original sheet onto my new ones

alternative suggestion?

Please Login or Register  to view this content.

Try the attached.

Yeah it worked fine for the sample sheet. These are some of the headings I will be using in my actual sheet. There are also around 9000 rows for the document I want split. I unfortunately cannot send the full document as it has names of customers etc on it

I think works with your sample, but need to adjust the headings. I have the heading in row and goes 4 columns across. On the word attached, I think your heading is in row 5, or 6 and stretches up to column M. Please confirm if I am right and will adjust my code.

I need to sort it by column A. My headings go to column R but I was unable to show that as it was too big for the word document as it was too big

Where is the heading? Is it in row 5, or 6?

The heading is in row 6

I am not sure what do you mean by you want to sort by column A. I thought we are creating tabs based on column A. If this is not the case, it is a wrong code.

Yes, sorry that's what I meant. It is doing the job I want it to do in my exampleBook but it is not working for my other document. The other document is larger and has more columns than my exampleBook

I have added another code which could accommodate any columns and rows size and is much faster.

Thanks, which macro is it, alice or createnames

alice and name of the module is latestmod.

Thanks AB33, it works a treat. Cheers everyone for all their help, very much appreciated!

You are welcome!

Could you please now close (Mark) this thread as solved? Go to the top right-hand side of this page, choose "Thread Tools" from the menu, then select "solved" from the drop down menu.