Hi guyz!

Here it goes.

I have a worksheet with data populated by MS Query, example of data are Employee Name, Employee ID, department, position and so on. These data are displayed in a worksheet. Whenever I refresh this sheet or put the employee ID (using MS Querry parameter) it displays the employee details in that worksheet. (note: only 1 particular employee)

Here is the question.

Is there any way that I can get this data (e.g. EmpName, EmpNo, department, position ) put to another sheet? What I need is every time I refresh the sheet the data of an employee goes to another sheet, listing all the employees I got from the query result.

For example: I type empNo 4192 in the parameter query, it displays Dave Ranco, EmpID 4192, HR Executive, HR department and so, then I refresh and type another emplID and another empId. I want these details to be listed in another sheet like this

A B C D
1 4192 Dave Ranco HR Executive HR department
2 4178 Kyle Scoch Finance Asst Finance department.

I hope I explained it well.

Thanks in advance
ane