I have 3 sheets in my file.

1. "Data" , in this one i have the employee information as follow:
A B C
ID NAME CODE
1060051 CHRIS ADAMS 1112
1060101 JOHN SMITH 9875

2. "Menu" i have the buttons with macros to bring up the User Form that i
created previously

3. "Report" In which i have 4 colums , A=ID, B=NAME,C=CODE , D= CITY

So i have a User Form in there I have 1 comobox with the user id in which
you choose the id from a dropdown list, and then i have 3 text boxes, with
the NAME, CODE and City, and one command button which says ADD

Here is what i wanna do, as soon as i choose an ID number, i want the in
the NAME textbox and CODE textbox to bring the actual information from
"Data" worksheet from the ID I chose, and then I will just input the City
manually in Textbox City, and the push the command button ADD, and all this
information (the 4 textboxes) goes to the worksheet "Report".

This is so i can built a report easily.

Anyone can help me.

Thanks !