Splitting up data into separate sheets based on a column

Hi all,

Decent with excel but horrible with macros. I've attached a demo of what I would like to do. I want to take column c as my identifier and use it to create worksheets with the same name and all the records that are associated in each matching row as well. In the example, I have "summary" as my before product and "sales/marketing/graphic design" sheets as the potential finished product. Any easy way to do this?

Thank you.

No dice on that, the error message states:

Compile error:
Member already exists in an object module from which this object module derives.

The first line, sub move() , and option explicit is only listed once.

Yours looks like its working because you already have sheets called "Marketing/Graphic Design/Etc..". When I run this every quarter, some of these fields will change. Is there a way to modify the macro to create sheets with unique identifiers as found in column C

Use AutoFilter...

Please Login or Register  to view this content.

this works perfectly on my test spreadsheet, but when i move it over to my actual data that has 41 columns (with the key indicator in column 40), where do I change the code to use column AO as the column of choice?

Try change 3s to the col reference that you want
1)

Please Login or Register  to view this content.

2)

Please Login or Register  to view this content.

This is getting closer, it created the sheets based on column 40 like I wanted, but it didn't transfer any of the main data over. So I have a row of headers from the main data in A1:AO1 with nothing underneath in A2:A02

Then I need to see your actual data layouts.

Reattached the example. The column I would need to utilize is column 40 (department).

Working...

Please Login or Register  to view this content.

This works, thank you!