Hello, Helpers!

I am trying to compile a single master list of unique numerical records archived in hundreds of old workbooks.

I recorded a macro and got this code out of it:

Please Login or Register  to view this content.
Tweaks are needed. How do I make it paste the first archive's data in A1 to A?, the next archive's data starting in the next empty cell in Col A, and so forth, so I don't have to keep positioning the cursor?

Second, is it possible to have Excel go through a folder automatically repeating the above process until it runs out of files?

You guys have been a great help so far. I look forward to a solution.

Thanks!

Arlen