Search and extract code with popup box

I have a command button in Worksheet ("Timber Quote") and I need it to do the following.

1) Popup a search box. In this box I will type a numeric search string and the search range for the string is worksheet ("Quote Storage") ("B2:Q5000"). If it matters, the search string is in column I.
2) There are several rows to be found that contain the search string. I would like all of them found and copied and special paste values in order of appearance to worksheet ("Timber Quote") starting in cell K25.
3) Next, I would like the rows deleted from where they originated.

Notes: On the input box for the search, I would like it to read "Quote #' and I would like a message box that reads "Could Not Find + the search string number" if the search criteria is not present.

Thanks you very much in advance..

Just learning and I bow down those of you who are here helping.

Forgive me, Kevin, for being blunt ... but you are asking a lot and giving little. No workbook, no code, not even a picture to paint a ... well, picture (even though, generally speaking, they are pretty useless).

You've said you are "Just learning" but you're not going to learn much if you don't try.

Point 1. is just an InputBox
Point 2. (a) is an AutoFilter using the value input at Point 1 to highlight the rows of interest
Point 2. (b) is Copy and PasteSpecial values of the cells highlighted above
Point 3. is just to delete the rows previously highlighted.

Give it a go. Ask questions when you hit a wall.


Regards, TMS