I have form in sheet1 detailed should come in sheet2



like
name department EL CL Date etc in column

Your post is almost devoid of meaning. Neither I nor anyone else is likely to get any idea of what you want to do.

We are not mind readers. You've told us nothing about the structure of your workbook (except that is has at least 2 worksheets) or the layout of your worksheets.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

find the attachment, "excel form" in excel form if we press save & new button form data should save in sheet2, and clear the form

like msaccess forms, if we enter data in forms they goes into the table like i need

Attached Files

Emp info.xlsx (13.1 KB, 10 views)

There are plenty of examples of how to do this that are readily available on the web for you to adapt to your own needs. See, for example: http://www.contextures.com/xlForm02.html. It is time you started trying to do these things for yourself instead of expecting to come here and have someone else do all the work for you. This forum is not simply a free coding service.

Show us that you are making an effort to learn by doing.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]