VBA Extract Data to new worksheet thro combobox

[breadwinner]

Goodevening all

Dear expert's

help me

I have 2 Sheet (sheet2 and week) i want split and move week nos data's to new sheet through combobox value

data are in week sheet i can assign the values from sheet2 through userform combox

if I select week1 then click command button then range A:E should move new sheet in next to week sheet

once sheet create week1 that week sheet should hide

thanks all

[arlu1201]

What should the new tab be named?

[breadwinner]

As What Value Be selected in combobox will be sheet name? if wk-1 select in combo sheet name will be wk-1

thanks

[arlu1201]

Double click on the command button on your form and enter this code -

Dim lrow As Long

Worksheets.Add(after:=Worksheets(Worksheets.Count)).Name = ComboBox1.Value
With Worksheets("Week")
    lrow = .Range("A" & .Rows.Count).End(xlUp).Row
    .Range("A1:E" & lrow).AutoFilter field:=1, Criteria1:=ComboBox1.Value
    .Range("A1:E" & lrow).SpecialCells(xlCellTypeVisible).Copy Worksheets(ComboBox1.Value).Range("A1")
    Unload Me
    .Range("A1:E" & lrow).AutoFilter
    .Visible = False
End With

[breadwinner]

Thanks Dude Perfect Code !!!

[arlu1201]

I would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[breadwinner]

Sure dude words is mightier than Icon starts ...Your r excel start ...dude i still looking for solution with this post if you can solve this i really greateful to you
http://www.excelforum.com/excel-prog...50#post3281350
thanks for spending your valuable time to me...