Hi everybody.
i have a userform with 5 textbox, in the last 2 textboxes, i have date and time consecutively.. i have already insert a vb code which will enable me to transfer data to a worksheet. it works fine, i want to have a vb code so that when for e.g, i insert 1248(employee no.) in the first textbox, all which follows the next 4 textboxes will enter in spreadsheet 1248 when i click on post button, and the form will be cleared.same for the other employee number. i have already did it refer as attachment, but all enters in the same worksheet.I already rename 5 spreadsheet 1248,1243..etc. how to transfer the employee number to its specific worksheet i.e 1248,1243..., as i really dont know how to do it, or if its possible
Please help me, its important , im trying to do a time clocking.
Thanks all
Bookmarks