Extract values based on a predetermined list into a different sheet

Good day fellow Excelforum users,

I've been working on a template to create counting lists for myself. The way I intended for this to work is as follows:

All the values listed in the sheet "Scheduling" are entered manually depending on which items I would schedule for counting, and these are also the values which need to be extracted from the sheet "Stocklist" and copied over to the sheet "Counting".

The code I posted below does exactly what I want, but it requires each value to be entered manually (and the way the VBA works right now is that it clears the sheet "Counting" after every time new data is extracted). I'm not certain how much rewriting it would require for this code to look at the list of values starting in A2 of the sheet "Scheduling", and instead going through these values on it's own instead of asking for each value to be input manually.

So, in short:

1. Look at all the values in the sheet "Scheduling", starting at A2 and possibly running down to A500 (slight exagerration, but more futureproof)
2. Find all the occurances of these values in the sheet "Stocklist" (The values for which to search will always be found in column A:A of this sheet). Copy any matching records (A:D)
3. Paste all these matching occurances into the tab "Counting" (Starting at B3:E3)

Please Login or Register  to view this content.

Credits to Steffen Thomsen and tigeravatar for helping me with an old problem which this code was originally created for, I've found many uses for it.

Attached is the barebone template. I'm most grateful for any and all feedback.

Try the attached.