script to create new worksheet with values

Hi, could you help me with scipt witch will create new worksheets with values on the basis of value from list1, column "M"

in list1 i've columns A to P and in column M i have values (for example:AL, BL, CL, DL, EL. I need to create new worksheets which will be named on basis of this values. To those new worsheets will be copied the rows from list1 , where is in row and column "M" value with name of worksheet.

better explain is in insetred attachement what i need to do.

thnx

Hello, try clicking the button in the attached workbook.

I've created a macro that does the following:

1) Loops through Column M to get the names of the sheets
2) If sheet doesn't already exist, then a sheet is created
3) All row data from "list1" sheet is transferred to the individual sheets based on the sheet name in Column M

Please Login or Register  to view this content.

Xx7 .. it's great ... this scrip also update values in woksheets ... thanx