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.
Bookmarks