Need Help - Repeat Function with User Input

[jillkfs]

I have been reading this message board for the last 48 hours and you are quite a helpful group! I'm hoping you can help me too.

I am not a programmer, but I have programmed basic scripts and edits before. I usually have to see it done, then I can manipulate what I need. But, I can't find anything similiar in this case..

I was working on something on Friday and figured there HAS to be an easier way. I found the macro, then found a way to add in the user interface, but now I'm stuck.

This is the entire thing I need to do...

I have a worksheet of Employee data. I need to move specifc employees and their data from that worksheet (called 'Query') to a different worksheet (called 'Cliqbook') in the same file.

So, I am first clicking on "Find", then I'm typing in the Associate ID number, then closing the "Find" screen. Then I'm copying the entire row found, then "Copy", then going to the Cliqbook worksheet and clicking on "Paste". I know there is a better way, but I can't figure it out!

Can you help?? Thank you so much for anything you can do!!

 

[jillkfs]

Jindon!! THANK YOU!!!!! IT WORKS! IT WORKS! THIS IS A HUGE time saver for me! I cannot thank you enough! Wow! Wow! Wow!