how to define this method or property in form

It is Hard to duplicate the problem without the workbook.....

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

hi
i am giving the credit for this code to this forum.in some anther thread they get their solution.and i am using their form which is very similar to my requirement. here is my thing
i have two WB one is month.xls which update daily and at the end of the day i save the data in WB At C:\data\Daily Data.xls manual.instead of doing manually i try to learning some and by help from guru like u try to do some automation. to add button to copy the sheet and paste the data in new sheet in WB Daily Data here i atteching the WB which sheet "01" i want to copy the code work till creating new work sheet in WB and name as in combo box value bu it not copy the data.
i hope u will help me
thanks

Is there another workbook you want the information sent to?