creating new sheets and moving data dependant upon cell value

[steveallany2k6]

Hi im new here and hope someone could help me. I am looking to move rows of data to difeerernt sheets dependant on data held in column B, but i want it to create the sheets at the same time

IE
column B may have values of a,b,c,d,e,f,h etc and i want it to group all the same values together and then create a sheet with that value and move the entire rows with that data in to that sheet
the rows with A in column b goto a sheet called A........ so on so on


i hope someone can help me with this


Thanks

Steve

[rvasquez]

Hey there,

Attached is a workbook I believe accomplishes what you are looking for.

To add the code to your workbook press Alt+F8 on your keyboard and in the macro name spot provided clear the contents and type CopyData. Then Select the create option. Paste the below code between the Sub CopyData and End Sub

Please Login or Register  to view this content.

Please read through the code so that you understand what it is doing. Anything that appears in green are comments that I placed to help you understand. Some comments ask you to change some information in the code. For example, right now it unique value filters column B into column L. You'll want to change column L to another column letter if you currently have data in column L so you don't replace your data and so the code works properly. You'll need to change the column L several times in the code but the comments tell you where.

Let me know if this works for you and if you have any questions.

Thanks!

Rvasquez