Hi guys,

I am newbie when it comes to programming in excel...

Currently I have an excel worksheet with 4 sheets in it.
All four sheets contains data and based on them I am creating more sheet by
looking up data from them. Way I am looking up data is follows:

Based on column one in first sheet I am creating more sheets (e.g., If i
have a in A1, b in A2, c in A3 and so on...) My new sheets names that I am
creatin is based on this. So I have Sheet a, b, c ...and so on.
How do i programmatically creating this sheets based on the scenario I
definded above how do i know when to end creating sheets?


Once I created these sheets now I have to move data to them.
on my second sheet I have title column and next to it data columns that has
the sheet names that I created in step 1 above (a,b,c, so on...), e,g

a, b, c, d, e, f
Title 1, 1, 0, 1, 0,1
Title 2, 0,1,1,0,0,1
Title 3, 1,1,0,0,0,0

no Every column that has value 1 in it moves the title of that sheet to its
appropriate sheet. So in case of above:
Title 1 and title 3 moves to sheet a, and so on...

How can I programetically do this. I appriciate an help you guys can provide.

Thanks