Hello. I am hoping someone can help me with this. I have a daily worksheet extracting a large amount of data (potentially 200K rows) on Sheet1. This range will vary daily. I would like to have a user form on Sheet2 which the user would input the value they wish to look up. This value could be found on Sheet1 in either column A or B. I would then like to have the row containing that value, copied over to Sheet2 with the user form, They would then enter the next lookup value using the form, and the data for that record on Sheet1 would get copied in underneath on Sheet2 until they are finished. Can this be accomplished? I am really not sure where to start.