Copy and paste a column one cell at a time

Hello all,

I'm writing a macro that has to look at a column on sheet 1 (the column will have a different number of cells each time), and systematically paste each value one at a time into a single destination on sheet 2. In between each paste, I have to call another macro (which I already have the code for). After the outside code performs its function, I need the next line in the column to paste to the same destination, so on and so forth.


Any help would be greatly appreciated.


Thank you in advance.

Hello and thank you so much for responding. As requested, I attached a sample workbook that should help to more easily describe the desired macro. The list (on tab "Paste Source") just needs to paste, one at a time into cell C8 on "Paste Destination". In between each paste loop, another macro is called. So the loop would go like this:

Store 1 is copied from source to destination. Macro called ect, then store 2 is pasted, macro called, so on so fourth.

Again, than k you so much for your help.