Looping Macro

[ahuang3433]

Need help with a looping macro.

I have WB1 and WB2 in this scenario.

In WB1, Sheet name (List Search), Column A, I have values from A2 to A10. Range may vary depending on day. I want to create a loop macro where it would copy the first value of column A minus the header, and paste it over to WB2, Sheet(List Search), Next empty cell in Column A. Once that is done I was to be able to call for a macro (x) to run. Once the macro is done running I want to start the next A3, then A4 and so forth. Any help would be great.

Thanks!

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[ahuang3433]

https://www.mrexcel.com/board/thread...macro.1163156/

[ahuang3433]

Scratch what I've request above. I have two sample files attached here and if this can be done then I'll be good. Basically what I want is take A2 value of Test1 file, and filter on Test2 file. Then I'll have a code that would run after that. Once the code is done running, it will proceed to A3 Value. Let me know if this simplifies it or not.