I am having difficulty with an Excel macro. I have an XLS with about 500 rows. (Col A is a unique ID). I have to from time to time extract various rows (yes, based on unique ID) and copy them to another sheet. I may do this three or 10 times/day. The content is never the same. I am trying to write a macro to let me key in each ID (press enter) and then when done, press a button, close. Each ID's row would be copied to sheet 2 and can be handled accordingly. This doesn't seem like a complicated macro, but being new to VBA, I am having a devil of a time. I've gotten it to clear sheet 2 before I start, but am having trouble getting it to keep asking for IDs until I stop.