hi! I have data in column a in sheet 1. there is a number in cell a1, a16, a31 and so on... the cells are evenly spiliy by 15 blank rows in between them
I would like to copy the cells I have in sheet 2 range a1:a14 and paste it under cell a2, then paste the same range (a1:a14) under cell a16 and so on... essencially taking the range from sheet 2 and pasting it under every cell with a number in it in sheet 1. there is a different number of cells with text in sheet 1 each time i would run the macro but the range that is to be copy and pasted from sheet 2 will be constant.
can anyone help me with this code!??!?! please please please
Bookmarks