Insert new sheet's base on item.

[johncena]

Dear friends here i have attached my stock balance sheet.i want to add another function to my sheet. my requirement is..

01.If i enter new item automatically new sheet need to create & that sheet name should rename to item number in first sheet.( like my other sheet)..

02.after creating new sheet that sample sheet data need to copy on to the new sheet.(all new sheet's should be like a sample sheet)

I have more than 200 items.so manually doing this work is not a easy.pls make a macro or something to do this.actually i don't no it's possible or not.pls help me...

[royUK]

I'm getting a warning that this file might not be safe when I try to open it.

In any case, I think you should rethink this plan - you will end up with 200+ sheets - that will be difficult to maintain

[johncena]

I'm getting a warning that this file might not be safe when I try to open it.

In any case, I think you should rethink this plan - you will end up with 200+ sheets - that will be difficult to maintain

ohh really..sorry for that warning...yes u right.do u have any idea to do this work in other way..

[royUK]

The best way is all the data on one sheet with one column to fill in the name, then you can AutoFilter by that column

[johncena]

The best way is all the data on one sheet with one column to fill in the name, then you can AutoFilter by that column

pls can u make some sample sheet for me.then i can full understand.